Senior Specialist, Data Modeler
The Senior Specialist is responsible for designing, developing, and maintaining scalable data models, ETL pipelines, and analytics solutions using Microsoft and Azure platforms. They will collaborate with cross-functional teams to ensure data is reliable, governed, and optimized for reporting and AI-driven decision-making.
- On-site
- Canada
- Posted Jul 31, 2026
- 1 position
Job summary
Ready to build a rewarding career in an industry that is growing? Who We Are 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. The Opportunity The 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. About You 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. Data Engineering, ETL & Platforms Build robust ETL/ELT pipelines using: Azure Data Factory Databricks 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) Reporting, Semantic Modeling & BI Design and develop Power BI semantic models for enterprise reporting and self-service analytics Build and optimize dashboards, reports, and visualizations Ensure consistency, accuracy, and performance of reporting datasets Enable business users through governed and performant semantic layers Partner with stakeholders to translate business needs into actionable insights Advanced Analytics & AI Enablement Prepare and structure data for AI/ML and advanced analytics use cases Collaborate with Data Scientists and Data Engineers on model-ready datasets Support use cases such as predictive analytics, anomaly detection, and optimization Ensure data pipelines and models are AI-ready and scalable Stakeholder & Governance Leadership Act as a trusted advisor on data modeling, platforms, and best practice Collaborate with cross-functional teams, including IT, Data & AI, and business stakeholders Guide power users in self-service analytics and governance best practices Ensure compliance with data governance, privacy, and security policies Evaluate vendor solutions and support implementation and delivery Documentation & Continuous Improvement Maintain clear documentation of data models, pipelines, and architecture Support knowledge sharing, training, and adoption Contribute to data platform maturity and continuous improvement initiatives Education Bachelor’s degree in Computer Science, Data Engineering, Data Science, or related field Certifications (Preferred) Microsoft Azure Certifications Azure Data Factory / Databricks Certifications Data Engineering / Data Modeling Certifications Power BI / Data Visualization Certifications AI / Machine Learning Certifications Certified Data Management Professional (DAMA) Experience 8–10+ years in data modeling, data engineering, or analytics Strong hands-on experience with: SQL Server Azure Data Factory Databricks Power BI ETL/ELT frameworks Proven experience building end-to-end data pipelines, models, and semantic layers Experience working within Azure environments (compute, storage, services) Experience supporting BI, analytics, and AI/ML use cases Strong experience working in complex, multi-stakeholder environments Skills Advanced data modeling and data engineering expertise Strong SQL and data transformation skills (Python preferred) Deep understanding of Azure data architecture and cloud platforms Experience with Power BI semantic modeling and visualization Knowledge of data governance, data quality, and security practices Ability to design scalable, high-performance data solutions Strong problem-solving and analytical thinking Excellent communication and stakeholder engagement skills Ability to work in agile, fast-paced environments What We Offer You Competitive compensation including a variable annual incentive plan Participation in a competitive Defined Contribution Pension package Comprehensive benefits package (company paid core coverage, health and dental coverage, flex accounts, disability plans, and optional insurances) Leave for all of life’s reasons (vacation, personal, sick, parental) Work culture dedicated to safety, diversity & inclusion, and career growth Employee Family Assistance Program Virtual Healthcare online Online training and career development opportunities Why Toronto Toronto, Canada’s largest city and financial hub, is a center of innovation, commerce, and culture. Known for its diverse economy and vibrant urban environment, Toronto offers unparalleled access to talent, technology, and global connectivity. Our Toronto office serves as a strategic hub for corporate functions, technology development, and business operations. Here, we drive initiatives that support Vale Base Metals’ global operations, leveraging advanced analytics, digital transformation, and strategic planning to ensure operational excellence across all regions. Toronto’s dynamic ecosystem enables collaboration with leading technology partners, universities, and research institutions, fostering innovation in mining and metals processing. This location is integral to shaping the future of sustainable mining and advancing our commitment to responsible resource development. Include to Transform At Vale Base Metals, we are committed to ensuring an inclusive work environment where people feel comfortable to be themselves. Vale encourages everyone to express their ideas and opinions and values the plurality of individual profiles. We want our people to feel that all. We want our people to feel that all voices are heard, all cultures respected and that a variety of perspectives are not only welcome – they are critical to our success. We treat each other fairly and with dignity regardless of race, gender, nationality, ethnic origin, religion, age, sexual orientation, or any other personal consideration that makes us different. Vale is an equal opportunity employer seeking to increase diversity across our operations and improve equal opportunity at Vale and in the mining industry. Accommodation is available throughout our recruitment process for applicants with disabilities. Vale uses artificial intelligence to screen, assess, and/or select applicants for this position. Pay Grade: F2T Minimum Starting Salary: CAD $119,000 Apply by: Friday, Jul 17, 2026 #ValeBaseMetals
What you’ll do
The Senior Specialist is responsible for designing, developing, and maintaining scalable data models, ETL pipelines, and analytics solutions using Microsoft and Azure platforms. They will collaborate with cross-functional teams to ensure data is reliable, governed, and optimized for reporting and AI-driven decision-making.
Requirements
Candidates must have 8-10+ years of experience in data modeling, engineering, or analytics with deep expertise in Azure, SQL Server, and Databricks. A bachelor's degree in a relevant field is required, along with strong proficiency in building end-to-end data pipelines and semantic layers.
Benefits
• Defined contribution pension package • Health coverage • Dental coverage • Flex accounts • Disability plans • Optional insurances • Vacation leave • Personal leave • Sick leave • Parental leave • Employee family assistance program • Virtual healthcare • Online training • Career development opportunities
Listed skills
- Data visualizationPreferred
- Power BIPreferred
- Problem solvingPreferred
- PythonPreferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Data modeling
- Azure data factory
- Databricks
- SQL server
- Power BI
- ETL pipelines
- Data governance
- Python
- Data architecture
- Cloud platforms
- Semantic modeling
- Data visualization
- Predictive analytics
- Stakeholder engagement
- Problem-solving
- Agile methodology
- Data Reporting
- Scalability Design
- Microsoft Azure Certification
- Operational Efficiency
- Workplace Inclusivity
- Pipelines
- Azure Data Factory
- Virtual Health
- Business Operations
- Analytical Thinking
- Energy System Transition
- Advanced Analytics
- Workflow Automation
- Digital Transformation
- Data Curation
- Research
- Apache Flex
- Application Programming Interface (API)
- Agile Methodology
- Artificial Intelligence
- Anomaly Detection
- Microsoft Azure
- Business Intelligence
- Dashboard
- Strategic Planning
- Decision Making
- Communication
- Computer Science
- Continuous Improvement Process
- Data Architecture
- Data Engineering
- Data Governance
- Extract Transform Load (ETL)
- Data Transformation
Job areas
- Data & Analytics
- Technology
- Software
- Engineering
- Energy
- Data Modeler
- Data Scientist
- Systems Analysts
- Data Scientists
Additional details
- Minimum education
- Professional degree
- Minimum experience
- 10+ years
- Posting language
- English
- Working hours
- 40 hours per week
