Senior Analyst, Data Design

Master; Montreal; Hybrid; CAD 110,000 - 130,000; Full time

Benefits offered by this job

Medical and dental coverage

Disability protection

RRSP contribution

Wellness spending account

Employee assistance program

Telemedicine

Professional membership reimbursement

Early vacation program

Hybrid work policy

Job summary

Master is seeking a Senior Analyst, Data Design to shape data architecture across Canada and the U.S. You will design scalable data models, build robust ETL/ELT pipelines, and help onboard a cloud data platform while collaborating with cross‑functional teams.

The role supports a federated data strategy in a hybrid work environment, with a focus on security, data quality, and governance across multiple ERP systems.

Qualifications

• 10+ years of experience in Data Engineering, Analytics Engineering, or related field.
• Advanced SQL with performance tuning and data transformation.
• Experience designing ETL/ELT pipelines and data models.
• Strong data warehousing concepts and dimensional modeling.
• Version control using Git.
• Programming in Python or similar language.
• Ability to navigate ambiguity and deliver in evolving environments.
• Experience with Snowflake, Databricks, or similar cloud platforms.

Responsibilities

• Design scalable data models and datasets for enterprise reporting.
• Build and optimize ETL/ELT pipelines across ERP sources.
• Develop reusable data integration patterns for onboarding sources.
• Ensure data quality, lineage, and security controls.
• Collaborate with architects, governance, and analytics teams.
• Migrate from SQL Server to a cloud-based data platform.

Skills

Advanced SQL

Python

Data Modeling

ETL/ELT

Data Warehousing

Git

Cloud Data Platforms

Tools

Snowflake

Databricks

Microsoft Fabric

dbt

Job description

For more than 70 years, we've been making a difference, in every degree.

At Master, our people are the driving force behind our success. As Canada's largest HVAC-R distributor and one of North America's industry leaders, we're proud to bring together more than 2,000 employees across nearly 100 locations in Canada and the United States.

As a Senior Analyst, Data Design, you'll join the Data Design & Provisioning team within our Data Management Services (DMS) department, supporting both our Canadian and U.S. operations. As Master Group transitions from a centralized to a federated data and analytics operating model, you'll design and build the database structures, data pipelines, and data models that transform raw operational data into trusted, analytics-ready assets.

This role is ideal for someone who is comfortable with ambiguity and enjoys building solutions in evolving environments. You'll work across a complex data landscape spanning multiple ERP systems, help onboard a new cloud data platform, and design scalable solutions despite changing requirements and priorities. Working closely with our Data Architect, you'll help shape how data is modeled, structured, and delivered across the organization while contributing to the methodologies, standards, and practices that will define our future data ecosystem.

Please note that this position can be based anywhere in Canada; however, priority will be given to candidates in the Greater Montreal area, where our headquarters are located.

What You Will Accomplish With Us

• Design scalable data models and curated datasets that enable enterprise reporting and analytics
• Build and optimize robust ETL/ELT pipelines that transform operational data into trusted business assets
• Develop reusable frameworks and data integration patterns that accelerate onboarding of new data sources
• Ensure data quality, reliability and lineage across our ecosystem
• Implement secure data access controls including RBAC, ABAC, row-level security and data masking
• Contribute to data standards, best practices and documentation that will define how our organization works with data in the future
• Collaborate with Data Architects, Governance teams and Analytics specialists across Canada and the United States
• Help guide our transition from our current SQL Server environment to a modern cloud-based data platform

What You Bring To Our Team

• 10+ years of experience in Data Engineering, Analytics Engineering, Data Modeling, or a related field.
• Advanced SQL expertise with strong experience in query optimization, data transformation, and database design.
• Proven experience designing and maintaining complex ETL/ELT processes and data pipelines.
• Strong understanding of data warehousing concepts, dimensional modeling, and enterprise data management.
• Hands-on experience with Git or other version control platforms.
• Programming experience in Python, or another modern programming language.
• Ability to navigate ambiguity, manage competing priorities and deliver solutions in evolving environments.
• Experience with modern cloud data platforms such as Snowflake, Databricks, Microsoft Fabric, or similar technologies.

Preferred Qualifications

• Knowledge of data security frameworks, governance principles, and access management concepts.
• Experience working in both legacy and modern data architectures.
• Familiarity with dbt or similar data transformation frameworks.
• Experience with orchestration tools such as DB Airflow, Azure Data Factory, Dagster, or Prefect.

Base Salary Range: $110,000 – $130,000 annually

• Supplemental Pay Types: Annual bonus

The final salary will be determined based on the candidate’s skills and experience, in compliance with applicable regulations.

Competitive Benefits: In addition to a rewarding career within our team, we offer

• Medical and dental coverage from day one, along with short and long-term disability protection
• Contribution to a collective registered retirement savings plan upon starting your role.
• Wellness spending account
• An employee assistance program including psychological, financial, and legal support.
• Access to telemedicine from the beginning of your employment.
• Reimbursement of professional association membership fees.
• Early vacation program.
• Work–life balance supported through a hybrid work policy.