Senior Specialist, Data Modeler

Vale • ,

15h • 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 Engineering, Data Science, or related field
• 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

Nice To Haves

• 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)

Responsibilities

• Build robust ETL/ELT pipelines using Azure Data Factory, Databricks, and 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

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