Build dimensional models and Business Vault structures in Snowflake based on approved architectural designs
Apply approved business logic and KPI definitions
Partner closely with data engineering teams
Ensure accurate, reliable, and consumption-ready modeled data
Focus on implementation and build execution within Snowflake
Build architect-approved star schemas and subject-area dimensional models
Implement bridge tables resolve many-to-many relationships, hierarchies, and allocation logic
Deliver business-friendly semantic layers optimized for Power BI consumption
Validate modeled outputs for accuracy and completeness
Support SDLC and SOC 1 evidence requirements through clear documentation

Strong hands on experience with Snowflake
Familiarity and comfortability with Data Vault 2.0 methodology
Advanced SQL expertise, including complex joins, window functions, and performance tuning.
Strong understanding of dimensional modeling concepts including SCDs, surrogate keys, and conformed dimensions.
Experience encoding business logic and KPI definitions into curated semantic views.
Experience supporting semantic models and datasets consumed by Power BI and other BI tools
Familiarity with Snowflake governance features including data masking and sensitivity tagging.
Experience supporting production data models through SDLC and incident resolution.
Strong communication and documentation skills.

Data Modeling Engineer

Key skills