Senior Data Modeler
Jersey City, NJ
" 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
" 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