Senior Data & BI Developer / Architect (10+ years) to modernize data architecture using Power BI, Microsoft Fabric, and Databricks- 41532 Senior Data & BI Developer / Architect (10+ years) to modernize data architecture using Power BI, Microsoft Fabric, and Databricks- 41532

Location Address: Toronto- 3 days in-office (Potentially will increase to 4 in future)

In-office days: Wednesday, Thursday and Friday.

Contract Duration: 10/05/2026 to 06/04/2027 (Chance of Extension)

Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/week

Story Behind the Need

Business group

Business Banking Credit Risk (BBCR) – Data & Analytics

Project

Looking for a skilled Senior Data & Business Intelligence Developer/Architect to drive data initiatives in Business Banking Credit Risk (BBCR).

This role focuses on modernizing data architecture, boosting analytics, and developing scalable, cloud-native BI solutions using Power BI, Microsoft Fabric, and Databricks.

The ideal candidate has strong hands-on experience building end to end data pipelines, designing efficient data models, and developing analytical assets that meet enterprise standards for performance, governance, and reliability.

Reason : New role for a funded project.

Key Accountabilities

Design, build, and optimize data pipelines using Power BI Premium, MS Fabric, and/or Databricks.

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:

7 years of experience with Power BI (DAX, M language, data modeling, Premium capacities). – Expert level

7 years of experience with SQL (advanced querying, performance tuning, stored procedures). – Expert level

5 years of experience with Microsoft Fabric (Data Engineering, Data Factory, Lakehouse, Warehouse, KQL). – Expert level

3 years of experience with Databricks (PySpark, Delta Lake, notebooks, workflow orchestration).

Expert level experience with Data Lake file formats: Parquet, Delta, ORC, DuckDB

Strong understanding of

Dimensional modeling (Kimball), semantic modeling, and data governance.

Lakehouse and contemporary data architecture patterns.

CI/CD for analytics,



version control (Git), and DevOps pipelines.

Experience working in enterprise environments with structured SDLC processes.

Nice to have

- 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.

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.

Best VS. Average Candidate:

This will be a technical role. Need hands on technical development expertise.

Looking for a Senior Data & BI Developer / Architect with previous experience with modernizing data architecture, boosting analytics, and developing scalable, cloud-native BI solutions using Power BI, Microsoft Fabric, and Databricks.

The ideal candidate has strong hands-on experience building end to end data pipelines, designing efficient data models, and developing analytical assets that meet enterprise standards for performance, governance, and reliability.

Candidate Review & Selection

Interview format: 2 rounds of interviews

1 round with over MS team Video – 30 mins. With HM and Leadership.

2 nd round - 30mins – In-Person Interview with HM and Senior Team member

Technical and Behavioural questions based on previous experience.

📌 Senior Data & BI Developer / Architect (10+ years) to modernize data architecture using Power BI, Mi (Toronto)
🏢 S.i. Systems
📍 Toronto