Find work in Canada.

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

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 3 mins ago
Learning, Development & Diversity Consultant
Board Of Governors of Exhibition Place
Toronto, ON
$82,381 to $104,108 CAD / year
…plan, employer-paid health & dental, extended healthcare, and professional…
Added 3 mins ago
Manager of Employee Relations
Tsuut'ina Nation Police Service
AB · Tsuut'ina, Alberta
Full-time
Working for the Tsuut’ina Nation Police Service offers a competitive salary, comprehensive benefits package, pension plan, and opportunities for professional development.
Added 3 mins ago
DevOps Manager
Rightsline Inc
Toronto, ON
$85,000 to $95,000 CAD / year
…a Senior DevOps Engineer, a DevOps Engineer, and two Senior Systems Engineers - and hold end-to-end accountability for the infrastructure our product runs on. You will report to the Senior…
Added 3 mins ago
Technician - Policaro Acura
Policaro Group
Brampton, ON
Are you a dynamic, results-driven service professional with
Added 3 mins ago
Store Lead- Gatineau, Quebec
Lee Valley Tools
Gatineau, QC
Up to $25 CAD / hour
Provide guidance and support to staff with problem solving and decision making, to ensure excellent customer service based on the needs of the business.
Added 3 mins ago
Associate Director, Facilities Operations and Ancillary Services
University of Ottawa
Ottawa, ON
Full-time
…behalf of the Senior Director, all the University’s Building Systems operations and maintenance…
Added 3 mins ago
Nettoyeur syndiqué à d'entretien à temps partiel- Part Time Cleaner
ISS
Boucherville, QC
$23.25 CAD / hour
Part-time
Added 3 mins ago
Marketing Coordinator
Marcon Construction
Vancouver, BC
$65,000 to $85,000 CAD / year
Full-time
Marcon is looking for a Marketing Coordinator to support the coordination and execution of project-level marketing initiatives across the development lifecycle. This role helps turn…
Added 3 mins ago
Senior Data Modeler
OMERS
Toronto, ON · Head Office Toronto
Full-time
Join us to accelerate your growth & development, prioritize wellness, build connections, and support the communities where we live and work.
Added 3 mins ago
Talent Advisor - Red River Co-op
Co-op
Winnipeg, MB
Full-time
…understand workforce needs, strengthen hiring practices, and support people-focused…
Added 16 mins ago
Engineer (Electrical Power) - High Current Lab
Kinectrics
Toronto, ON
Full-time
Support the maintenance and upgrades to the key test equipment. Introduce and implement innovations to the plant equipment and data acquisition and monitor computer systems.
Added 16 mins ago
Analyst/Consultant, Healthcare Solutions
Deloitte
Toronto, ON
Full-time
…future. And as the largest 100% Canadian-owned and operated professional services firm in our country, we are proud to work alongside our clients to make a positive impact for all…
Added 16 mins ago
Product Development Engineer - Mechanical Design For Liquid Cooling
Amphenol Communications Solutions
Markham, ON
Full-time
…electrical, electronic and fiber optic connectors and interconnect systems, antennas, sensors and sensor-based products and coaxial and high-speed specialty cable. ACS has an expansive…
Added 16 mins ago
Junior Estimator and Inside Sales (Exterior Cladding and Building Envelope)
Change Connect
Toronto, ON
Full-time
…curated portfolio of exterior cladding and building envelope systems on behalf of leading manufacturers across Canada. With a strong reputation for technical expertise and reliable service,…
Added 16 mins ago
Intermediate OT Network Engineer/Technologist
InnoTech Engineering Inc.
Calgary, AB
Full-time
…handling both small and large OT projects while also providing support for day-to-day facility operations. InnoTech’s primary services are Controls (PLC, DCS, SCADA), Electrical (low and…
Added 16 mins ago
Internal Auditor (Business Control & IT)
Husky Technologies
Bolton, ON
Full-time
This position requires a versatile audit professional who is comfortable working across financial, operational, and technology environments. The successful candidate will evaluate the…
Added 16 mins ago
Junior Inside Sales
ICM Asset Management
Calgary, AB
Full-time
We are seeking a Junior Inside Sales professional to help grow relationships with prospective and existing Advisors through outreach, timely follow-up, and responsive service. Based in…
Added 16 mins ago
Field Service Manager (HVACR)
Copeland
Brantford, ON
Full-time
Whether you are a professional looking for a career change, an undergraduate student exploring your first opportunity, or recent graduate with an advanced degree, we have opportunities that…
Added 16 mins ago
Financial Manager - PLM (Product Line Mgmt)
Husky Technologies
Bolton, ON
Full-time
…attracted to bold goals, believe in uncompromising honesty, support mutual respect, care about environmental responsibility, have a passion for excellence and a desire to make a positive…
Added 16 mins ago
Communications Specialist
Paladin Energy
Saskatoon, SK
Full-time
…team. This is an exciting opportunity for a communications professional who enjoys storytelling, stakeholder engagement, media relations, digital communications, and community outreach.…
Added 16 mins ago
Project Coordinator
Team Power Solutions
Saskatoon, SK
Full-time
…opportunity, and purpose. We invest in our people by providing professional development, technical and leadership training, mentorship, career advancement opportunities, cross-functional…
Added 16 mins ago
Temporary Fashion Associate - RW&CO
RW&CO
Kitchener, ON
Part-time
As a Fashion Associate, you will deliver personalized service and support daily store operations to ensure a welcoming, customer-first environment. From assisting in the fitting room to…
Added 16 mins ago
Director of Operations
Insurance Brokers Association of Alberta
AB · Edmonton, AB
Full-time
…implementation, and continuous improvement of operational strategies that support the association's mission, strategic priorities, and financial…
Added 16 mins ago
Temporary Fashion Associate - RW&CO
RW&CO
AB · Edmonton, AB
Part-time
As a Fashion Associate, you will deliver personalized service and support daily store operations to ensure a welcoming, customer-first environment. From assisting in the fitting room to…
Added 16 mins ago
Training Coordinator (Commercial Aviation Maintenance Training)-EN
CAE
Montreal, QC
Full-time
…for stakeholders, training administration, and operational support functions to ensure the effective delivery of training…

Synechron

Semantic Model Developer

Mississauga, ON, Canada

Pay: $110,000 to $120,000 USD / year
Job type: Full-time
Apply by: Oct 28, 2026
Posting language: English
Posted: Sep 28, 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

We are seeking a skilled Semantic Model Developer to design, develop, and maintain enterprise semantic models that enable consistent, trusted, and user-friendly data analysis. The role involves translating business requirements into logical data models, defining business metrics and relationships, and supporting reporting, analytics, and self-service business intelligence initiatives.

The ideal candidate has strong experience with data modeling, SQL, BI platforms, data warehousing, and stakeholder collaboration.

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 $110k – CAD $120k/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:

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.

Apply About employer

More about this job

Responsibilities

Design, develop, and maintain enterprise Power BI semantic models and SSAS tabular or multidimensional models, translating financial-services requirements into governed, reusable analytical models. Build reports and dashboards, optimize data models and queries, manage refresh and deployment processes, and troubleshoot performance, data, and security issues.

Requirements

Requires professional banking or financial-services experience, strong hands-on expertise in Power BI semantic modeling, SSAS, DAX, SQL/T-SQL, dimensional modeling, and Power BI Service. Candidates should also have experience with data warehouses, ETL/ELT, data security, performance optimization, validation, and stakeholder collaboration, and must be located in or authorized to work in Canada.

Skills

Power BI Semantic Modeling
SSAS Tabular
SSAS Multidimensional
DAX
MDX
SQL
T-SQL
Dimensional Modeling
Star and Snowflake Schemas
Power Query
M
Data Warehousing
ETL and ELT
Azure Data Factory
Data Security
Row-Level Security

Benefits

Paid Annual Leave
Personal Leave
Medical Insurance
Dental Insurance
Vision Insurance
Life Insurance
Long-Term Disability Insurance
Flexible Hybrid Work Policy
Employer RRSP Contributions
Higher Education Certification Support
Udemy for Business Access
Coaching and Mentoring Opportunities
International Work Opportunities
Learning and Development Programs

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
Row-Level Security
Incremental Refresh
Calculation Groups
Composite Models
XMLA Endpoints
Tabular Editor
DAX Studio
Microsoft Fabric

Report this job