Data Modeler (dimensional modeling, snowflake, Data Vault, medallion)

Data Modeler (dimensional modeling, snowflake, Data Vault, medallion)

Contract Duration: 1 year, renewable

Work Location: Remote Work in Canada

Key Responsibilities:

• Design and develop logical, conceptual, and physical data models to support analytics, reporting, and operational use cases
• Apply a wide range of data modeling techniques, including dimensional modeling, Data Vault 1.0 and 2.0, and medallion architecture (bronze, silver, gold layers)
• Collaborate with data architects, engineers, and business stakeholders to gather requirements and translate them into scalable data models
• Create and maintain model documentation, data dictionaries, entity‑relationship diagrams, and mapping specifications
• Optimize data models for performance, maintainability, and scalability within Snowflake
• Partner with data engineering teams to ensure models are implemented accurately and efficiently across cloud data pipelines
• Review and validate existing models and drive improvements based on evolving business needs

Required Skills and Experience:

• Strong experience in dimensional modeling (star schemas, snowflake schemas, fact and dimension design)
• Hands‑on experience designing Data Vault models, including hubs, links, satellites, and DV2.0 best practices
• Solid understanding of medallion architecture and its application in modern cloud data platforms
• Experience modeling for Snowflake, including understanding of:
• Micro-partitions
• Clustering keys
• Variant and semi‑structured data handling
• Strong SQL skills and ability to work with structured and semi‑structured data
• Ability to translate business requirements into scalable, future‑focused data design

Preferred Qualifications:

• Experience with data modeling tools (e.g., ERwin, dbt, Lucidchart)
• Understanding of data governance, metadata management, and master data concepts
• Experience working in cloud environments such as Snowflake on Azure
• Knowledge of performance tuning and cost optimization in Snowflake