Senior Data Analyst with Power BI, SQL and DAX Skills to support a business banking credit risk project- 39524

Senior Data Analyst with Power BI, SQL and DAX Skills to support a business banking credit risk project- 39524

Location Address: Hybrid - Toronto - 3 days/week (Wednesday, Thursday and Friday)

Subject to change: 3-4 days onsite may be required based on business needs

Contract Duration: ASAP to 12/31/2026

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

Story Behind the Need

Business group: The Credit Risk Data & Analytics team is the core analytical group supporting Business Banking Credit Risk. The team focuses on automating manual processes, delivering portfolio insights, producing portfolio management reporting, and supporting the BBCR team with both regulatory and management reporting.

Project: This role supports a highly strategic initiative designed to establish the foundation for regulatory and management reporting of a rapidly growing portfolio. The project aims to increase efficiency in limit monitoring and utilization. A key focus is the financial sponsor portfolio-a fast‑expanding business area. Phase 1, completed last year, successfully delivered foundational management reporting and was well‑received by stakeholders. Phase 2 will build on that success by integrating external data sources and addressing new business requirements to further automate and enhance reporting. The primary reporting solution will be delivered in Power BI.

Typical Day in Role:

1. Work with the Business Stakeholders, Senior Manager and the Leadership team for the end-to-end design and development of scalable and reusable Power BI Reporting Solutions that support complex analytical requirements.

2. Collaborate with stakeholders to gather, clarify, assess business needs and define business requirement for data modelling and reporting solution development.

3. Integrate data from multiple structured and semi-structured sources, ensuring data accuracy, consistency and refresh reliability.

4. Develop advanced DAX measures and calculations to support complex business logic while maintaining optimal model performance.5. Ensure data availability and data quality in the semantic model and communicate issues to upstream throughout the development cycle.

6. Diagnose, troubleshoot, and resolve issues related to Power BI semantic models, dataflows, and refresh processes, optimizing performance and reliability as needed.

7. Implement enhancements, fixes, and change requests efficiently, adapting to evolving business requirements while maintaining solution stability.

8. Create clear and concise technical documentation covering data models, DAX logic, data sources, and reporting functionality to support knowledge transfer and ongoing maintenance.

Candidate Value Proposition:

The successful candidate will play a key role within the Business Banking Credit Risk Reporting & Analytics team, contributing to high‑priority strategic initiatives that directly support enhanced business decision‑making. With the bank expanding its financial sponsor portfolio, this role offers the opportunity to be part of a growing and visible segment of the organization.

Candidate Requirements/Must Have Skills:

1) 10+ years’ overall relevant experience in data analysis

2) 5+ years’ experience advanced Power BI development expertise - with proven hands-on experience building complex Power BI datasets, reports, and dashboards, with a strong focus on performance and scalability

3) 5+ years’ experience with SQL and data querying proficiency - with a strong ability to write, optimize, and troubleshoot SQL queries against relational databases and data warehouses to support Power BI reporting needs

4) 5+ years’ data modeling and DAX skills - with a deep understanding of analytical data modeling concepts and advanced DAX, including complex measures, time intelligence, and performance optimization techniques.

Nice-To-Have Skills:

1) Security and access control knowledge - Practical experience implementing row-level security (RLS) and working within enterprise data security and governance standards.

2) Experience from FI complex projects, ideally related to business banking credit risk (not retail credit risk)

3) Experience with PowerShell scripting

Education:

Bachelor’s degree (typically in mathematics, business administration, technology, statistics or equivalent)

Power BI certifications an asset

CFA an asset

Best VS. Average Candidate:

Top candidates will proactively dive deeper into business problems, ask clarifying questions, and translate sometimes‑vague requirements into clear, actionable analytical solutions. They will demonstrate strong problem‑solving abilities and a high level of initiative.

The ideal candidate is a strong data analyst with:

• Advanced SQL skills

• Solid experience developing dashboards and reporting in Power BI

• Strong communication and stakeholder‑management skills

• Proven problem‑solving abilities

• Previous experience with similar strategic or data‑driven projects (an asset that will differentiate them)

Candidate Review & Selection - Interview Process

2 rounds - In Person Interviews preference (Wednesday, Thursday, Friday) - 30 mins to 1 hour

1st technical with HM and peer - provide exercise live in interview to solution (PowerBI, SQL test) - team will provide what is needed for the interview

2nd with Director

Hiring Manager’s availability to interview: ASAP - Interviews in person to take place on Wednesday, Thursday, Friday