Find work in Canada.

344,582 jobs across our Canadian network. How we count

Jobs in Canada

Email me new jobs Save this search

Added 1 day ago
SS
Senior SharePoint / M365 Developer - Agentic AI
Spot Solutions Ltd.
Vancouver, BC
- Full-time
We're looking for a strong SharePoint / Microsoft 365 developer with:
Added 1 day ago
Software Engineer
Scotiabank
Toronto, ON
The primary role of Global Finance Technology is to work with the Bank's finance community to re-engineer finance processes to enhance effectiveness and efficiency. The unit is also…
Added 1 day ago
I
Data Engineer
InfoFarm
Engineer, BC
- Full-time
…that power data-driven decision-making. You’ll work closely with senior engineers and business stakeholders to deliver high-quality data solutions that are scalable, reliable, and easy to…
Added 1 day ago
RT
Conseiller(ère) sénior, Gestion des données de Foundry | Senior Advisor, Foundry Data Management
Rio Tinto
Montreal, QC
- Full-time
Solides compétences en Python, PySpark, SQL et en pratiques de gouvernance et de sécurité des données d’entreprise.
Added 1 day ago
P
Senior Applied AI Developer
Plusgrade
Montreal, QC
- Full-time
You master general software engineering principles with Python and Java, building robust RESTful APIs, containerized services with Docker and Kubernetes, and native AWS infrastructure.
Added 1 day ago
D
Java Developer
Dexian
Mississauga, ON
- Other
Hands-on experience with Oracle and/or MS SQL Server, plus MongoDB
Added 1 day ago
H
Senior Quality Engineer
Hays
Toronto, ON
- $65 to $80 CAD / hour
- Contract
Experience with Python, Java, or SQL scripting
Added 1 day ago
IG
Software Developer
Insight Global
Mississauga, ON
- $45 to $68 CAD / hour
- Contract
Insight Global is seeking a Senior .NET Backend Developer to support and enhance a Sales Audit Tool used to analyze and process sales order data from an ERP system. The ideal candidate will…
Added 1 day ago
H
Data Quality Engineer
Hays
Toronto, ON
- Contract
Proficiency in Python, Java, and SQL for test automation and ETL validation.
Added 1 day ago
C
Power BI Developer
Collabera
Toronto, ON
- $65 to $75 CAD / hour
- Contract
The Company offers a total rewards package in accordance with all applicable federal, provincial, and local laws and requirements.
Added 1 day ago
PX
Data Scientist (Machine Learning and AI)
Project X
Toronto, ON
- Full-time
Proficiency in Python and SQL, with experience in data wrangling, statistical analysis, and model development
Added 1 day ago
SG
Senior Product Solutions Analyst
Scotia Global Asset Management
Toronto, ON
- Full-time
Advanced knowledge in Python and SQL and working with large data sets
Added 1 day ago
T
Senior Quality Engineer
Tangerine
Toronto, ON
- Full-time
Develop and maintain automated data validation, reconciliation, and regression tests using Python, SQL, and other automation utilities.
Added 1 day ago
L
Business Analyst capital markets /trade
Luxoft
Toronto, ON
- Contract
Technical fluency in SQL and stored procedures; ability to read Python code is an advantage
Added 1 day ago
C
Automation Lead – Quality Engineering
CGI
Toronto, ON
- Full-time
We are seeking an experienced QE Lead with strong hands-on Python automation expertise to lead quality engineering for complex integration solutions connecting APIs, microservices,…
Added 1 day ago
Senior Quality Engineer
Scotiabank
Toronto, ON
Develop and maintain automated data validation, reconciliation, and regression tests using Python, SQL, and other automation utilities.
Added 1 day ago
SI
Quality Assurance Analyst
Spait Infotech
Canada
- Full-time
Familiarity with Python, Java, or JavaScript for test automation.
Added 1 day ago
BC
Data Platform Administrator/Developer
BBA Consultants
Mont-Saint-Hilaire, QC · Mont-St-Hilaire, QC
- Full-time
Proficiency in SQL, Python and PowerShell, with experience using Azure DevOps, automation tools and CI/CD practices
Added 1 day ago
OS
Senior Forward Deployed Engineer (FDE)
Open Systems Technologies
Toronto, ON
- Contract
We are seeking a Senior Forward Deployed Engineer (FDE) with deep Java and Python technology expertise to work directly with our Fintech clients in the Spread Products space. This is a…
Added 1 day ago
BC
Data Platform Administrator/Developer
BBA Consultants
Montreal, QC
- Full-time
Proficiency in SQL, Python and PowerShell, with experience using Azure DevOps, automation tools and CI/CD practices
Added 1 day ago
BC
Data Platform Administrator/Developer
BBA Consultants
Boisbriand, QC
- Full-time
Proficiency in SQL, Python and PowerShell, with experience using Azure DevOps, automation tools and CI/CD practices
Added 1 day ago
A
Cloud Software Engineer
Actalent
Ottawa, ON
- $88 to $111 CAD / hour
- Contract
Experience with SQL and relational databases.
Added 1 day ago
PX
Sr. Data Platform Engineer
Project X
Toronto, ON
- Full-time
Strong Python or comparable programming skills, with experience in modern batch, streaming, CDC and orchestration patterns.
Added 1 day ago
MM
Oliver Wyman - Software Developer - Data & Analytics (DNA) Team
Marsh McLennan
Montreal, QC
- Full-time
· Expérience pratique récente avec Python et, idéalement, avec un autre langage serveur (C#, .NET, Java, Rust ou C++).
Added 1 day ago
C
Senior Data Engineer
Clio
Toronto, ON
- Full-time
Proficiency in at least one major language (e.g. Python, Scala, Ruby) and SQL, striving to write elegant and maintainable code, and comfortability with picking up new technologies

Closed listing

Epsilon Solutions Ltd.

Semantic Model Senior Developer

Mississauga, ON, Canada

Contract

This opening has closed.

The original listing is kept below for reference.

Find open jobs More jobs with this employer

About employer

Job details

Job type: Contract
Closing date: Nov 6, 2026
Experience: Minimum 10 years of overall experience in business intelligence, data warehousing, analytics, data modelling, or reporting development.
Posting language: English
Posted: Oct 7, 2026

Similar jobs hiring now

Search current openings

Original job description

Archived listing. The details below describe a past opening.

Semantic Model Senior Developer

Toronto- Hybrid

Contract

Key Responsibilities

Semantic Model and Cube Development

Design, develop, enhance, and maintain enterprise-grade Power BI semantic models.
Develop and support SSAS tabular models and, where applicable, multidimensional OLAP cubes.
Translate banking and financial-reporting requirements into scalable analytical models.
Design reusable model components, including tables, relationships, measures, calculation logic, hierarchies, perspectives, and business-friendly metadata.
Develop complex DAX measures, calculated columns, calculation groups, and time-intelligence solutions.
Develop and maintain MDX calculations and cube components where multidimensional SSAS is used.
Create governed and reusable semantic layers that support multiple reports, dashboards, analytical products, and business functions.
Assess existing cube and semantic-model designs and recommend improvements to scalability, maintainability, usability, and performance.

Data Modelling and Architecture

Design logical and physical data models using dimensional modelling principles.
Develop star and snowflake schemas, including fact tables, dimension tables, hierarchies, keys, and relationships.
Work with enterprise data warehouses, data marts, operational data stores, and cloud-based data platforms.
Define appropriate model granularity, aggregation strategies, relationship behaviour, and data-access patterns.
Assist with modernizing legacy cubes and reporting models into Power BI or modern tabular semantic models.
Ensure semantic models maintain consistent business definitions across reports and consuming applications.
Maintain clear data lineage between source systems, data-transformation layers, semantic models, and reports.

Power BI Development

Develop Power BI reports and dashboards based on governed semantic models.
Build complex and reusable DAX measures to support financial, operational, risk, regulatory, and management reporting.
Use Power Query and M to clean, transform, and integrate data from multiple sources.
Configure import, DirectQuery, composite, or live-connection solutions based on business and technical requirements.
Implement drill-down, drill-through, hierarchies, bookmarks, tooltips, and other analytical capabilities where required.
Publish and manage semantic models and reports within Power BI Service.
Configure and troubleshoot scheduled refreshes, gateways, connections, permissions, and deployment activities.
Support controlled promotion of models and reports across development, testing, UAT, and production environments.

Performance Optimization

Optimize semantic models, DAX calculations, SQL queries, relationships, and data-refresh processes.
Analyze slow-running reports and queries and identify model, DAX, storage, or source-system bottlenecks.
Improve model performance through appropriate schema design, cardinality management, aggregations, partitioning, incremental refresh, and efficient calculation logic.
Optimize SQL queries, stored procedures, views, indexes, and data-extraction processes supporting semantic models.
Monitor model size, refresh duration, query response time, capacity usage, and report performance.
Resolve production issues related to model processing, refresh failures, data latency, security, and report performance.

Mandatory Qualifications

Minimum 10 years of overall experience in business intelligence, data warehousing, analytics, data modelling, or reporting development.
Demonstrated professional experience within the banking or financial-services industry.
Strong hands-on experience designing and developing enterprise Power BI semantic models.
Strong experience with SSAS Tabular, Azure Analysis Services, or a comparable enterprise tabular modelling platform.
Experience with SSAS Multidimensional or OLAP cube development is strongly preferred and may be mandatory if the existing environment uses multidimensional cubes.
Advanced expertise in DAX, including complex measures, filter context, row context, time intelligence, and performance optimization.
Strong working knowledge of MDX, particularly where legacy or multidimensional cubes are involved.
Advanced SQL and T-SQL development skills.
Strong experience in dimensional modelling, including star and snowflake schemas.
Experience developing fact tables, dimensions, hierarchies, measures, relationships, and calculation logic.
Strong Power BI Desktop and Power BI Service experience.
Experience with Power Query and M-based data transformation.
Experience with enterprise data warehouses and data marts.
Experience with ETL or ELT technologies such as SSIS, Azure Data Factory, or equivalent platforms.
Experience implementing data security, including row-level security and role-based access.
Experience optimizing models, DAX, SQL, refresh processes, and report performance.
Strong data-validation, reconciliation, testing, and troubleshooting capabilities.
Ability to translate business requirements into robust technical and data-model designs.
Strong stakeholder-management, communication, and documentation skills.
Must be located in Canada or authorized and available to work in Canada, subject to the client’s engagement requirements.

Preferred Qualifications

Microsoft Power BI certification, such as PL-300 or a comparable current certification.
Microsoft SQL Server, data-management, Azure, or Microsoft Fabric certification.
Experience with Azure SQL, Azure Data Factory, Azure Data Lake, Synapse Analytics, or Microsoft Fabric.
Experience with XMLA endpoints, tabular model metadata, or model-management tools.
Familiarity with Tabular Editor, DAX Studio, Performance Analyzer, SQL Profiler, or equivalent diagnostic tools.
Experience with calculation groups, incremental refresh, composite models, aggregations, and large enterprise datasets.
Experience migrating SSAS cubes or legacy reporting platforms to Power BI semantic models.
Experience working with CI/CD practices, deployment pipelines, source control, and environment promotion.
Experience with Python, Alteryx, Apache Spark, or similar data-engineering and analytics technologies.
Experience leading technical design sessions or mentoring BI and Power BI developers.
Experience working within a highly governed, regulated, or audit-controlled reporting environment.

About employer

More about this job

Responsibilities

Design, develop, and maintain enterprise Power BI semantic models and SSAS tabular or multidimensional models, translating banking and financial reporting needs into governed, reusable analytical solutions. Build reports and dashboards, optimize models and data-refresh performance, troubleshoot production issues, and support secure deployment across environments.

Requirements

Requires at least 10 years of relevant experience, professional banking or financial-services experience, and strong hands-on expertise in Power BI semantic models, SSAS, DAX, SQL/T-SQL, and dimensional modeling. Candidates should also have experience with Power BI Service, Power Query, ETL/ELT, data security, performance optimization, testing, and stakeholder communication, and must be located in or authorized to work in Canada.

Skills

Power BI Semantic Modeling
SSAS Tabular
SSAS Multidimensional
DAX
MDX
SQL and T-SQL
Dimensional Modeling
Power Query and M
Data Warehousing
ETL and ELT
Data Modeling
Performance Optimization
Row-Level Security
Azure Data Factory
Data Validation and Reconciliation
Stakeholder Management

Visa sponsorship

Not detected in the job text

Keywords

Power BI
Power BI Service
Power BI Desktop
Semantic Models
SSAS Tabular
SSAS Multidimensional
Azure Analysis Services
DAX
MDX
SQL
T-SQL
Power Query
M
Dimensional Modeling
Star Schema
Snowflake Schema
Data Warehousing
Data Marts
ETL
ELT
SSIS
Azure Data Factory
Azure SQL
Azure Data Lake
Synapse Analytics
Microsoft Fabric
Row-Level Security
Calculation Groups
Incremental Refresh
Tabular Editor

Report this job