Senior Specialist, Data Modeler; Microsoft

Ready to build a rewarding career in an industry that is growing?

We are a global mining company dedicated to safely delivering nickel, copper, cobalt, and platinum group metals essential for the world’s energy transition. Our mission is to improve lives and shape a better future together. From utensils to cellphones to satellites, our operations simplify daily life and enhance connectivity. Our metals are integral to life‑saving medical equipment and the electric vehicles driving the fight against climate change – our work truly matters.

Join our diverse team of 15,000 talented individuals committed to transforming critical minerals into prosperity and sustainable development in countries like Canada, Brazil, Indonesia, the United Kingdom, and Japan. We invite you to use your skills with us and contribute to something meaningful and enduring.

Senior Specialist, Data Modeler (Microsoft) is responsible for designing, developing, and maintaining scalable data models, ETL pipelines, and analytics solutions using Microsoft and modern data platforms in Toronto, ON
. This role ensures that enterprise data is reliable, governed, and optimized for reporting, analytics, and AI‑driven decision‑making. The incumbent plays a critical role in enabling business intelligence, operational efficiency, and strategic planning by transforming complex data from multiple sources—including databases, APIs, IoT devices, and applications—into structured, high‑quality datasets. Working closely with data scientists, developers, analysts, and business stakeholders, the Senior Specialist ensures that data solutions are performant, scalable, and aligned with enterprise data governance standards.

You will report to the Manager, Data Reporting and Visualization and collaborate with cross‑functional teams including Data & AI, IT, business stakeholders, and external vendors.

You are a modern, hands‑on data modeler and builder with deep expertise in Microsoft and Azure data platforms. You are comfortable owning the full lifecycle of data solutions—from raw data ingestion to transformation, modeling, and delivery into semantic layers and reporting tools. You bring strong technical proficiency in SQL Server, Azure Data Factory, Databricks, and ETL frameworks, with proven experience building end‑to‑end pipelines, scalable data models, and Power BI semantic layers.

You thrive in a fast‑paced, evolving environment where you can design and implement solutions—not just define them. You are equally comfortable working with engineers, data scientists, analysts, and business stakeholders to translate requirements into performant, governed, and scalable data solutions. You are passionate about enabling self‑service analytics, AI/ML readiness, and high‑quality data products.

• Own and deliver the full data lifecycle: ingestion, transformation, modeling, and delivery.
• Build and manage end‑to‑end data pipelines from source systems to reporting and semantic layers.
• Design and implement scalable, reusable, and production‑grade data solutions.
• Support multi‑domain data platforms and enterprise data assets.

• Design, develop, and maintain scalable data models across SQL Server, Azure Data Platforms, Databricks, and Analysis Services / semantic layers.
• Develop models optimized for reporting, analytics, and AI/ML use cases.
• Design models supporting drill‑down, drill‑through, and self‑service analytics.
• Ensure models are high‑performing, fault‑tolerant, and aligned with governance standards.
• Structure and prepare data for advanced analytics and machine learning pipelines.

• Build robust ETL/ELT pipelines using Azure Data Factory, Databricks, and SQL‑based frameworks.
• Ingest data from diverse sources (databases, APIs, files, applications, IoT, etc.).
• Transform and curate data into trusted, high‑quality datasets.
• Optimize pipelines for scale, reliability, and performance.
• Automate workflows and reduce operational overhead.
• Work within Azure environments (resource groups, storage, compute, services).