Senior Business Systems Analyst with SQL and Finance/Accounting experience to work on a Client Analytics Platform (CAP) with one of our major banking clien

Senior Business Systems Analyst with SQL and Finance/Accounting experience to work on a Client Analytics Platform (CAP) with one of our major banking clients- 38893

Location Address: Toronto (Hybrid: 2 days in-office (will increase to 4 days in future))

Anchor days: Wed, Thursday

Contract Duration: 01/05/2026 to 12/31/2026 (Possibility of extension)

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

Story Behind the Need

• Business group: Global Banking & Markets Engineering (GBME) - Client & Data Management
• Project: Client Analytics Reporting (CAP)
• Client Analytics Platform (CAP) is an internal reporting tool designed to collect, analyze, and present key financial data for the Business Banking division. It provides insights into asset balances, regulatory capital allocations, and business line data.
• CAP is primarily used by bankers and senior executives to evaluate client growth, monitor revenue trends, and support strategic decision-making. It also plays a critical role in financial management processes such as fund transfer pricing, cost of funds analysis, and liquidity coverage ratio (LCR) assessments. Through its robust analytics and reporting capabilities, CAP enables comprehensive business management and enhances visibility into profitability and resource allocation across client portfolios.

Typical Day in Role:

• The incumbent acts as technical business/data analyst resource in projects, providing detailed technical data analysis, testing, investigations, recommendations, program specifications and business requirements for development of technical solutions for the sourcing, delivery, and processing of required monthly/daily data sources within the distributed technical architecture to support client profitability and analytics for wholesale customers.
• Supported by knowledge of wholesale business products and detailed understanding of Bank source applications, the incumbent uses technical knowledge and business/data insights to design and build specifications for operationally stable processes that extract, transform, and map raw data to organized/structured schemas for the purpose of consistent reporting and analytics.
• The incumbent supports technical peers in the team and collaborate with business partners, data engineers and cross functional IT teams to deliver complex, creative, cost-effective, and robust operationally stable data solutions. This includes development of complex queries against big data that are required to ensure data are accessible for analytics and reporting by the data teams, as well as providing oversight of reporting solutions using Tableau, and/or other industry standard BI tools.
• The incumbent provides acceptance testing and verification to help verify complex technical/business solutions for the assigned tasks. They will share the results with users for confirmation and sign-off to proceed with implementation to release the solution in production environment. The incumbent may be required to perform operational support after hours from time-to-time to support late hours implementation and operational processes.
• The incumbent drives the implementation of new processes, improving methodologies and utilizes cutting-edge technologies to expedite delivery of new and enhanced products to our customers on a daily basis. They drive adoption of modern testing approaches and techniques to both ensure excellent quality standards while delivering with velocity.
• The incumbent is expected to function independently combining technical expertise and business knowledge to recommend, develop and implement technical solutions and identify opportunities for automation or efficiency in ETL processes.
• The incumbent may receive general direction from Director/Senior Manager/Project Managers/Business Analysts for the projects assigned.
• Collaborate with data architects, modelers, and IT team members on project goals.

Must have skills:

• 10+ years of experience working in a similar capacity as a BA/BSA

• 7 + years of Recent project experience writing intermediate to advanced queries using SQL.

• 7+ years of experience as Business Data analyst working with large sets of data including data mapping and Big Data technologies

• 3+ years' finance/accounting background

• 3 + years of experience with revenue reporting and P&L

Nice to have:

• Power BI is a strong asset.

• Fluency in Spanish is preferred

• Experience with automated testing.

• Agile/Scrum methodology understanding / worked in an Agile environment

• Previous recent experience working with Top 5 Banks/FI

Education:

• Bachelor's degree in a technical field such as Computer Science, Computer Engineering or related field required.

• Financial courses or certification completion is an asset.

• Prior courses taken in Mathematics (statistical analysis and discreet mathematics)

Best VS. Average Candidate:

The ideal candidate will be an experienced IT Business Analyst / BSA with strong Data Analysis experience. Previous experience with advanced queries using SQL is crucial for this role. Would be a natural problem-solver who is proactive in data analysis and producing solutions. Ability to work effectively with relational databases and Power BI along with financial acumen is a key to success in this role.

Candidate Review & Selection

2-3 rounds - in-person interviews. With potential live technical assessment tests.

• In-person 1st round - 30 minutes - Behavioral / get to know you panel interviews- with Hiring Manager, Application Specialist

• In-person 2nd - 1 hour : Technical panel interview - with Hiring Manager, Application Specialist, Technical Business Analyst

• Potential in-person final/ third round if needed