Vale Base Metals - 28 Jobs
Toronto, ON
Job Details:
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
- 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
- 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
- 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
- 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
- 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
- Bachelor's degree in Computer Science, Data Science, Software Engineering, or a related field
- 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)
- 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
- 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
- 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