Find work in Canada.

330,880 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Save this search

Added 18 mins ago
Data Scientist, Early Career (Canada)
Jobright.ai
Canada
Full-time
Strong technical foundation in SQL and database management for efficient data extraction and feature engineering
Added 18 mins ago
Manager, Data & Evaluation
Touchstone Institute
Toronto, ON
Contract
Proficiency with statistical software and/or SQL is an asset
Added 18 mins ago
Developer Support Specialist
Brex
Vancouver, BC
…partners to never-before seen things in the finance world. As a Developer Support Specialist, you are the front-line point of contact supporting developers to be successful when using…
Added 34 mins ago
Live Ops Manager - MARVEL Strike Force
Scopely
Canada
Strong analytical skills and comfort using data to inform events and monetization requirements; Structured Query Language (SQL) proficiency is preferred
Added 48 mins ago
Full Stack Software Developer -
J&M Group
Toronto, ON
Full-time
Strong experience with relational database technologies and SQL
Added 48 mins ago
Manager, Data Analytics - AI Enablement
Walmart Canada
Mississauga, ON
Full-time
Added 48 mins ago
Software Developer Intern (January 2026 12 months)
SOTI
Mississauga, ON
Full-time
Job Title: Software Developer Intern - Back End
Added 1 hour ago
Staff Full Stack Engineer
Workstream
Vancouver, BC
Experience with SQL and NoSQL databases, such as PostgreSQL or MongoDB, have comprehensive understanding of the decision-making process between SQL and NoSQL databases.
Added 1 hour ago
Associate Investment Operations Support
IG Wealth Management
MB · Manitoba, Canada
Full-time
Experience with SQL, database queries and Microsoft Excel macros is considered an asset.
Added 1 hour ago
Data Science Expert
Amaris Consulting
Toronto, ON
Full-time
Added 1 hour ago
Marketing Engineer & Director of AEO
Notified
Toronto, ON
Full-time
HTML, CSS, JavaScript, TypeScript, Python, SQL, or similar languages used to inspect, automate, and improve web and data systems.
Added 1 hour ago
Devops Developer
Ericsson
Bas-Saint-Laurent, QC
Full-time
Expérience avec SQL et une exposition au développement front-end (TypeScript, HTML, CSS).
Added 1 hour ago
Devops Developer
Ericsson
Montreal, QC
Full-time
Expérience avec SQL et une exposition au développement front-end (TypeScript, HTML, CSS).
Added 1 hour ago
Développeur Java Senior
Amaris Consulting
Montreal, QC
Full-time
We are seeking an experienced Senior Java Developer to join a growing Market Risk technology team. In this role, you will design, build, and enhance applications that support critical risk…
Added 1 hour ago
SharePoint Specialist / Web Application Developer
ITS Consulting Inc
Vancouver, BC
Other
The SharePoint Specialist / Web Application Developer is responsible for the planning, implementation, administration, and ongoing support of customer Microsoft 365 collaboration and…
Added 1 hour ago
Junior Data Engineer
OMD
Toronto, ON
Full-time
Develop production-ready SQL transformations to clean, structure, and prepare marketing datasets.
Added 1 hour ago
Credit Risk Manager
PwC Canada
Toronto, ON
Full-time
Significant experience and proven ability in at least one of the following programming languages/software: Python, R, SQL, SAS, C++, etc.
Added 1 hour ago
Actuarial Analyst - Winter 2027 Co-op/Intern
Definity Insurance Company
Waterloo, ON
Full-time
Must possess strong programming skills, including knowledge of SAS, R and/or SQL , and efficient use of Microsoft applications (Excel,VBA, etc.);
Added 1 hour ago
Sr. Business Systems Analyst
TD
Toronto, ON
Full-time
Added 1 hour ago
Software Engineer I
TD
Toronto, ON
Full-time
Full stack developer spending time on Coding, designing/solution, analysis and documentation.
Added 1 hour ago
Data Scientist II (Credit Risk and Product)
TD
Toronto, ON
Full-time
Highly skilled in coding SQL, and Python/PySpark.
Added 1 hour ago
Technical Product Owner, AI & Machine Learning Solutions
TD
Toronto, ON
Full-time
Strong technical proficiency in Python, SQL, and modern software engineering practices including version control, CI/CD, automated testing, observability, and deployment automation.
Added 1 hour ago
Senior Manager, Data Engineering
Heart & Stroke
Remote, Canada
Full-time · Remote
Added 1 hour ago
Senior DevOps Engineer
Motorola Solutions
Vancouver, BC
Full-time
Work with our architect to develop, champion and build a strategic roadmap for our future-state infrastructure, aligning with business objectives and developer needs.
Added 1 hour ago
Intern, Market Risk Reporting
TC Energy
Calgary, AB
Full-time
Experience interpreting or modifying SQL, Python, or R code

Pomerleau

Analytics Engineer

Montreal, QC, Canada

Job type: Full-time
Apply by: Oct 21, 2026
Experience: Minimum 7 years of experience in data modelling and data analysis.
Posting language: English
Posted: Sep 21, 2026

Apply About employer

Applications open in a new tab.

Original job description

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. If this speaks to you, apply for this role or connect with one of our recruiters to learn how we can support you throughout the process.

Apply About employer

More about this job

Responsibilities

The Analytics Engineer will map business ontologies and design dimensional data models to support organizational data products. They will collaborate with domain owners and data engineering teams to document calculation rules and validate data models against business requirements.

Requirements

Candidates must possess a bachelor's degree and at least 7 years of experience in data modelling and analysis. Strong proficiency in SQL, dimensional modelling, and Microsoft Fabric is required, along with excellent communication and documentation skills.

Skills

Data modelling
Dimensional modelling
SQL
Microsoft Fabric
Data analysis
Semantic modelling
Data governance
Business ontology
Data engineering
Requirements gathering
Documentation
Communication
Power BI
Python
Spark
Change management

Benefits

RRSP with up to 5% employer matching
Hybrid work model
Employee stock ownership program
Career growth opportunities
Transit pass reimbursement
Minimum 4 weeks of vacation

Visa sponsorship

Not detected in the job text

Keywords

Analytics Engineer
Data Modelling
Dimensional Modelling
Star Schemas
SQL
Microsoft Fabric
Data Governance
Semantic Model
Business Intelligence
Data Engineering
Power BI
Python
Spark
Ontology
Data Products
Construction
Manufacturing
Change Management
Data Catalog
Granularity
Conformed Dimensions
History Management
Requirement Gathering
Documentation
Financial Systems
Operational Systems
Data Transformation
Data Ingestion
Domain-oriented Model
Access Management

Report this job