Find work in Canada.

335,316 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 1 min ago
Executive Director of Policy and Legislation
Innovation and New Technology
Winnipeg, MB
…translating strategic priorities into clear operational and business plans and delivering…
Added 1 min ago
Senior Technical Analyst
Innovation and New Technology
Winnipeg, MB
Infrastructure Management Services, Digital and Technology Solutions
Added 7 mins ago
E
Store Manager - evo Village Sports
evo
Whistler, BC
- Full-time
Aptitude for finding innovative workable solutions to business challenges and managing change.
Added 7 mins ago
HT
Advanced Applications Blow Molding Specialist
Husky Technologies
Bolton, ON
- Full-time
Collaborate with business development teams and customers to understand technical challenges and develop practical application and processing solutions
Added 7 mins ago
HT
Designer, Development (Service)
Husky Technologies
Bolton, ON
- Full-time
…cohesively with a variety of different teams from across the business globally to complete…
Added 7 mins ago
MF
Director, Procurement
Momentum Financial Services Group
Toronto, ON
- Full-time
…largest non-bank branch network - and a leader in financial solutions for underserved…
Added 7 mins ago
K
Associate People Operations Business Partner
Knix
Toronto, ON
- Full-time
You thrive in a fast-paced, ever-changing environment and can shift priorities based on business needs.
Added 7 mins ago
HT
Applications Engineer
Husky Technologies
Bolton, ON
- Full-time
…translate emerging technologies into scalable, customer-focused…
Added 7 mins ago
HT
VP, Accounting & Controllership (Husky)
Husky Technologies
Bolton, ON
- Full-time
…positions us to serve customers who seek differentiation through solutions that provide speed, flexibility and maximum productivity. This capability is at the core of our mission and…
Added 7 mins ago
CC
Sales Representative- Permanent Full-Time - (Supply Chain and Logistics B2B) - British Columbia
Chit Chats
Vancouver, BC
- Full-time
The role of the Sales Representative is essential in identifying, qualifying, and converting new business opportunities into active Chit Chats clients. This role is focused on building…
Added 7 mins ago
CC
Sales Representative- Permanent Full-Time - (Supply Chain and Logistics B2B) - Ontario
Chit Chats
Toronto, ON
- Full-time
The role of the Sales Representative is essential in identifying, qualifying, and converting new business opportunities into active Chit Chats clients. This role is focused on building…
Added 7 mins ago
OR
Account Executive, Business Sales - Markham
OSL Retail Services
Markham, ON
- Full-time
Currently, we are actively seeking Account Executives, for our Small & Medium Business Sales & Marketing Team for our client, Bell Canada. Fueled by cutting-edge fiber optic and wireless…
Added 7 mins ago
HT
Designer, Development (Electrical)
Husky Technologies
Bolton, ON
- Full-time
…high-performance injection molding systems and automated manufacturing solutions. Engineers at Husky work on new product development projects, designing complex electrical systems for…
Added 7 mins ago
OR
Account Executive, Business Sales - London
OSL Retail Services
London, ON
- Full-time
Currently, we are actively seeking Account Executives, for our Small & Medium Business Sales & Marketing Team for our client, Bell Canada. Fueled by cutting-edge fiber optic and wireless…
Added 9 mins ago
AG
Media Solutions Specialist
Adelphi Group
Toronto, ON
- Full-time
The role of a Media Solutions Specialist is to maintain all client budgets/ media buys in the media system and act as a liaison between media planning & buying teams, Initiative finance…
Added 9 mins ago
AG
Executive Administrative Assistant
Adelphi Group
Toronto, ON
- Full-time
…with team members, clients, and vendors at all levels in the business. You’re a consummate team player, able to build great relationships across the organization, and create a welcoming…
Added 9 mins ago
AG
Director, Communications Design
Adelphi Group
Toronto, ON
- Full-time
…recommendations that deliver on client strategic goals and business…
Added 9 mins ago
AG
Sr. Director, Connections Planning
Adelphi Group
Toronto, ON
- Full-time
…recommendations that deliver on client strategic goals and business…
Added 9 mins ago
AG
Head of Client Services & Toronto Office
Adelphi Group
Toronto, ON
- Full-time
…Head of Client Services & Head of Office to lead our Toronto business, combining operational ownership and office leadership with hands-on stewardship of our most important client…
Added 9 mins ago
AG
Account Director, Business Leadership - Automotive
Adelphi Group
Toronto, ON
- Full-time
…growth for a group of our clients. This specific role is on the Business Leadership side of the business, leading our largest automotive account. We’re looking for someone who has agency…
Added 9 mins ago
AG
Associate Director, Talent Acquisition
Adelphi Group
Calgary, AB · Toronto, ON
- Full-time
Partner Strategically – Collaborate with business leaders to understand hiring needs and provide talent market insights. Be the trusted advisor on recruitment best practices.
Added 9 mins ago
AG
Senior Vice President, Finance
Adelphi Group
Toronto, ON
- Full-time
We are seeking an SVP, Finance to serve as a strategic business partner to agency leadership and provide financial and operational leadership across Omnicom Public Relations, Canada,…
Added 9 mins ago
AG
Senior Manager, Integrated Media
Adelphi Group
Toronto, ON
- Full-time
…stakeholders in new and bold ways to build brand reputation and drive business…
Added 9 mins ago
AG
Senior Analyst, Data Science
Adelphi Group
Toronto, ON
- Full-time
Impact - Your work creates real outcomes - for clients, for the business, and for the industry.
Added 9 mins ago
AG
Account Manager
Adelphi Group
Calgary, AB
- Full-time
Support the Account Director in running the business, while also bringing forward new ideas and unique solutions to enhance client outcomes

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