Senior Data & BI Developer / Architect (Power BI, MS 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

JOB DESCRIPTION

Location: Hybrid | Downtown, Toronto

Duration: 7 Months

Our client, a leading financial institution in Downtown Toronto, is looking for a Senior Data & BI Developer / Architect (Power BI, MS Fabric, Databricks) to design, build, and optimize data pipelines using Power BI Premium, MS Fabric, and/or Databricks. The successful candidate will have the opportunity to work with one of the Top 5 Banks in Canada.

Typical Day in the role:

• 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 visual 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 define requirements and deliver analytical solutions.
• Support environment configuration, workspace governance, performance tuning, and capacity optimization in Power BI Premium / Fabric capacities.
• Contribute to the modernization of BBCR’s next-generation data architecture.

Must Have Skills:

• 7+ years in Data Engineering, BI Development, or Data/BI Architecture roles.
• Hands-on technical experience with:

1. 7 years of experience with Power BI (DAX, M language, data modeling, Premium capacities). – Expert level
2. 7 years of experience with SQL (advanced querying, performance tuning, stored procedures). – Expert level
3. 5 years of experience with Microsoft Fabric (Data Engineering, Data Factory, Lakehouse, Warehouse, KQL). – Expert level
4. 3 years of experience with Databricks (PySpark, Delta Lake, notebooks, workflow orchestration).
5. Expert level experience with Data Lake file formats: Parquet, Delta, ORC, DuckDB

• Strong understanding of:

1. Dimensional modeling (Kimball), semantic modeling, and data governance.
2. Lakehouse and modern data architecture patterns.
3. CI/CD for analytics, version control (Git), and DevOps pipelines.

• Experience working in enterprise environments with structured SDLC processes.

Nice-To-Have Skills:

• Experience in Risk Analytics, Banking, or Credit Risk domains.
• Familiarity with PowerShell, Power Platform (Power Apps, Power Automate), Python.
• Architect and refine Lakehouse and Medallion-based data structures using Delta/Parquet/DuckDB formats.
• Knowledge of Security, Privacy, and Compliance standards in financial institutions.

Soft Skills Required:

• Strong communication with ability to translate technical details for business stakeholders.
• Proven ability to work independently in a fast-paced, multi-project environment.
• Problem solver mindset with focus on quality, accuracy, and analytical rigor.li>
• Collaborative team player who contributes to architectural discussions and recommendations.

Education:

• Bachelor's Degree level or above education, ideally in Computer science, Engineering, business, financial or technology
• Certified with MS Fabrics, Data Bricks and Power BI is nice to have.

FP Inc. is committed to creating an inclusive environment where all team members and clients feel like they belong. In accordance with the requirements set out in the Employment Standards Act, FP Inc. hereby declares that AI is utilized in the screening process for this position. The hourly compensation range for this role is $70/hr -$85/hr. We seek applicants with a wide range of abilities, and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, colour, religion, national origin, sex, physical or mental disability, or age.