Find work in Canada.

A simpler way to find your next job.

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 6 mins ago
AG
Analyste de marché - Market Analystcan you rewrite t
Altus Group
Montreal, QC
- Full-time
Added 20 mins ago
AC
Senior Manager Global Internal Audit and Internal Controls
Alimentation Couche-Tard
Laval, QC
- Internship
…remediation activities.Experience administering and utilizing GRC platforms and audit management technologies to support compliance, testing, and reporting activities (e.g., Optro, Workiva,…
Added 20 mins ago
IG
Campaign Analyst
Insight Global
Toronto, ON
- Contract
Hands-on experience with BI tools (e.g., Tableau, Power BI, Looker)
Added 20 mins ago
PO
Research Technology & Data Specialist - Mississauga, ON
PATTISON Outdoor
Mississauga, ON
- Full-time
…PATTISON’s research technology, data capabilities and proprietary…
Added 20 mins ago
ED
Scrum Master, Level 17 - EN 596
Export Development Canada | Exportation et développement Canada
Ottawa, ON
- $84,698 to $112,931 CAD / year
- Full-time
…data ecosystem by delivering, operating, and modernizing the platforms and data capabilities that enable secure, trusted, and accessible data across the organization. The team supports…
Added 21 mins ago
T
Commercial Finance Business Partner
Takeda
Toronto, ON · CAN - Toronto Head Office
- Full-time
Experience with enterprise planning tools, Power BI or equivalent reporting and analytics platforms preferred, plus strong curiosity & willingness to upskill within AI field
Added 21 mins ago
SD
Director, Strategy & Operations
Shoppers Drug Mart
Toronto, ON
- Full-time
Added 21 mins ago
Program Controls Manager, Data Center Construction
Bell
Regina, SK
Added 50 mins ago
P
Senior Software Developer
ProxyLink
Toronto, ON
- $100 to $105 CAD / hour
- Contract
ProxyLink is seeking an experienced Senior Software Developer – ETL to join our team and contribute to the development, enhancement, and maintenance of enterprise-level data integration,…
Added 50 mins ago
CF
Data Architect & Analytics Team Lead
Canadian Football League
Toronto, ON
- Full-time
Work with modern cloud and data technologies, including Snowflake, dbt, Python, SQL Server, Power BI, cloud data services, and ETL/ELT platforms.
Added 1 hour ago
MANAGER, FINANCE ENABLEMENT, TECHNOLOGY & TRANSFORMATION (HYBRID)
Green Shield Canada
Toronto, ON · Windsor, ON
Use approved enterprise platforms and governed financial data to develop or coordinate prototypes, workflows, reports, and reusable solutions that can scale across Finance.
Added 2 hours ago
S
Field Data Coordinator
Semex
Guelph, ON
- Full-time
Support the addition of new herds, herd-management platforms, and data sources.
Added 2 hours ago
HA
Energy Infrastructure Analyst
H.H. Angus & Associates Ltd.
Vancouver, BC · Ottawa, ON · Toronto, ON · Montreal, QC
- Full-time
Experience with RETScreen, building energy modelling software, Power BI, data visualization tools or other analytical platforms is an asset.
Added 2 hours ago
FS
Coordinator, Sales Operations (14 Month Contract)
Four Seasons Hotels and Resorts
Toronto, ON · Four Seasons Corporate Headquarters Toronto
- $65,000 to $75,000 CAD / year
- Full-time
Provide first level in-region support for Golden Sales & Catering, SalesDesk, Varicent, Power BI reports
Added 3 hours ago
Application & Infrastructure Analyst III /Team Lead - Mission Critical Development
City of Edmonton
AB
…non-technical stakeholders. Relevant certifications such as Azure Developer Associate, DevOps Engineer Expert, Azure Fundamentals, Power Platform Fundamentals, ITIL, Certified ScrumMaster,…
Added 4 hours ago
Marketing Insights & Reporting Analyst
Kensington
Toronto, ON
Experience working with Excel, Power BI, Tableau, Looker, or similar visualization platforms.
Added 4 hours ago
MH
Power Systems Engineer
Manitoba Hydro International
Winnipeg, MB
- Full-time
As a Power Systems Engineer, you will be responsible for performing engineering consulting studies and provide user technical support of all MHI software products, primarily PSCAD™/EMTDC™.
Added 5 hours ago
M
Data Specialist
McKesson
Mississauga, ON
- Full-time
…development, and optimization of enterprise-scale healthcare data platforms. This role will play a critical part in building scalable data pipelines, modern analytics solutions, and…
Added 5 hours ago
Senior Manager, Supply Chain Analytics
Brewers Retail Inc
Bolton, ON
…focus will be building scalable analytical tools, talent, and platforms that support both operational execution and long-term supply chain…
Added 5 hours ago
SI
Data Analyst
Spait Infotech
Canada
- Full-time
Experience with Power BI, Tableau, or similar BI tools.
Added 5 hours ago
J
Data Analyst
JOBSTODAY.WORLD
Toronto, ON
- $70,000 to $95,000 CAD / year
- Full-time
Experience with SQL, reporting tools, or data visualization platforms.
Added 6 hours ago
GS
Business Analyst
Gala Solutions
Montreal, QC
- Contract
Support migration and transformation initiatives involving financial data and reporting platforms.
Added 6 hours ago
Pricing and Yield Analyst
Flair Airlines Ltd.
Toronto, ON
Experience using revenue management systems, business intelligence platforms, or data visualization tools (e.g., Tableau, Power BI, SQL) is required.
Added 6 hours ago
Senior Product Manager
Range
Toronto, ON
At Range Group we believe in the power of the professional travel advisor. We represent over $4.5 billion in annual travel sales. All our investments stem from a common thesis, that travel…
Added 6 hours ago
MN
Construction Technology Platform Manager - Pipeline & Pursuits
Modern Niagara
Toronto, ON · Vaughan, ON
- Full-time
Partner with IT, Analytics, Integration Specialists, and Data Engineers to define requirements for CRM, ERP, Power BI, estimating platforms, scheduling, and other connected systems.

Epsilon Solutions Ltd.

Semantic Model Senior Developer

Mississauga, ON, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Apply by: 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

Original job description

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.

Apply 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