Description

Key Responsibilities

Design end-to-end data architecture and solution architectures supporting enterprise business and technology initiatives.

Develop and maintain Conceptual, Logical, and Physical Data Models.

Translate business and functional requirements into scalable data models and technical solutions.

Define enterprise data structures, relationships, entities, attributes, keys, constraints, and data domains.

Design normalized and dimensional data models, including Star and Snowflake schemas.

Develop data models for operational systems, data warehouses, data lakes, and analytical platforms.

Collaborate with Data Engineers to ensure physical data models can be efficiently implemented through ETL/ELT pipelines.

Define data integration patterns between applications, databases, APIs, cloud platforms, and enterprise data stores.

Establish data architecture standards, modeling standards, naming conventions, and best practices.

Analyze existing systems and perform source-to-target data mapping and data lineage analysis.

Identify data-quality issues, redundancies, inconsistencies, and opportunities for data-model optimization.

Data Modeling Responsibilities

The Data Modeler portion of the role would typically include:

Conceptual Data Modeling

Logical Data Modeling

Physical Data Modeling

Entity Relationship Diagrams (ERDs)

Data dictionaries

Metadata management

Data lineage

Source-to-target mapping

Data normalization and denormalization

Dimensional modeling

Star/Snowflake schemas

Master and reference data

Data governance and data quality

Database performance considerations

Data integration and transformation requirements

Key Skills

Education

Bachelor's degree