Senior Analyst, Data Design

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 accountAn 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. 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. Every day, our teams help deliver innovative solutions that improve comfort, energy efficiency, and building performance. Through collaboration, expertise, and a commitment to doing what's right, we create lasting value for our customers, partners, and communities. Guided by our purpose — Improving people's lives, in every degree — we empower our employees to grow, make a meaningful impact, and build rewarding careers in an environment where people, teamwork, and continuous improvement come first.