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:





- Solid 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

📌 Data Modeler (dimensional modeling, snowflake, Data Vault, medallion) (Canada)
🏢 Experis
📍 Canada