Analytics Engineer

Pomerleau; Montreal (administrative region); Hybrid; CAD 90,000 - 120,000; Full time

Benefits offered by this job

RRSP with up to 5% employer matching

Hybrid work model for corporate roles

Employee stock ownership program

Career growth through real development

Transit pass reimbursement

Minimum 4 weeks of vacation from day 1

Job summary

Pomerleau is seeking a data modelling and analytics professional to map business domains, design dimensional and semantic models, and collaborate with domain owners to validate data products. You will document definitions, measures and transformation rules, and work with data engineers to build the required data layers.

The role emphasizes governance, discovery sessions with business teams, and delivering reports and visualisations to activate the model in a corporate analytics environment.

Qualifications

• Bachelor's degree in computer science, business intelligence, data analytics, management, engineering or a related field.
• Minimum 7 years of experience in data modelling and data analysis.
• Demonstrated command of dimensional modelling: star schemas, granularity, conformed dimensions, history management.
• Experience designing semantic models for business users, including measures and documentation.
• Strong SQL and a working understanding of data ingestion and transformation.
• Hands‑on experience with Microsoft Fabric.
• Ability to run discovery sessions with business teams and turn them into structured requirements.
• Documentation discipline: able to write clear, unambiguous definitions and maintain them over time.
• Strong communication skills and the ability to explain analytical concepts in plain language.
• Initiative: challenge requests where needed, identify improvement opportunities and propose solutions beyond the stated need.
• Ability to manage several topics simultaneously and work autonomously.

Responsibilities

• Understand a business domain: its mission, processes, source systems and what it measures.
• Map the domain ontology: business objects, their definitions, their relationships and their system of record.
• Document definitions, measures and calculation rules, and have them validated by the domain owners.
• Design the dimensional data model (facts, dimensions, granularity, keys) and the semantic model used for consumption.
• Map business objects to source tables and specify the transformation logic required.
• Work with data engineering to have the required layers built, and validate the result.
• Produce data product documentation: what it contains, how calculations work, how it is consumed.
• Contribute to data governance: data ownership and accountability, classification, catalogue, naming conventions and change management.
• Validate the model with the domain by testing its real requests against the model elements.
• Produce the reports and visualisations needed to validate and activate the model.

Skills

Strong SQL

Data modelling

Data analysis

Semantic modelling

Communication skills

Autonomy

Discovery sessions facilitation

Education

Bachelor's degree in computer science, business intelligence, data analytics, management, engineering or a related field

Tools

Microsoft Fabric

Power BI

Python

Spark

Job description

Job Description

Ready to build your career? We want to hear from you.

Job Description

Ready to build your career? We want to hear from you.

This role is about understanding a business domain, documenting the objects and definitions it works with, and turning that understanding into usable data models. The person works directly with the domain owners, maps their business ontology, designs the data model and the data products, and documents definitions and calculation rules so they can be reused.

What you will do

• Understand a business domain: its mission, processes, source systems and what it measures.
• Map the domain ontology: business objects, their definitions, their relationships and their system of record.
• Document definitions, measures and calculation rules, and have them validated by the domain owners.
• Design the dimensional data model (facts, dimensions, granularity, keys) and the semantic model used for consumption.
• Map business objects to source tables and specify the transformation logic required.
• Work with data engineering to have the required layers built, and validate the result.
• Produce data product documentation: what it contains, how calculations work, how it is consumed.
• Contribute to data governance: data ownership and accountability, classification, catalogue, naming conventions and change management.
• Validate the model with the domain by testing its real requests against the model elements.
• Produce the reports and visualisations needed to validate and activate the model.

This role could be for you if you have

• Bachelor's degree in computer science, business intelligence, data analytics, management, engineering or a related field.
• Minimum 7 years of experience in data modelling and data analysis.
• Demonstrated command of dimensional modelling: star schemas, granularity, conformed dimensions, history management.
• Experience designing semantic models for business users, including measures and documentation.
• Strong SQL and a working understanding of data ingestion and transformation.
• Hands‑on experience with Microsoft Fabric.
• Ability to run discovery sessions with business teams and turn them into structured requirements.
• Documentation discipline: able to write clear, unambiguous definitions and maintain them over time.
• Strong communication skills and the ability to explain analytical concepts in plain language.
• Initiative: challenge requests where needed, identify improvement opportunities and propose solutions beyond the stated need.
• Ability to manage several topics simultaneously and work autonomously.

Assets

• Experience in dashboard development and data visualisation (Power BI).
• Command of Python, Spark and the wider data engineering tooling.
• Experience working in a domain-oriented model, where each business domain is accountable for its own data.
• Data governance experience: catalogue, classification, access management and change management.
• Experience with enterprise financial or operational systems.
• Experience in the construction or manufacturing sectors.

Benefits

• RRSP with up to 5% employer matching
• Hybrid work model for corporate roles
• Employee stock ownership program
• Career growth through real development opportunities
• Transit pass reimbursement — get to work for free
• Minimum 4 weeks of vacation from day one

For the past six years, we've proudly held the distinction of being one of Canada's Top 100 Employers.

Pomerleau is a national leader in construction, delivering major projects across Canada. We believe in creating a workplace where people feel respected, supported, and empowered to grow. Our culture is built on collaboration, trust, and a shared commitment to doing great work.