Power BI XML Schemas Data Analysis SQL Knowledge SQL Server DB2 LUW DBA RDBMS Meta   Requirement id 92124 Job title Modeler Job location in Brooklyn, NY Skills required Data Models, Data Modelling, Data Mapping, Power BI XML Schemas Data Analysis SQL K Open Date 08-May-2019 Close Date Job type Not specified Duration 36 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Modeler: Data Models, Data Modelling, Data Mapping, Power BI XML Schemas Data Analysis SQL K Note: Email Submission Note: Vendors may only submit a total of one (1) candidate Submission Deadline: 5/28/2019 5:00 PM EST Start Date: 8/1/2019 End Date: 7/31/2022 Client: New York City Employees Retirement System (NYCERS) Description: Justification: The Data Modelers role is to create an Enterprise Data Model for all NYCERS databases and maintain metadata repository of its components. This is essential to establishing the entire universe of Critical Data Elements currently in use and understanding the nature and purpose of each for the data profiling and migration exercise. NYCERS IT will leverage the Data Model and Source-to-Target mappings in automated processes that retrieve the data and prepare it for Legacy Replacement initiative and other mission critical applications. 1. Mandatory Skills: Candidates must meet all the requirements below to be considered for this position: • Must have excellent interpersonal, communication, presentation, writing, analytical, problem solving, and information gathering skills along with fundamental technique troubleshooting abilities. • Minimum of five (5) years of experience in designing data models of various complexity to meet strict requirements of the Retirement system. • Experience in data modeling principles/methods including conceptual, logical & physical data models. • Proven experience creating optimal physical data models of datasets, creating and maintaining data maps and systems interrelationship diagrams for data domains and systems. • Experience defining and governing data modeling and design standards, tools, best practices, and related development methodologies for the organization. • Ability to clearly communicate complex technical ideas, regardless of the technical capacity of the audience. • Ability to utilize Business Intelligence tools (e.g. Power BI) to represent data profiling insights. • Experience working with dimensionally modeled data. • Experience in translating/mapping relational data models into XML and Schemas 2. Preferred Experience: • Experience with legacy and unstructured data. • Ability to quickly learn and adapt modeling methods from case studies or other proven approaches. • Experience extracting business rules from the existing legacy code. • Experience with Data Analysis and Modeling tools (e.g. RAA, ERWin, ER/Studio, Data Architect, etc.) • Strong SQL knowledge working with complex queries and stored procedures. • RDBMS platforms (e.g. SQL Server, DB2 LUW) 3. Assumptions Regarding Consultant Tasks and Deliverables The Data Modeler shall provide NYCERS Data Management with expertise creating customized solutions based on the business needs and overseeing data governance processes across multiple Units as well as NYCERS ongoing process improvement programs. The following deliverables shall apply: • Participate in identification, inventory, and classification of NYCERS Critical Data Elements • Analyze the existing data structures and identify sources of incoming data • Design and implement conceptual, logical and physical data models • Maintain Enterprise Data Model/Repository. Identify and document data lineage • Make recommendations for standardization and proper data usage • Closely interact with project stakeholders to ensure that data is properly sourced, used and maintained within DGB standards across the organization.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 92124 while calling.   Other jobs in NY: Albany (4), Bethpage (6), BUFALLO (1), Buffalo (6), Commack (4), Commack Long (1), Jericho (5), Long Island (4), Long Island City (2), Manhattan (5), Midtown NYC (1), New York (41), New York City (8), NYC (2),    Data Models job openings in other states Jobs List NCDIT - Specialist- Mid Level (741475) Create date: 16-Jul-2024 * Remote No of Submissions : 2 Start date : 07/12/2024 End Date : 07/19/2024 Submission deadline : 07/22/2024 Client Info : NCDIT Note: * Webcam Interview Only * This is a remote position for the duration of the engagement. If the candidate is local theyd like h.... (This job is for - Healthcare Jobs in NC Raleigh Specialist - (in Raleigh, NC)) VSP - Data Analyst 4 (736036) Create date: 08-May-2024 Hybrid Max Submittals by Vendor: 2 Start date : 06/03/2024 End Date : 04/30/2025 Submission deadline : 5/13/2024 Client Info : VSP Description : ------------------------------------------------------ VSP is seeking a skilled Data Analyst to join our team andplay a crucial.... (This job is for - job Jobs in VA NorthChesterfield Analyst - (in North Chesterfield, VA)) VSP - Data Analyst 3 (729526) Create date: 12-Feb-2024 Hybrid Start date :03/04/2024 End Date : 02/28/2025 Submission deadline : 2/15/2024 Client Info : VSP Description : ------------------------------------------------------ VSP is seeking a skilled Data Analyst to join our team and play a crucial role in the Data Migration project for t.... (This job is for - job Jobs in VA Chesterfield Analyst - (in Chesterfield, VA)) DCH Senior Cloud Database Architect (721859) Create date: 11-Oct-2023 Hybrid start date :10/23/2023 End date :10/16/2024 submission deadline :10/17/2023 client info :DCH Description : The Georgia Department of Community Health (DCH) is in the process of replacing its legacy data warehouse / decision supp.... (This job is for - Snowflake Jobs in GA Atlanta Architect - (in Atlanta, GA)) Technical Specialist- Senior (EHR RCM BI Developer) (714005) Create date: 11-Jul-2023 Hybrid Start date :07/17/2023 End Date :07/16/2024 Submission deadline :07/21/2023 Client Info :NCDHHS-AM Description : ------------------------------------------------------ ONLY CANDIDATES WITH COGITO FUNDAMENTALS AND ACCESS DATA MODEL CERTIFICATION Business Intelligence.... (This job is for - EPIC Jobs in NC Durham Specialist - (in Durham, NC))    Data Models job openings in NY Jobs List Expert IT Specialist - 5666 Create date: 28-Oct-2021 Description: Day-to-Day Tasks include, but not limited to: Develop and maintain logical and physical relational data models for OLTP systems using erwin and Visual Studio Database Projects. Generate and publish data definition language (DDL) from physical data model to Azure cloud-based and/or on-premises SQL Serv.... (This job is for - ETL Jobs in NY Albany Specialist - (in Albany, NY)) Database Architect - 4353 Create date: 19-Nov-2020 On-site/Remote : On-site Interview : Phone or video call Description: Responsibilities Are you an expert in an industry vertical or specific technology? Then you should contact us! We have a 24-month project with our client in NYC, NY that requires a Database Architect, Expert Day-to-Day Tasks .... (This job is for - job Jobs in NY NewYorkCity Architect - (in New York City, NY)) ETL Technical Architect - NTTJP00022839 Create date: 28-Jun-2019 start date:08/15/2019 End date:08/14/2021 submission deadline:8/9/2019 Description: we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our companys growth, market presence and our abi.... (This job is for - Obiee Jobs in NY NewyorkCity Architect - (in Newyork City, NY)) (Modeler: Data Models, Data Modelling, Data Mapping, Power BI XML Schemas Data Analysis SQL K in Brooklyn, NY)

Featured Jobs Developer (Jobs in Atlanta, Georgia) Data Architect ETL Specialist (Jobs in Raleigh, North Carolina) SQL Architect (Jobs in Richmond, Virginia) Business Analyst Financial Analyst (Jobs in Fredericksburg, Virginia) Cyber Architect (Jobs in Columbia, South Carolina) VxRails Consultant (Jobs in Boise, Idaho) Project Manager Microsoft Manager (Jobs in Raleigh, North Carolina) Agile Jira UAT Manager (Jobs in Atlanta, Georgia) - - Analyst (Jobs in Portland, Oregon) HTMLCSSJavaScript Developer (Jobs in Lincoln, Nebraska)