Job Description :
Position : Data Modeler
Location : New York, NY
Duration : 19 Months Contract
Interview-Type : In-Person

SCOPE OF SERVICES :
Document a complete and thorough analysis of the data model requirements of the program across all workstreams. Data model requirements will include an analysis of the "as-is" and "to-be" needs of the program. In addition, requirements will include a fit/gap analysis of a selected COTS solution, including the out-of-the-box, configurable, conditional and customized data capabilities.
Research the industry, and provide quantitative and qualitative assessments of issues and potential initiatives, including an evaluation of best practices.
Elicit requirements by interviewing business owners/stakeholders to understand business needs, processes, and data sources, conducting interface analysis, reviewing documentation and utilizing other techniques set forth in the BABOK.
Translate business needs into clearly defined and documented detailed requirements.
Spearhead the prioritization, solution assessment and validation of requirements with the business and technical project teams.
Develop analysis documentation, including fit/gap analysis of NYC requirements to vendor out-of-the-box/ configurable functionality, data dictionaries, and use cases.
Align NYC requirements with enterprise standards to maximize the value of off-the-shelf components.
Assist stakeholders in navigating "as-is" vs. "to-be" decisions.
Validate Vendor/SI design and implementation of relevant functional areas.
Support Quality Assurance/Testing team to obtain user acceptance signoff in relevant functional areas.
Support Quality Assurance/Testing team to obtain user acceptance signoff in relevant functional areas.
High-level Business Requirements
oBusiness Process flows and Business Rules
oFunctional Design Document / Functional specifications
oData Model & Dictionary
oMap of data to be configured / customized and placed on forms within the COTS solution.
oError Messages Inventory
oContent Inventory
oAssist with QA Plan & Acceptance Criteria.

SPECIAL REQUIREMENTS :
References should be provided from at least two former or current clients where the contractor has performed the same or similar work.  Provide the name, address, phone number and e-mail address of the reference as well as a brief description of the work performed

Job Description :
Four (4) plus years of experience as a Data Modeler.
At least 7 years of overall work experience in gathering business and functional requirements pertaining to Data Modelling
Experience in working on and implementing multiple vendor/COTS solutions in the functional domains of data modeling
A mix of private sector and public-sector experience at federal, state or large municipal government levels
Proven experience with projects in multiple-entity environments (multiple agencies, business partners, etc
Experienced oral and written communication/soft skills and the ability to clearly articulate to all project members and stakeholders;
Must be a team player who works well with technical and a wide of variety non-technical resources at different levels of the organization
Experience with UML/ER data modeling and development from conceptual to logical to physical models
Experience with STAR and SNOWFLAKE schema
Extensive experience with RDBMS and experience with Oracle, SQLServer, MySQL, Postrgres, Amazon Redshift
4 years of extensive hands-on experience in ERWIN/ER-Studio/Toad Data Modeler data modeling tool.
Extensive experience in managing the metadata and data lineage from Conceptual to Logical to Physical data model
Expert in SQL and querying across various database structures (e.g. MDX queries
Experience with data warehouse and BI architecture
Experience with OLAP and BI tools (Cognos, Oracle 12c BIEE, TMI)
Experience with modeling for large scale distributed systems dealing with data chunking, key-valued pairs, etc.
Must be able to take strategic direction from executive management and participate in strategic planning activities throughout the lifetime of the project.
Must be able to see tasks through to completion without significant guidance
Experience using standard project tools including MS Project, PowerPoint, Visio, and Excel.

Desirable Skill/Expertise :
Familiarity with New York City’s data share platforms, including Open Data (DOITT’s DataShare platform 
Familiarity with New York City’s financial and procurement systems (FMS, PIP, VENDEX, and APT 
Experience in business intelligence tools, including IBM Cognos, Oracle BI, Power BI, Opera Solutions, OBM Watson Analytics 
Knowledge of National Information Exchange Methodology (NIEM) 
Prior on-line database systems experience (i.e. PostgreSQL, MySQL, etc 
Prior on-line database systems experience (i.e. PostgreSQL, MySQL, etc 
Experience in object-oriented languages (i.e. Java, C#, etc  
Experience in scripting languages (i.e. VBA, PowerShell, Python, etc 
Knowledgeable in several multi-dimensional and data mining techniques such as EDW, ODS, DM, OLAP and MOLAP 
Familiarity with Agile and SDLC project methodologies
Use of software development collaboration tools, including Jira, Slack, Team Foundation, and Base Camp
Proficiency in systemic data clean-up techniques

Client : State of NYC