Remote - Canada Contract Our client is a data consultancy working primarily with organizations in the manufacturing sector, helping them modernize their data platforms on Microsoft Azure. They're looking for a Data Modeller to own the design layer across client engagements. This is a 6-month contract chance starting in November 2026, with potential for extension.

The engagement is fully remote, and the successful candidate can be located anywhere in Canada. Our client is a data consultancy working primarily with organizations in the manufacturing sector, helping them modernize their data platforms on Microsoft Azure. They're looking for a Data Modeller to own the design layer across client engagements.

This is a 6-month contract opportunity starting in November 2026, with potential for extension. The engagement is fully remote, and the successful candidate can be located anywhere in Canada. Develop conceptual, logical, and physical data models for Azure Synapse warehouse and data mart environments.

Design dimensional models: defining grain, building fact and dimension structures, and handling surrogate keys and slowly changing dimensions. Make normalization and denormalization decisions based on how the data will actually be queried. Profile client source systems to understand content, quality, and relationships before modelling against them.





Analyze existing ETL and SSIS logic during Synapse migrations to recover embedded business rules, and design the target model that replaces them. Catalogue data assets and build out metadata repositories. Partner with architects, technical leads, and business teams to translate business questions into structures that answer them. 4+ years in a data modelling or warehouse design role, with models you've taken from requirements through to production. ~ Hands-on experience modelling for Microsoft Azure Data & Analytics, particularly Azure Synapse, with working familiarity with Azure Data Factory and Azure Data Lake Storage. ~ Strong SQL skills, including complex queries, and solid experience with T-SQL and SQL Server. ~ Experience profiling unfamiliar source systems and reverse-engineering business rules out of existing ETL or SSIS logic. ~ Database performance tuning experience, with a clear understanding of how modelling decisions drive query performance. ~ Proven data warehouse and data mart experience. ~ Strong knowledge of data structures and the ability to extract data from a range of source systems (such as Cognos, Informatica, Hyperion, and similar).

Familiarity with Data Vault or other modelling methodologies.

Relevant Microsoft

Azure data certifications. Exposure to Informatica PowerCenter. PL/SQL experience — the core stack is SQL Server and T-SQL, so this is a bonus.

📌 Data Modeler, Microsoft Stack (Edmonton)
🏢 DevEngine
📍 Edmonton