Previous Job
Previous
Senior Data Modeller
Ref No.: 18-24161
Location: New York, New York
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 Client 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