Search Jobs
So sorry, this position is no longer available.
Please go ahead and submit your application. We may have other positions that would be the perfect fit for you.
Alternatively, you may want to apply to one of the following related jobs:
Lead Data & BI Architect
Job Description
Location Address: Hybrid - Toronto –3-4 days/week (Wednesday, Thursday, Friday)
Subject to change: 3–4 days onsite may be required based on business needs
Contract Duration: ASAP to 12/31/2026 –approx. 9 months
Possibility of extension (on other projects) & conversion to FTE
Schedule Hours: 9am-5pm Monday-Friday;standard 37.5 hrs/week
Role: Solution Architect (Lead Data & BI Architect)
Story Behind the Need
Business group: Credit Risk Data & Analytics - Business Banking Credit Risk (BBCR) –Data & Analytics - The BBCR Data & Analytics team supports analytics and reporting across four major business lines (International, GBM Commercial, Wealth Management) for the corporate credit portfolio. 7-8 team members: business intelligence managers, PMs, architects
Project: 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.
This senior role is required to lead BI platform modernization, mentor Level 3 contractor, and establish architectural best practices for data modelling, reporting, and Lakehouse integration. The role reports into senior managers and will serve as the design lead on this project.
Candidate Value Proposition:
The successful candidate will:
•Serve as the architect for BBCR’s modern analytics platform.
•Influence enterprise level BI and data modernization strategies.
•Lead and mentor a growing BI team while shaping long-term platform capabilities.
•Work on modernization initiatives that prepare the bank for AI/ML driven analytics.
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.
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.
•Collaborative team player who contributes to architectural discussions and recommendations.
Education:
Bachelors in technical field
Data Analytics / Science certifications an asset
Best VS. Average Candidate:
Best Candidate
A true architect who can lead BI modernization, not just build dashboards.
Can independently design end to end Lakehouse + semantic models + Fabric pipelines.
Strong leadership, communication, and mentorship capabilities.
Thinks long-term: builds AI-ready, scalable, governed solutions.
Average Candidate
Strong hands-on developer but lacks architectural thinking or leadership ability.
Can deliver assets but not define standards, frameworks, or long-term design decisions.
Candidate Review & Selection –Interview Process
2 rounds –In person –40 King Street West –up to 45 minutes
1st –with senior managers and Director –could include a technical test on SQL
2nd –with senior managers and Director –further evaluation
Hiring Manager’s availability to interview: ASAP
***NOTE: *** will review any requests for accommodations put forward by Suppliers***
Subject to change: 3–4 days onsite may be required based on business needs
Contract Duration: ASAP to 12/31/2026 –approx. 9 months
Possibility of extension (on other projects) & conversion to FTE
Schedule Hours: 9am-5pm Monday-Friday;standard 37.5 hrs/week
Role: Solution Architect (Lead Data & BI Architect)
Story Behind the Need
Business group: Credit Risk Data & Analytics - Business Banking Credit Risk (BBCR) –Data & Analytics - The BBCR Data & Analytics team supports analytics and reporting across four major business lines (International, GBM Commercial, Wealth Management) for the corporate credit portfolio. 7-8 team members: business intelligence managers, PMs, architects
Project: 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.
This senior role is required to lead BI platform modernization, mentor Level 3 contractor, and establish architectural best practices for data modelling, reporting, and Lakehouse integration. The role reports into senior managers and will serve as the design lead on this project.
Candidate Value Proposition:
The successful candidate will:
•Serve as the architect for BBCR’s modern analytics platform.
•Influence enterprise level BI and data modernization strategies.
•Lead and mentor a growing BI team while shaping long-term platform capabilities.
•Work on modernization initiatives that prepare the bank for AI/ML driven analytics.
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.
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.
•Collaborative team player who contributes to architectural discussions and recommendations.
Education:
Bachelors in technical field
Data Analytics / Science certifications an asset
Best VS. Average Candidate:
Best Candidate
A true architect who can lead BI modernization, not just build dashboards.
Can independently design end to end Lakehouse + semantic models + Fabric pipelines.
Strong leadership, communication, and mentorship capabilities.
Thinks long-term: builds AI-ready, scalable, governed solutions.
Average Candidate
Strong hands-on developer but lacks architectural thinking or leadership ability.
Can deliver assets but not define standards, frameworks, or long-term design decisions.
Candidate Review & Selection –Interview Process
2 rounds –In person –40 King Street West –up to 45 minutes
1st –with senior managers and Director –could include a technical test on SQL
2nd –with senior managers and Director –further evaluation
Hiring Manager’s availability to interview: ASAP
***NOTE: *** will review any requests for accommodations put forward by Suppliers***
Meet Your Recruiter
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About Toronto, ON
Ready to take the next step in your career? Explore exciting job opportunities in the thriving area surrounding Toronto, Ontario. Known for its diverse cultural landscape, vibrant arts scene, and bustling professional opportunities, Toronto is a city brimming with charm and endless growth potential. From the iconic CN Tower and world-renowned art galleries like the AGO to the lively theater scene and beloved sports teams like the Raptors and Maple Leafs, Toronto offers a rich tapestry of experiences for job seekers. Consider launching your career in this dynamic region and unlock a world of possibilities. Browse our job listings now and begin your journey towards success in Toronto and its surrounding areas.
Staffing Leader of the Year Anju Abel
CEO, LanceSoft
LanceSoft is proud to announce that its Chief Executive Officer, Anju Abel, has been honored with the prestigious "Staffing Leader of the Year" award at the 2025 TIARA Staffing Awards US. The award recognizes her visionary leadership and significant contributions to improving staffing processes, employee engagement, and workforce outcomes.
Anju Abel's leadership has been instrumental in transforming LanceSoft's global staffing operations. Her focus on innovation, employee satisfaction, and client-centric delivery has led to higher retention rates, a motivated workforce, and enhanced operational efficiency.
"This award is a testament to the incredible team at LanceSoft and our unwavering commitment to redefining staffing solutions," said Anju Abel. "I'm honored to receive this recognition and proud of the impact we continue to make in the lives of our clients and talent worldwide."
The judging panel highlighted Anju's ability to consistently deliver outstanding client success stories, exceed expectations, and foster professional development within her team. Her active community involvement and dedication to advancing the staffing industry were also key factors in her selection.
TIARA Awards are known for celebrating excellence, innovation, and achievement in the talent acquisition sector, and this accolade places Anju among the top leaders reshaping the future of workforce solutions.