Previous Job
Previous
Senior Data Modeler
Ref No.: 18-19693
Location: New York, New York
Year long contract

Job Title: Senior Data Modeler

Spend Management Technology supports the Re-Engineering and Expense Mgmt businesses which are responsible for the Firm's sourcing, contracts, procurement, invoicing, and accounts and third part risk functions. The goal of Spend Mgmt Technology team is to provide an effective and integrated end-to-end solution for the Source to Pay process and to enable transparency into the Firm's spend on goods and services in order to identify opportunities for saving and cost reduction.

The Senior Data Modeler is responsible for Logical and Physical Modeling in Power Designer/Erwin for a highly scalable data warehouse. Understand the dimensional/relational modeling techniques and bridge the gap between the OLTP developers, data warehouse developers and DBA teams.

Roles and Responsibilities:
* Translates and transforms business requirements into data models (Conceptual, Logical and Physical)
* Analyze source system data using profiling tools.
* Capability to design models for OLTP and Dimensional modelling
* Interacts with OLTP systems and translate relational models into dimensional models.
* Maintains Data Model repository.
* Drives conversations with development teams and DBA teams to optimize the schema structure and ingestion processes influencing the write and read performance.
* Executes and provides feedback for data modeling policies, procedure, processes and standards.
* Evaluates Database and data and develop the data model appropriately
* Assists with capturing and documenting system flow and other pertinent technical information about data database design and/or systems
* Design data models in Data Modeling in Power Designer

Skills:
* 10+ years of data modeling experience;
* Database experience in DB2 preferred
* Power Designer is a must
* Ability to develop stored procedures and SQL scripts as required
* Any Informatica skills a plus
* Experience with unit testing, release procedures, coding design and documentation protocol;
* Knowledge of IT fields and computer systems;
* Understanding of the systems development life cycle;
* Ability to manage tasks independently.
* Knowledge of basic Agile terminology and practices such as User Stories, Backlog, Scrum, and Acceptance Criteria.
* Experience with an Agile Tool, specifically JIRA is a plus
* Previous Brokerage experience a Plus.
* Excellent written and oral communication skills for managing interactions both within the team and without.
* Very strong attention to detail and organizational skills.
* Strong work ethic