Job Description :
Hi

Job Title: Data Modeler
Location: Oakland, CA
Duration: Long-term
Job Description:

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.

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