Job Description :
· Translates and transforms business requirements into data models (Conceptual, Logical and Physical)

· Analyze source system data and profile data as needed.

· Design dimensional and NoSQL data models for the analytics platform.

· Maintain relational data model repository in Erwin as well as NoSQL data models.

· Design dimensional and relational data models using Erwin

· Provide insight, best practices and standards for NoSQL data modeling as well as assist in data modeling tool selection.

· Drive conversations with development and DBA teams to optimize the schema structure and ingestion processes influencing the write and read performance.

· Provide assistance to project teams on data modeling policies, procedure, processes and standards.

· Provide recommendations to enhance current DA standards as necessary or develop standards for new technology implementations.

· Enforce and follow established data governance and consistency in the data model and standardization of business definitions

· Knowledge of DBMS platforms (e.g. Redshift, SQL Server, NoSql, Cassandra) with experience in generating DDL as needed