Senior Data & BI Developer / Architect (Power BI, MS Fabric, Databricks)

Senior Data & BI Developer / Architect (Power BI, MS Fabric, Databricks):

On behalf of our Banking client, Procom is searching for a Senior Data & BI Developer / Architect (Power BI, MS Fabric, Databricks) for a 9-month role. This position is a hybrid position with 3-4 days onsite at our client’s Toronto office.

Senior Data & BI Developer / Architect (Power BI, MS Fabric, Databricks) - Job Description:

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

Senior Data & BI Developer / Architect (Power BI, MS Fabric, Databricks) - Responsibilities:

• Design, build, and optimize data pipelines using Power BI Premium, Microsoft Fabric, and Databricks.
• Develop semantic models, star schemas, tabular models, and clean data architecture for enterprise analytics.
• Build high-quality Power BI datasets, dashboards, and reports aligned with business requirements.
• Implement data quality controls, lineage, metadata standards, and observability metrics.
• Collaborate with business partners, data engineers, risk analysts, and architects to support analytics needs.
• Manage workspace governance, performance tuning, and capacity optimization across Power BI Premium/Fabric.
• Contribute to BBCR’s BI platform modernization, including model redesign and data warehousing improvements.

Senior Data & BI Developer / Architect (Power BI, MS Fabric, Databricks) - Mandatory Skills:

• 5+ years in Data Engineering, BI Development, or Data/BI Architecture roles.
• 5+ years hands-on with Power BI (DAX, M, data modeling, Premium capacities).
• 5+ years of advanced SQL (query optimization, stored procedures, performance tuning).
• 5+ years working with Databricks (PySpark, Delta Lake, notebooks, workflow orchestration).
• 5+ years with Dimensional modeling (Kimball), semantic modeling, data governance, star schemas.
• 5+ years implementing Lakehouse architecture and modern data engineering patterns.
• 5+ years working with CI/CD for analytics, version control (Git), and DevOps pipelines.

Senior Data & BI Developer / Architect (Power BI, MS Fabric, Databricks) – Nice-to-Have Skills:

• Microsoft Fabric (Data Engineering, Data Factory, Lakehouse, Warehouse, KQL).
• Data Lake file formats: Parquet, Delta, ORC, DuckDB.
• Experience in Risk Analytics, Banking, or Credit Risk domains.
• Familiarity with PowerShell, Power Platform (Power Apps, Power Automate), Python.
• Knowledge of Security, Privacy, and Compliance standards in financial institutions.

Senior Data & BI Developer / Architect (Power BI, MS Fabric, Databricks) – Assignment Length:

This is a contract position from ASAP to December 31, 2026, with a possibility of extension or conversion to full-time employment.

Senior Data & BI Developer / Architect (Power BI, MS Fabric, Databricks) - Start Date:

ASAP

Senior Data & BI Developer / Architect (Power BI, MS Fabric, Databricks) - Assignment Location:

Toronto, Ontario, Canada – Hybrid, 3-4 days onsite based on business needs.