Analytics Engineer — Domain-Driven Data Modeling (Hybrid)

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

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.