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

S I Systems; Toronto; On-site; CAD 120,000 - 160,000; Full time

Job summary

S I Systems in Toronto is hiring a Senior Data & BI Developer/Architect (10+ years) to modernize data architecture using Power BI, Microsoft Fabric, and Databricks. You will design end-to-end data pipelines, build scalable semantic models, and deliver enterprise analytics assets that meet performance, governance, and reliability standards.

This hands-on role requires strong SDLC discipline, collaboration with risk analysts, data engineers and architecture teams, and a focus on data quality,

Qualifications

• 7+ years in Data Engineering, BI Development, or Data/BI Architecture roles.
• Hands-on Power BI, SQL, MS Fabric, Databricks experience.
• Experience building end-to-end data pipelines.
• Enterprise SDLC experience.
• Strong data modeling and governance knowledge.

Responsibilities

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

Skills

Power BI

SQL

Microsoft Fabric

Databricks

Data Modeling

Data Governance

CI/CD

Git

DevOps pipelines

End-to-end data pipelines

Education

Bachelor's Degree

MS Fabrics Certification

Databricks Certification

Power BI Certification

Tools

Power BI

Microsoft Fabric

Databricks

SQL Server / T-SQL

Delta Lake

Job description

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 modern 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:

• 1. Experience in Risk Analytics, Banking, or Credit Risk domains.
• 2. Familiarity with PowerShell, Power Platform (Power Apps, Power Automate), Python.
• 3. Architect and refine Lakehouse and Medallion-based data structures using Delta/Parquet/DuckDB formats.
• 4. 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.