Description

You will own the design and delivery of enterprise data models across operational and analytical domains.

Responsibilities

• Design conceptual, logical, and physical data models supporting single-source-of-truth principles.
• Establish and maintain modeling standards, including naming conventions, SCD2 strategies, and lineage documentation.
• Develop detailed source-to-target mappings aligned with model definitions for data engineering.
• Validate model performance characteristics and recommend indexing, partitioning, and clustering strategies.
• Serve as a trusted advisor, translating business requirements into supported data structures for stakeholders.

Required Skills

• 7+ years of progressive experience in data modeling, database design, and data architecture.
• Demonstrated expertise with relational and dimensional modeling (3NF and star schema design).
• Proficiency with cloud-based modern data stack environments (Azure preferred).
• Strong proficiency with SQL for model validation, profiling, and optimization.
• Experience with data modeling tools such as ER/Studio, ERwin, or equivalent.
• Hands-on experience supporting data warehouses, data marts, and metadata-driven modeling.
• Experience supporting data ingestion, CDC design patterns, and SCD2 data history strategy.
• Knowledge of Data Modeling, Cloud Computing, Windows Azure, AWS, and Databricks.

Key Skills

Education

Bachelor's or Master's degrees