Job Title or Location
RECENT SEARCHES

Senior Specialist, Data Modeler (Microsoft

Posted today

Job Details:

In-person
Full-time
Experienced

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 senior-level data modeling professional with deep expertise in Microsoft data platforms, cloud-based data architecture, and modern analytics ecosystems. You have strong experience working with large-scale, complex data sets and building high-performance data models to support reporting, analytics, and AI use cases.
You bring strong hands-on technical skills in SQL Server, Azure Data Factory, Databricks, and ETL frameworks, combined with a solid understanding of data governance, architecture, and performance optimization.
You are a collaborative partner who can work across technical and business teams, translating requirements into scalable data solutions. You are comfortable guiding power users, supporting democratized data environments, and driving best practices in modeling, governance, and performance.
You are passionate about improving data quality, enabling AI and advanced analytics, and delivering impactful insights through dashboards, reporting, and data products. In This Role, You Will: Data Modeling & Architecture
  • Design, develop, and maintain scalable data models across Microsoft ecosystems (SQL Server, Analysis Services, Databricks, ADF)
  • Integrate data from multiple sources including databases, APIs, files, applications, and IoT devices
  • Build efficient models for reporting, analytics, and AI solutions
  • Design models that support drill-down and drill-through reporting functionality
  • Ensure models are fault-tolerant, recoverable, and optimized for high performance
  • Align models with enterprise data governance and architecture
Data Engineering, ETL & Platforms
  • Identify data sources and collaborate with developers to build ETL pipelines
  • Develop ETL processes using SSIS, ADF, Databricks, and related tools
  • Automate workflows to improve reliability and reduce manual intervention
  • Optimize pipelines and models to process large datasets efficiently
  • Support data integration with Data Lakes, Data Hubs, and enterprise platforms
Reporting, Analytics & BI
  • Design and support data models for Power BI and enterprise reporting tools
  • Build and optimize reports, dashboards, and visualizations
  • Ensure data accuracy, integrity, and performance across reporting solutions
  • Collaborate with stakeholders to gather requirements and deliver insights
  • Enable data-driven decision-making across business functions
Advanced Analytics & AI Enablement
  • Collaborate with Data Scientists and Engineers to support machine learning solutions
  • Prepare and model data for predictive analytics, anomaly detection, and AI use cases
  • Build pipelines and models supporting advanced analytics initiatives
Stakeholder, Vendor & Governance Engagement
  • Act as a trusted advisor on data modeling, reporting, and analytics best practices
  • Guide power users and democratized teams on governance and performance optimization
  • Collaborate with vendors, infrastructure teams, DBAs, and developers
  • Ensure compliance with data governance, privacy, and security standards
  • Evaluate vendor deliverables and support production rollouts
Documentation & Change Management
  • Create and maintain comprehensive documentation (models, mappings, architecture)
  • Provide training and knowledge transfer to stakeholders and peers
  • Support communication, presentations, and change management initiatives
  • Contribute to continuous improvement and data maturity programs
Education:
  • Bachelor's degree in Computer Science, Data Science, Software Engineering, or a related field
Certifications (Preferred)
  • Azure Cloud Certifications
  • Microsoft (ADF, SSIS, Analysis Services) Certifications
  • Databricks Certifications
  • Data Modeling / Data Engineering Certifications
  • Data Visualization or BI Certifications
  • AI / Machine Learning Certifications
  • Certified Data Management Professional (DAMA)
Experience:
  • 8–10+ years of experience in data modeling, data engineering, or analytics roles
  • Strong hands-on experience with Microsoft data stack (SQL Server, SSIS, SSAS, ADF, Azure, Databricks)
  • Experience building ETL pipelines, data models, and reporting solutions
  • Experience supporting BI, analytics, and AI/ML use cases
  • Proven ability to work across complex, multi-stakeholder environments
  • Experience collaborating with vendors and cross-functional teams
  • Experience in mining, heavy industry, or similar domains is an asset
Skills:
  • Expert data modeling and ETL development skills
  • Strong proficiency in SQL, Python, and data scripting languages
  • Deep understanding of cloud data platforms and architecture (Azure preferred)
  • Strong knowledge of data governance, data quality, and security practices
  • Experience with BI tools such as Power BI and data visualization techniques
  • Ability to analyze complex datasets and translate into actionable insights
  • Strong communication and stakeholder engagement skills
  • Project management, prioritization, and problem-solving capabilities
  • Ability to work in agile, fast-paced, and evolving 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 TorontoToronto, 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 TransformAt 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: F2TMinimum Starting Salary: CAD $119,000Apply by: Friday, Jun 05, 2026#ValeBaseMetals
Competition Number: 42044770
Company Website: http://valejobs.ca

Share This Job:

About Vale Base Metals

About Vale Base Metals

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.

Visit Employer Showcase