Senior Data & BI Architect: Power BI, Fabric & Databricks

Finance Professionals Inc.; Toronto; Hybrid; CAD 96,000 - 117,000; Full time

Job summary

Finance Professionals Inc. is seeking a Senior Data & BI Developer / Architect for a 7-month contract in Downtown Toronto.

The role focuses on designing, building, and optimizing data pipelines using Power BI, MS Fabric, and Databricks within a hybrid work setting. You will develop scalable semantic models, robust dashboards, and standardize data quality, lineage, and governance while collaborating with data engineers, risk analysts, and architecture teams to deliver enterprise analytics

Qualifications

• 7+ years in Data Engineering, BI Development, or Data/BI Architecture roles.
• Hands-on experience with Power BI, SQL, Fabric, Databricks and data lake formats.
• Experience in enterprise analytics, semantic modeling, and data governance.
• Proven ability to work in enterprise environments with structured SDLC processes.

Responsibilities

• Develop scalable semantic models, star schemas, and tabular models for enterprise analytics.
• Build high-quality Power BI datasets, dashboards, and reports aligned with business requirements and best practices.
• Implement data quality controls, lineage documentation, metadata standards, and observability metrics.
• Collaborate with business partners, data engineers, risk analysts, and architecture teams to deliver analytical solutions.
• Support environment configuration, workspace governance, performance tuning, and capacity optimization in Power BI Premium / Fabric.
• Contribute to modernization of next-generation data architecture.

Skills

Power BI

SQL

Microsoft Fabric

Databricks

Data modeling

Data governance

Education

Bachelor's degree in CS/Engineering/Business/Tech

MS Fabric / Databricks / Power BI certifications (nice to have)

Tools

Git

SDLC tools

Job description

Finance Professionals Inc. is seeking a Senior Data & BI Developer / Architect for a 7-month contract in Downtown Toronto.

The role focuses on designing, building, and optimizing data pipelines using Power BI, MS Fabric, and Databricks within a hybrid work setting. You will develop scalable semantic models, robust dashboards, and standardize data quality, lineage, and governance while collaborating with data engineers, risk analysts, and architecture teams to deliver enterprise analytics