Senior Specialist, Data Modeler (Microsoft

Vale • Toronto, ON

4d • CA$119,000 • Onsite

About The Position

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.

Requirements

• Bachelor’s degree in Computer Science, Data Science, Software Engineering, or a related field
• 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
• 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

Nice To Haves

• 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 in mining, heavy industry, or similar domains is an asset

Responsibilities

• 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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior