Find work in Canada.

A simpler way to find your next job.

Jobs in Canada

Email me new jobs Save this search

Added 9 days ago
ZS
Semantic Model and Cube Developer at Mississauga, ON (Hybrid)
Zodiac Solutions, Inc
Mississauga, ON
- Contract
Experience with Azure SQL, Azure Data Factory, Azure Data Lake, Synapse Analytics, or Microsoft Fabric.
Added 9 days ago
HG
Model Risk Management with Financial Crime Compliance (FCC)
Hallmark Global Solutions Ltd
Toronto, ON
- Full-time
We are looking for a Risk model developer to join us in Toronto
Added 9 days ago
Systems Analyst II
City of Vancouver
Vancouver, BC
With a strong commitment to being a City of Reconciliation, we invite you to join our dedicated team and become part of an innovative, inclusive, and engaging workplace. A career with the…
Added 9 days ago
P
Data Engineer – Data Platform (AI-Enabled)
Petal
Canada
- Full-time
…real examples, how they use AI to deliver faster, better, and with greater…
Added 9 days ago
H
Full Stack Developer - Angular Expert
Highspring
Montreal, QC
- Contract
…forward-thinking solutions to our clients across North America. We work with innovative organizations in banking, insurance, and technology to help them build the future. At Highspring, we…
Added 9 days ago
S
AI Engineer Co-op
symplistic.ai
Woodbridge, ON
- $23 CAD / hour
- Internship
As an AI Engineer Co-op at Symplistic.ai, you will work directly with our engineering team to design, develop, test, and deploy enterprise AI applications and AI agents.
Added 9 days ago
H
Finance & Strategy Manager
Hopper
Remote, Canada
- $160,000 to $200,000 CAD / year
- Full-time
- Remote
Experience with Python and/or BI tools (Looker, Tableau, etc.)
Added 9 days ago
H
Gestionnaire, Finance et stratégie// Finance & Strategy Manager
Hopper
Remote, Canada
- $160,000 to $200,000 CAD / year
- Full-time
- Remote
…sommes une équipe agile qui avance rapidement, et nous utilisons SQL et des outils d'IA comme Claude pour automatiser le travail manuel afin de consacrer notre temps à l'analyse et à la…
Added 9 days ago
H
Finance & Strategy Manager
Hopper
Remote, Canada
- $160,000 to $200,000 CAD / year
- Full-time
- Remote
Experience with Python and/or BI tools (Looker, Tableau, etc.)
Added 9 days ago
SI
Software Developer
Spait Infotech
Canada
- Full-time
Experience with SQL databases such as MySQL, PostgreSQL, or SQL Server.
Added 9 days ago
MC
Senior Software Engineer
MatchBox Consulting Group
Vancouver, BC
- $133,000 to $168,000 CAD / year
- Full-time
Strong TypeScript fundamentals, with experience in other languages such as Go, Python, Java, or C# also valued.
Added 9 days ago
Software Developer, Mobile (Flutter)
HTS Engineering Ltd.
Toronto, ON
The Software Developer, Mobile (Flutter) will be responsible for the design, development, testing, release, and ongoing support of KORE’s cross-platform mobile applications built with…
Added 9 days ago
T
Manager, Actuarial
TD
Markham, ON
- Full-time
As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you more specific details for this role.
Added 9 days ago
M
Senior Full-Stack AI Engineer
Manulife
Toronto, ON · Waterloo, ON
- Full-time
Strong hands-on experience with Python for backend development, API integration or AI-enabled application workflows.
Added 9 days ago
GC
Data Engineer
GEI Consultants, Inc.
Kitchener, ON
- $90,000 to $150,000 CAD / year
- Full-time
Proficiency in Python and SQL; experience with PySpark or Spark is strongly preferred.
Added 9 days ago
EC
Data Engineer
Experis Canada
Toronto, ON
- Contract
- Azure Databricks, PySpark, Spark SQL, Delta Lake, Python, and SQL.
Added 9 days ago
AS
Senior Data Engineer
Ardent SoftSol Inc.
Toronto, ON
- Contract
We are seeking a highly skilled Data Engineer with strong expertise in Databricks and modern cloud data platforms. The ideal candidate will design, develop, and optimize scalable data…
Added 9 days ago
A
Oracle DBA / Toronto, ON (Onsite) - FTE
AceStack
Toronto, ON
- Full-time
We are seeking an experienced Oracle Database Administrator (DBA) with strong expertise in Oracle Database Administration, advanced PL/SQL development, database performance tuning, and AWS…
Added 9 days ago
FR
Structured Credit & CLOs - Analyst - Toronto
Fitch Ratings
Toronto, ON
- Full-time
Proven track record of data-analysis of large datasets or working with programming tools, such as SQL, Python, VBA or comparable tools.
Added 9 days ago
T
Manager, Actuarial
TD
Markham, ON
- Full-time
As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you more specific details for this role.
Added 9 days ago
LV
DATA AND ANALYTICS DIRECTOR-EN
La Vie En Rose
Montreal, QC
- Full-time
Knowledge of data manipulation and advanced analytics languages (SQL, DAX, Python, etc.).
Added 9 days ago
Senior Analyst, Business Intelligence Systems
Scotiabank
Toronto, ON
Experience with reporting & statistical software packages such as SAS, SQL, report builder, Power BI, and Python (Experience with Python is a nice to have)
Added 9 days ago
MF
Trader
Mackenzie Financial Corporation
Toronto, ON · Greater Toronto Area, ON
- Other
Proficiency in Bloomberg and Microsoft Office. Coding in Python, SQL, VBA is an asset.
Added 9 days ago
P
Data Engineer – Data Platform (AI-Enabled)
Petal
Remote, Canada
- Full-time
- Remote
…real examples, how they use AI to deliver faster, better, and with greater…
Added 9 days ago
SS
DevOps Technical Team Lead, VP
State Street
Toronto, ON
- Full-time
At least 5 years of hands-on experience with Python, Java, and SQL.

Zodiac Solutions, Inc

Semantic Model and Cube Developer at Mississauga, ON (Hybrid)

Mississauga, ON, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Apply by: Nov 20, 2026
Experience: Minimum 10 years of overall experience in business intelligence, data warehousing, analytics, data modelling, or reporting development.
Posting language: English
Posted: Oct 21, 2026

Original job description

Role: Semantic Model and Cube Developer

Location: Mississauga, ON(3 Days hybrid)

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.

Requirements:

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 skills:

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 cubes, translating banking and financial reporting needs into governed, reusable analytical models. Build reports and dashboards, manage model deployment and security, and optimize data models, DAX, SQL, refresh processes, and report performance.

Requirements

Requires at least 10 years of experience in BI, data warehousing, analytics, data modeling, or reporting, including professional banking or financial-services experience. Candidates need strong Power BI, SSAS, DAX, SQL, dimensional modeling, and performance optimization skills, along with data validation, stakeholder communication, and authorization 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
Performance Optimization
Row-Level Security
Azure Data Factory
Data Validation and Reconciliation
CI/CD and Deployment Pipelines
Banking and Financial Services

Visa sponsorship

Not detected in the job text

Keywords

Power BI
Power BI 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
Composite Models
Tabular Editor
DAX Studio

Report this job