Senior Data Modeler

Jersey City, NJ

Posted: 09/06/2018 Industry: IT Perm Job Number: 11256483
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.

Responsibilities:
" Translates and transforms business requirements into data models (Conceptual, Logical and Physical)
" Analyze source system data using profiling tools.
" Designs dimensional data models for Highly scalable data warehouse.
" Interacts with OLTP systems and translated 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 tools (Power Designer preferred)
" Knowledge of RDBMS platforms (e.G. SQL Server, Oracle, DB2 / UDB, NoSql, MongoDB, Hadoop) with experience in generating DDL

Qualifications:
" 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

Dan Goldberg

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.