Senior Specialist, Data Modeler (Microsoft
$119k per yearFull-time
Vale Base Metals
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 . In This Role, You Will End-to-End Data Solution Development
- 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
- 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
- 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)
- 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
- 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
- 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
- Maintain clear documentation of data models, pipelines, and architecture
- Support knowledge sharing, training, and adoption
- Contribute to data platform maturity and continuous improvement initiatives
- Bachelor's degree in Computer Science, Data Engineering, Data Science, or related field
- 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)
- 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
- 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
- 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
Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Senior Specialist, Data Modeler (Microsoft in Toronto, ON vacancy
$72k - $108k per year
...Job Type: Permanent Work Model: Hybrid Reference code: 133523... ...day look like? As a Senior Consultant, you will have the... ...tracking. Dive into financial data, scrutinize accounting records... ...Deloitte's valuation specialists provide complete and objective...SeniorPermanent employmentInternshipFlexible hours- ...Senior Modeler Join us on our journey and help us create our next unannounced linear adventure game which is set in historical China and features a realistic visual style and authentic traditional combat gameplay. The project is making use of Unreal Engine 5 and is co-developed...SeniorWork at office
$93.73k - $123.45k per year
...citizens. The HSI team is currently hiring a Data Specialist to report to the Manager of Quality... ...Leads tasks and projects related to the modelling, analysis, and interpretation of divisional... ...(i.e. technical staff, business staff, senior management, council reports)...SeniorPermanent employmentFull timeInternshipWork at officeMonday to fridayShift work$115k - $165k per year
Data Modeling and Analytics Architect Position Description This role is hybrid and requires you to be at our downtown Toronto office at... ...& Architecture • Design, develop, and maintain scalable data models, data marts, and semantic layers to support analytics and...SuggestedWork at office2 days per week- ...MUST HAVE skills/experience: · Strong knowledge PL SQL/T-SQL · Having experience in Data Modelling (Any designer tool), Gap analysis and MS Visio · Good understanding in Data warehousing concepts and ETL Process · Drive the requirement session/meetings with...SuggestedContract work
- ...infrastructure required to power the next generation of AI innovation while ensuring data sovereignty, resilience, and scalability at national scale. Bell is seeking a Senior Specialist, Schedule Control – Data Centre Infrastructure to lead schedule development, governance...SeniorFull timeContract workWork at office3 days per week
- ...Job Description – Data Analytical Specialist / Scientist Position Summary We are seeking an... ...Intelligence (BI) and analytics solutions using Microsoft technologies. The successful candidate... ..., ETL, Azure Data Factory, SSIS, data modeling, statistical analysis, and business...Microsoft
$69k - $114k per year
...Job Type: Permanent Work Model: Hybrid Reference code: 131983... ...Analytics programs—leveraging data, insights, and technology to... ..., including presentations to Senior Manager, Director, and Partner... ...s as well: Experience with Microsoft Viva Glint (survey...SeniorMicrosoftPermanent employmentWork at officeFlexible hours$69k - $114k per year
...Job Type: Permanent Work Model: Hybrid Reference code: 133747 Primary... ...your typical day look like? As a Senior Resource Specialist aligned to SR&T, you will be involved... ...paced environment. • Proficiency in Microsoft Office, especially Excel (VLOOKUP, Pivot...SeniorMicrosoftPermanent employmentWork at officeFlexible hours- We are seeking a highly skilled Intermediate Data Analytical Specialist/Scientist to drive the end-to-end development, modeling, and delivery of advanced Business Intelligence... ...Maximize your platform profile using premier Microsoft BI suite layers, cloud data warehouses, and...SeniorMicrosoftContract workInternship
- ...Job Responsibility: Job Summary What is the opportunity? As the leader of the Fraud Model Governance team, you will oversee the model governance program for Fraud Data Science and Analytics (Fraud DSA). You will collaborate with model developers within Fraud DSA and...SeniorFull time
- ...Purpose of Job The Treasury Modelling team within the Treasury group is responsible for the management of the department’s programmed... ...supporting Treasury’s programming and quantitative analysis. The incumbent will be instrumental in automating complex departmental models....SeniorFull time
$72k - $138k per year
...Job Type: Permanent Work Model: Hybrid Reference code: 128409 Primary Location: Toronto, ON All Available Locations... ...of our delivery processes and tools. We aim at the excellence on Microsoft Dynamics 365 platform, develop new ways of better serving our customers...SeniorMicrosoftPermanent employmentFlexible hours$74.65k - $93.32k per year
...Geriatric Care has an exciting opportunity for a Specialist, Data & Analytics Human Resources Posting Number: 10042... ...(BCCGC) serves as the corporate head office for the Baycrest Seniors Care family of companies, supporting our hospital, long-term...SeniorLong term contractFull timeTemporary workWork at officeShift work- ...City: Toronto Summary As the Specialist, SCM Data, you will be joining a team that embraces... ...manage the data, clean and prepare for modelling. ● Data Analysis: Support and maintain... ...using the following services/tools: 1. Microsoft Azure cloud services: Azure Data...SeniorMicrosoftInternshipWork at officeLocal areaRemote work
$56k - $84k per year
...Job Type: Permanent Work Model: Hybrid Reference code: 133442 Primary Location: Toronto, ON All Available Locations:... ...will your typical day look like? As an Analyst, Consultant, or Senior Consultant focusing on the Insurance practice in our Financial Engineering...SeniorPermanent employmentFlexible hours$103.2k - $192k per year
...hybrid role in Toronto We are seeking a Senior Data Scientist to join our team on a 12-month... ...and constructs new processes for modeling data. Develops predictive models and leverages... ...group/enterprise-wide level and serves as a specialist resource to senior leaders and...SeniorContract workPart timeShift work- ...to work that truly matters. Your New Role You are a senior, detail-oriented data professional with strong technical expertise in data quality... ...Master Data Management (MDM) Design and implement MDM domain models, canonical data models, hierarchies, reference data...SeniorLong term contractPermanent employmentWorldwide
- ...mapping and spatial analytics. A day in the life of a Data Specialist at Esri Canada: * Design, develop, test, and... ...integration processes to support analytics, modeling, and product features. * Build and optimize data models, data stores, and transformation workflows to ensure...Full timeSummer workWork at officeWork from home
- ...that truly matters. Your New Role You are a detail-oriented data professional with strong expertise in data governance,... ...establish stewardship accountability, improve governance operating models, and drive adoption of governance best practices across the organization...Long term contractPermanent employmentWorldwide
$90k - $140k per year
...cutting-edge media intelligence and data solutions, world-class... ...build, and apply modern data models to deliver impactful marketing... ...growth? Then you might be the Senior Data Insights Consultant we are... ...Collaborating with highly skilled specialists including Account Managers,...Senior- ...Develop BI solutions using Microsoft Power BI for varying business... ...client’s groups to assess current data analytics and reporting capabilities... ...Develop robust statistical models and machine learning... ...Key Requirements for a Data Specialist / Analytics Role Strong...Microsoft
- ...Zurich Canada is looking for a Catastrophe Modeler to assesses Catastrophe exposure and... ...responsibility assigned. • Validates data received from business segments and interprets... ...material impact on country results, escalates to senior management. • Leads data improvement...SeniorApprenticeshipWork at officeLocal areaWorldwideShift work
- ...Agile and DevOps Linux Server and hosting services Supporting Microsoft Windows Server 2019+ creating and using CI/CD Pipelines... ...Applying performance targets to hosted systems. Ensuring government data is protected. Ensuring systems operate reliably....SeniorMicrosoftHourly payInternshipLocal area
$68k - $102k per year
...Job Type: Permanent Work Model: Hybrid Reference code: 132114 Primary Location... ...finance, mathematics, statistics, data science or other relevant post-graduate degree... ...102,000 (Consultant) or $84,000 - $126,000 (Senior Consultant), and individuals may be eligible...SeniorPermanent employmentContract workFlexible hours- ...Job Title: Sales Representative– Microsoft Data & AI Consulting Services Employment: Full-time Location: Toronto, Canada OSI Digital is a global consulting firm with over three decades of experience helping organizations accelerate their digital transformation....MicrosoftLong term contractFull timeContract work
- ...Job Title: TSBI / Business Systems Analyst (Data Warehouse & Data Modelling) Location: Toronto, ON – Hybrid (2 Days/Week Onsite) Experience... ...legacy systems, create mapping documents, support L2/L3 data model design, and drive data integration initiatives across...Contract work2 days per week
- ...Req ID: 375733 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you... ...organization, apply now. We are currently seeking a Business Partner Senior Specialist to join our team in Toronto, Ontario (CA-ON), Canada (CA)....SeniorWork at officeLocal areaRemote workFlexible hours
- ...( eqbank.ca ) one of the top banks in Canada on the Forbes World's Best Banks list since 2021. The Work The Senior Analyst - Cyber Threat Modeling and Risk supports the Threat Modeling and Risk Assessment program by assisting with the identification, assessment, and...SeniorFull time
$105k - $115k per year
...lifelong learners. About The Role As a Senior Data Analyst, you are an experienced analytics... ...establish best practices across data modeling, experimentation, and reporting. You are... ...with data engineers to design data models and ensure reliable, high-quality reporting...SeniorFull timeWork from homeFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Specialist, Data Modeler (Microsoft. Be the first to apply!
Related searches
- reporting specialist Toronto, ON
- intake specialist Toronto, ON
- global mobility specialist Toronto, ON
- diversity and inclusion specialist Toronto, ON
- personal computer specialist Toronto, ON
- reading specialist Toronto, ON
- building performance specialist Toronto, ON
- dispute resolution specialist Toronto, ON
- optimization specialist Toronto, ON
- spécialiste en amélioration continue Toronto, ON
