CareerPlan

Semantic Model Developers

Mississauga, ON, CAFull-timeCA$120k2026-09-29 → 2026-11-13
On-site · Canada

Core

Design, develop, optimize, and maintain enterprise-grade semantic models, analytical cubes, reports, and dashboards for banking and financial services.

Role type

Senior BI Semantic Model Developer

Builds

Scalable, governed analytical solutions (Power BI semantic models, SSAS Tabular/OLAP cubes, DAX measures, SQL queries)

Domain

Financial Services / Business Intelligence / Data Warehousing

Required skills

Power BI semantic modeling, SSAS Tabular, DAX, SQL, dimensional modelling, data warehousing, OLAP cubes, MDX, Power Query/M, data lineage, row-level security

Preferred skills

Azure Analysis Services, Microsoft Fabric, Tabular Editor, DAX Studio, CI/CD pipelines, Python, Apache Spark

Technologies

Power BI, SSAS, Azure Analysis Services, SQL Server, Azure Data Factory, Synapse Analytics, DAX, MDX, Power Query

Responsibilities

Design and develop enterprise-grade Power BI semantic models and SSAS tabular/OLAP cubes; Translate complex financial-reporting requirements into scalable analytical models; Develop complex DAX measures, calculated columns, and time-intelligence solutions; Optimize semantic models, DAX calculations, and SQL queries for performance; Maintain clear data lineage between source systems and reports; Configure and troubleshoot scheduled refreshes, gateways, and deployment activities

Seniority

Senior, hands-on IC