Senior Analyst, Data Design

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.
#J-18808-Ljbffr