Business Systems Analyst (BSA)

Korn Ferry; Toronto; On-site; CAD 100,000 - 125,000; Full time

Job summary

A leading consultancy firm is seeking a Business Systems Analyst (BSA) to support the development of a cutting-edge risk and analytics platform. This hybrid role involves leading the gathering and documentation of business requirements, optimizing data solutions using Spark SQL, and collaborating with Agile teams. Ideal candidates will have over 5 years of experience in financial services and strong SQL skills.

Qualifications

• 5+ years of experience as a Business Systems Analyst in data-driven financial services.
• Hands-on experience with Spark SQL and Hadoop/Spark ecosystems.
• Exposure to SSIS and capital markets or treasury risk domains preferred.

Responsibilities

• Lead elicitation, analysis, and documentation of business requirements.
• Write, test, and optimize Spark SQL for data transformation.
• Collaborate with engineering and QA teams in Agile ceremonies.

Skills

Advanced SQL expertise

Spark SQL experience

Problem-solving abilities

Communication skills

Relationship-building

Education

Bachelor's degree in Computer Science or related discipline

Tools

Oracle

SQL Server

Azure cloud platforms

Job description

Job Description

Title : Business Systems Analyst (BSA)

Location : Hybrid in Toronto

Client Industry : Financial Services - Banking

Compensation : $60-70 / hr CAD (contract / contract-to-hire)

We have partnered with our client in their search for a Business Systems Analyst (BSA). This role will support the build-out of a next-generation risk, valuations, and analytics platform by translating complex treasury and capital markets business needs into performant cloud-based data solutions.

Responsibilities

• Lead end-to-end elicitation, analysis, and documentation of business requirements for data-intensive projects
• Write, test, and optimize Spark SQL to transform large data sets and embed business rules in the Azure cloud solution
• Collaborate with engineering, UI, and QA teams in Agile ceremonies to ensure on-time delivery and quality outcomes
• Identify and automate process improvement opportunities to enhance data accuracy, performance, and maintainability
• Analyze SSIS packages, onboard new data feeds, build extraction pipelines, and integrate third-party data sources
• Guide and review the work of junior BSAs; manage business-as-usual (BAU) production processes

Skills Required

• Advanced SQL and relational database expertise (Oracle, SQL Server) with proven performance tuning skills
• Hands-on experience writing Spark SQL within Hadoop / Spark ecosystems (Big Data / NoSQL)
• 5+ years delivering large-scale data or analytics projects while juggling day-to-day stakeholder requests
• Strong problem-solving, communication, and relationship-building abilities; comfortable in distributed Agile teams
• Ability to analyze and synthesize complex business processes and translate them into technical solutions

Education & Work Experience

• Bachelor's degree in Computer Science, Information Systems, Finance, or related discipline
• Minimum 5 years' experience as a Business Systems Analyst or similar in data-driven financial services environments
• Exposure to Azure cloud platforms, SSIS, and capital markets or treasury risk domains preferred

About Korn Ferry

Korn Ferry unleashes potential in people, teams, and organizations. We work with our clients to design optimal organization structures, roles, and responsibilities. We help them hire the right people and advise them on how to reward and motivate their workforce while developing professionals as they navigate and advance their careers. To learn more, please visit Korn Ferry at