Find work in Canada.

556,385 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 12 mins ago
AI
Business Systems Analyst – Salesforce
American Iron and Metal
Montreal, QC
- Full-time
Data tools: Basic knowledge of SQL and Business Intelligence (BI) reporting tools is an asset.
Added 27 mins ago
Procurement Manager
PagerDuty
Toronto, ON
Champion the daily, practical adoption of Artificial Intelligence and advanced automation tools to streamline market research, contract analysis, spend analytics, and administrative…
Added 27 mins ago
K
Consultant/Senior Consultant , Strategy & Economy
KPMG
Brossard, QC · Joliette, QC · Laval, QC · Mont-Royal, QC · Montreal, QC · Quebec, QC · Saint-Laurent, Quebec · Mount Royal, Quebec
- Full-time
Added 27 mins ago
TC
Business Analyst
Tata Consultancy Services
Toronto, ON
- $60,000 to $70,000 CAD / year
- Full-time
…themselves across the full AI stack, from infrastructure to…
Added 27 mins ago
G
Head of Insurance Solutions
Geotab
Waterloo, ON
- Full-time
…people leadership, development, and organizational health; business performance, investment prioritization, and KPA attainment; and cross-domain coordination and practitioner community…
Added 27 mins ago
MD
Transactions Specialist - Human Resources Technician 2
Minnesota Direct Care and Treatment
Saint-Paul, NB · St.-Paul, NB
- Full-time
Experience using Oracle Business Intelligence Enterprise Edition (OBIEE) reporting.
Added 27 mins ago
A
Manager, Sales Compensation
Aviso
Toronto, ON
- $110,000 to $135,000 CAD / year
- Full-time
…incentive plans effectively drive sales performance, support business objectives, and align with organizational priorities. Working closely with Sales, Finance, and People teams, the…
Added 27 mins ago
A
Human Resources Director/VP
Adecco
Toronto, ON · Greater Toronto Area, Canada
- $160,000 to $180,000 CAD / year
- Full-time
This leader will bring consistency across provinces while understanding that each region and business group may have different operational and regulatory requirements. The position requires…
Added 27 mins ago
ED
Spécialiste en Logistique | Logistics Specialist
Eco DC Solutions
Montreal, QC
- Full-time
…critiques répondant à la croissance rapide de l'infonuagique, de l'intelligence artificielle et des technologies…
Added 42 mins ago
JI
Business Intelligence Student - Pulp & Paper Division - Winter 2027
J.D. Irving, Limited
Saint John, NB
- Full-time
This is an excellent opportunity for a student interested in data analytics, business intelligence, visualization, and Microsoft technologies to gain hands-on experience with…
Added 42 mins ago
OO
Director - Banking Risk and Capital (Credit Risk) Division
Office of the Superintendent of Financial Institutions Canada
Toronto, ON
- Full-time
A degree or diploma from a recognized post-secondary institution with specialization in business, commerce, economics, finance, accounting or other relevant field.
Added 42 mins ago
S
Product Engineering Intern
Semtech
Burlington, ON · CAN - Burlington, ON
- Full-time
…high-quality products that exceed customer expectations and drive business success - and our versatile, results-driven team makes it…
Added 42 mins ago
C
Senior Financial Analyst, Syndicate Accounting
CIBC
Toronto, ON
- Full-time
The Syndicate Accounting Team is responsible for the integrity and timeliness of the Investment Banking business units’ financial reporting. In this role you will report to the Syndicate…
Added 56 mins ago
M
Human Capital Data Advisor
MNP
AB · Calgary, AB
- Full-time
Develop and maintain process documentation and provide end-user support through training, incorporating business intelligence best practices
Added 56 mins ago
Business and Configuration Analyst, AI
CityofOttawa
Ottawa, ON
Note: This is a hands-on software development position within the Artificial Intelligence (AI) team, focused on developing, integrating, deploying and supporting AI solutions, including…
Added 56 mins ago
ZS
Semantic Model and Cube Developer at at Mississauga, ON (Hybrid)
Zodiac Solutions, Inc
Mississauga, ON
- Contract
Minimum 7 years of overall experience in business intelligence, data warehousing, analytics, data modelling, or reporting development.
Added 1 hour ago
JT
Senior Data Engineer
Javelin Technologies
Canada
- Full-time
…the group's data ecosystem: integrating data from our core business systems, developing robust pipelines, establishing quality and governance standards, and delivering the advanced…
Added 1 hour ago
ZS
Hiring - PowerBI Developer - Banking/Capital market exp. at Mississauga, ON (Hybrid)
Zodiac Solutions, Inc
Mississauga, ON
- Contract
Gather reporting and analytics requirements from business stakeholders and translate them into effective BI solutions.
Added 1 hour ago
MG
Financial Reporting Manager / Directeur, analyse et informations financières
Maples Group
Montreal, QC
- Full-time
…core responsibilities and provide financial insight across the…
Added 1 hour ago
IG
Senior Business Controls Consultant
Insight Global
Toronto, ON
- $65 to $77 CAD / hour
- Contract
Experience with controls automation tools (such as GRC platforms, RPA, data analytics).
Added 1 hour ago
BR
Director of Finance And Accounting
BJRC Recruiting
Toronto, ON
- Full-time
Develop management reporting, dashboards and business intelligence solutions that provide meaningful and actionable insights.
Added 2 hours ago
OT
Director, FICC, Global Trading – Total Fund Management
Ontario Teachers' Pension Plan
Toronto, ON
- Full-time
…team’s strategy and driving the growth of our global trading…
Added 2 hours ago
T
Senior Manager – Analytics & Insights
Teqfocus
Markham, ON
- Full-time
Substantial experience in analytics, business intelligence, data-driven decision support or related leadership roles; 8–10+ years is a recruitment guideline to be validated.
Added 3 hours ago
A
Sourcing Specialist (Bangkok-based, Relocation Provided)
Agoda
Vancouver, BC
- Full-time
Set the standard for world-class outreach, candidate experience and key stakeholders’ collaboration (both within Talent Acquisition and the business teams you support).
Added 3 hours ago
Q
Senior Conversational Bot Engineer
Quantiphi
Canada
- Full-time
…Fortune 1000 organizations transform bold ideas into measurable business impact. We go beyond building innovative AI technologies - we solve the problems that matter most to our…

Zodiac Solutions, Inc

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

Mississauga, ON, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

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

Original job description

Role: Semantic Model and Cube Developer

Location: Mississauga, ON (3 Days hybrid/week)

Contract

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 7 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 and support reports, optimize model and query performance, manage refreshes and deployments, and resolve production issues across reporting environments.

Requirements

Requires at least seven years of relevant BI, data warehousing, analytics, modeling, or reporting experience, including professional banking or financial-services experience. Candidates need strong Power BI, SSAS, DAX, SQL, dimensional modeling, ETL/ELT, security, performance optimization, testing, and stakeholder communication skills, and must be located 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
Power BI Service
Azure Data Factory
Data Validation and Reconciliation

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
CI/CD

Report this job