Role Summary
Seeking a Senior Data Modeler with strong expertise in enterprise data modeling, data warehousing, ANSI-SQL, dbt and Snowflake. The role involves designing scalable, governed data models supporting analytics, reporting, integration and data modernization initiatives.
Key Responsibilities
- Develop Conceptual, Logical and Physical Data Models.
- Design Dimensional, Star/Snowflake, 3NF, Data Vault 2.0 and Hybrid models.
- Implement Historical/Temporal Modeling, SCD, Fact, Event, Master and Reference Data models.
- Create Data Dictionaries, Business Glossaries, Metadata and Business-to-Data mappings.
- Perform data profiling, source-to-target mapping, transformation and reconciliation for migration/modernization projects.
- Collaborate with architects, engineers and business stakeholders on data architecture and solution design.
- Ensure data models meet governance, quality, performance and scalability standards.
- Support modern cloud data platforms and lakehouse/Medallion architectures.
Mandatory Skills
ANSI-SQL | dbt | Snowflake | Data Modeling | Data Warehousing
Good to Have
Data Vault 2.0 | SCD | Data Governance | Data Lineage | Data Migration | Lakehouse | Medallion Architecture
