BI Architect contract role for banking client. 9-month contract with onsite requirement in Toronto, requiring 8+ years in Data Engineering, Power BI, SQL, Databricks, and dimensional modeling.
Responsibilities
Our banking client is hiring a BI Architect on a contract basis. This is a 9 month contract to start with a potential extension, located in downtown Toronto with an onsite requirement of 3-4 times per week.
Requirements
Candidate Requirements/Must Have Skills: 1. 8+ years in Data Engineering, BI Development, or Data/BI Architecture roles. 2. 8+ years hands-on with Power BI (DAX, M, modeling, Premium capacities). 3. 8+ years of advanced SQL (optimizations, stored procedures, performance tuning). 4. 8+ years with Databricks (PySpark, Delta Lake, workflows, notebooks). 5. 8+ years with Dimensional modeling (Kimball), semantic modeling, governance, and star schema design. 6. 8+ years designing Lakehouse architecture and modern data stack solutions. 7. 8+ years working with CI/CD for analytics, Git, and DevOps pipelines. Nice-To-Have Skills: 1) Microsoft Fabric (Data Engineering, Data Factory, Lakehouse, Warehouse, KQL). 2) Data Lake file formats: Parquet, Delta, ORC, DuckDB (nice to have). 3) Experience in Risk Analytics, Banking, or Credit Risk domains. 4) Familiarity with PowerShell, Power Platform (Power Apps, Power Automate), Python. 5) Architect and refine Lakehouse and Medallion-based data structures using Delta/Parquet/DuckDB formats. 6) Knowledge of Security, Privacy, and Compliance standards in financial institutions. 7) Experience working in enterprise environments with structured SDLC processes.
Technical Customer Support Advocate resolving complex issues for Procurify’s agentic procurement platform. Building AI - powered documentation, automations, integrations, and customer configurations.
Global Delivery Manager leading delivery pods and SaaS implementations for insurance carriers. Coordinating resources, integrations, upgrades, and scalable customer deployments.
Director leading RPA and intelligent automation architecture at Sun Life, a financial services company. Defining enterprise platforms, governance, roadmaps, and AI - enabled business process automation.
Sun Life enterprise architecture director shaping core - platform strategy, roadmaps, governance, and modernization. Integrating cloud, infrastructure, security, application platforms, and technology investments.
Sun Life enterprise architect leading cloud modernization and AI - enabled automation. Defining architectures, migration roadmaps, and governance across infrastructure and platform technologies.
Senior IT/Telecom Manager leading engineering teams and strategic technology initiatives for CBC/Radio - Canada, Canada’s public broadcaster. Managing infrastructure, projects, procurement and technical standards.
IT Specialist supporting Mac devices, onboarding, inventory, and internal IT operations. Helping Jane’s clinic - management SaaS team streamline support and serve thousands of healthcare businesses.
Enterprise Architect shaping software and platform architecture for CBC/Radio - Canada’s public broadcasting technology. Driving enterprise architecture governance, modernization and business alignment across hybrid work locations.
Remote Help Desk Analyst supporting Government of Alberta applications and stakeholders. Troubleshooting tickets, user accounts, data discrepancies, defects, and application issues.