Find work in Canada.

327,417 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 1 min ago
Lead, Corporate Accountant
Venterra Realty
Richmond Hill, ON
Full-time
Lead initiatives involving ERP systems, Power BI, Power Query, Power Automate, and other reporting tools.
Added 15 mins ago
Lead, Corporate Accountant
Venterra Realty
Richmond Hill, ON
Full-time
Lead initiatives involving ERP systems, Power BI, Power Query, Power Automate, and other reporting tools.
Added 15 mins ago
Vice President, Risk Data Strategy and Transformation
TD
Toronto, ON
Full-time
Experience with data technology and product management across major platforms and tools. Familiarity with Rahona, Technology Asset Platform, Databricks, Power BI, or comparable technologies…
Added 15 mins ago
Senior Financial Crime Risk Analyst (5515)
TD
Toronto, ON
Full-time
…reporting solutions using Microsoft technologies, including Power Automate, Power Apps, Power BI, Copilot, and SharePoint that improve operational efficiency, strengthen controls, and…
Added 29 mins ago
Digital Performance Analyst
Loblaw Companies Limited
Toronto, ON
Full-time
…supporting retail, digital consumer solutions and analytical platforms excite you? Loblaw Technology powers some of Canada’s most game-changing retail solutions, giving our customers the…
Added 30 mins ago
Junior Resource Strategy Analyst
AtkinsRéalis
Mississauga, ON
Full-time
Update Bridget Bench system, create dashboards and reports using business intelligence tools such as Power BI, EcoSys, or other reporting platforms.
Added 30 mins ago
Junior Resource Strategy Analyst
AtkinsRéalis
Mississauga, ON
Full-time
Update Bridget Bench system, create dashboards and reports using business intelligence tools such as Power BI, EcoSys, or other reporting platforms.
Added 46 mins ago
Senior Data Platform Developer
Dialogue
Toronto, ON · Montreal, QC
$105,000 to $135,000 CAD / year
We are looking for a Senior Data Platform Developer that is excited to design, build, and maintain our modern data platform. In this role, you will define and implement engineering best…
Added 1 hour ago
Senior Power BI Developer
Robert Half
Calgary, AB
Full-time
We are seeking a mid-senior to senior-level Business Intelligence (BI) Developer to play a key role in advancing and scaling enterprise business intelligence capabilities. This position…
Added 1 hour ago
Sr. Consultant, Data Developer
CIBC
Toronto, ON
Full-time
As the Sr. Consultant, Data Developer you’ll be a key part of an innovative, first to market technology culture, contributing to key CIBC’s strategies such as digital transformation, cloud…
Added 1 hour ago
Co-Op, Development Operations AI & Automation Enablement Intern
AstraZeneca
Mississauga, ON · Canada - Mississauga
Full-time
Experience with data analytics and visualization tools such as Power BI, Tableau, or similar platforms.
Added 1 hour ago
Sr. Developer, BI
Aecon
Toronto, ON
The Sr. BI Developer is responsible for designing, developing, and implementing enterprise data solutions using SAP Datasphere. This role supports data integration, modeling,…
Added 1 hour ago
Principal Azure Databricks Architect
Hays
Toronto, ON
Contract
…Architect to design, implement, and optimize enterprise-scale data platforms within the Azure ecosystem. The ideal candidate will have deep expertise in Azure Databricks, enterprise data…
Added 1 hour ago
System Optimization Specialist Engineer (FTT)
BC Hydro
Burnaby, BC
$131,100 to $165,800 CAD / year
Temporary
…transformations. Experience in reporting and enterprise data management platforms (Power BI, Fabric,…
Added 1 hour ago
Financial Sector Specialist Analyst
Bank of Canada
Ottawa, ON
Full-time
experience working with cloud-based analytics platforms such as Microsoft Azure, Databricks and Power BI/Fabric
Added 1 hour ago
Human Resources Information System Analyst
Soho Square Solutions
Montreal, QC
Contract
Excel for data tasks; Power BI a plus; Jira management
Added 1 hour ago
Thermal Development Engineer
Canadian Natural
Calgary, AB
Experience with data analytics and visualization methods/software would be an asset (e.g. Tableau, Power BI, Spotfire, Python)
Added 1 hour ago
SQL Developer / Data Engineer
TD
Toronto, ON
Full-time
Position Title: Senior SQL Developer / Data Engineer
Added 1 hour ago
Solutions Design IT Specialist
TD
Toronto, ON
Full-time
…engineering teams to define roadmaps, develop scalable data platforms, and deliver data products that support strategic business objectives. Responsible for both technical leadership and…
Added 1 hour ago
Enterprise Content Management (ECM) Business Systems Analyst
McKesson
Mississauga, ON
Full-time
The Business Analyst will serve as a key partner on the Imaging & Content Platforms team, supporting enterprise content management, digital document workflows, ERP-related modernization,…
Added 2 hours ago
Project Manager -PMO
Pentangle Tech Services | P5 Group
Calgary, AB
Full-time
Experience with Power BI, PPM platforms, ERP systems, and project controls software.
Added 2 hours ago
Business System Analyst
SPECTRAFORCE
Toronto, ON
$75 to $80 CAD / hour
Contract
Experience implementing, integrating, or supporting QRM or comparable Treasury / ALM platforms OR Proven track record of delivering large-scale enterprise system implementations, ideally…
Added 2 hours ago
Consumer Insights Manager
Conagra Brands
Mississauga, ON
Full-time
· Strong proficiency across a range of quantitative and qualitative research tools and methodologies, including Nielsen, Power BI, and AI-enabled analytics platforms.
Added 2 hours ago
Director, Investment Product Platform
BMO
Toronto, ON · FCP
Full-time
Acts as the prime subject matter expert for internal and external stakeholders on managed products, investment platforms, advisory programs, relevant regulations, policies, governance…
Added 2 hours ago
Senior Data Engineer
AGLC
AB · Edmonton, AB
Full-time
…liquor and corporate systems running on a variety of computing platforms. IT ensures the stability and performance of a Local/Wide Area Network, which supports over 1,200 gaming locations…

Synechron

Semantic Model Developers

Mississauga, ON, Canada

Pay: In accordance with law, the base salary for this role if filled within Mississauga, ON is CAD $120k – CAD $130k/year & benefits (see below).
Job type: Full-time
Experience: Minimum 10 years of overall experience in business intelligence, data warehousing, analytics, data modelling, or reporting development.
Posting language: English
Posted: Sep 29, 2026

Apply About employer

Applications open in a new tab.

Original job description

We are

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 17,000+, and has 58 offices in 22 countries within key global markets.

Our challenge

Semantic Model Developer will design, develop, optimize, and maintain enterprise-grade semantic models, analytical cubes, reports, and dashboards. The successful candidate will have deep expertise in Power BI, SSAS Tabular, DAX, SQL, dimensional modelling, and data warehousing, along with demonstrated experience delivering solutions in banking or financial services. This role will involve translating complex business and financial-reporting requirements into scalable, governed, and high-performing analytical solutions.

Additional Information*

The base salary for this position will vary based on geography and other factors. In accordance with law, the base salary for this role if filled within Mississauga, ON is CAD $120k – CAD $130k/year & benefits (see below).

The Role

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, but not required:

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.

We offer:

A multinational organization with 58 offices in 22 countries and the possibility to work abroad.
15 days (3 weeks) of paid annual leave plus an additional 10 days of personal leave (floating days and sick days).
A comprehensive insurance plan including medical, dental, vision, life insurance, and long-term disability.
Flexible hybrid policy.
RRSP with employer’s contribution up to 4%.
A higher education certification policy.
On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.
Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups.
Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms.
A truly diverse, fun-loving and global work culture.

SYNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice

Apply About employer

More about this job

Responsibilities

The role involves designing, developing, and maintaining enterprise-grade semantic models, analytical cubes, and dashboards. You will translate complex financial reporting requirements into scalable, high-performing analytical solutions using Power BI and SSAS.

Requirements

Candidates must have at least 10 years of experience in business intelligence, data warehousing, or analytics, with specific expertise in Power BI and SSAS Tabular. Demonstrated professional experience within the banking or financial services industry is required.

Skills

Power BI
SSAS Tabular
DAX
SQL
Dimensional modelling
Data warehousing
MDX
T-SQL
Power Query
M
Azure Analysis Services
Data modelling
ETL
Azure Data Factory
Performance optimization
Financial reporting

Benefits

Medical insurance
Dental insurance
Vision insurance
Life insurance
Long-term disability insurance
RRSP with employer contribution
Paid annual leave
Personal leave
Higher education certification policy
Udemy for Business access
Coaching opportunities

Visa sponsorship

Not detected in the job text

Keywords

Semantic Model
Power BI
SSAS Tabular
DAX
SQL
Dimensional Modelling
Data Warehousing
Financial Services
Banking
MDX
T-SQL
Power Query
Azure Analysis Services
ETL
Azure Data Factory
Performance Optimization
Data Lineage
Star Schema
Snowflake Schema
Business Intelligence
Analytics
Reporting
Data Modelling
Cloud Platforms
Data Marts
Row-level Security
Data Validation
Stakeholder Management
CI/CD
FinLabs

Report this job