Business System Analyst

Swoon; Toronto; On-site; CAD 96,000 - 124,000; Full time

Job summary

Swoon is seeking a Business Systems Analyst to support Intraday Liquidity initiatives across depositories, securities settlement, and payment processing. You will elicit requirements, map data, and document detailed specifications for real-time and end-of-day cash flows.

The role requires strong SQL, data analysis, and ability to coordinate with business and technology teams, including QA and testing. A fast-paced, regulated environment experience is preferred.

Qualifications

• Experience as a Business Systems Analyst in capital markets or similar regulated setting.
• Proven ability to elicit requirements from multiple business and tech teams.
• Strong data analysis, data mapping, and data validation background.
• Experience with SIT/UAT and testing processes; able to communicate findings clearly.

Responsibilities

• Elicit, analyze, and document business, data, and technical requirements across teams.
• Support depositories, securities settlement, and end-to-end post-trade processes.
• Analyze real-time and end-of-day payment processes and flows.
• Create data mappings and identify data quality issues and gaps.
• Translate requirements into functional/technical specs and user stories.
• Collaborate with developers to clarify requirements and validate data definitions.
• Act as liaison between business, tech, QA, and testing teams.
• Develop test scenarios and participate in SIT and UAT planning.

Skills

Depositories

Securities settlement

Payments real‑time & EOD

Data mapping

SQL data mining

Data profiling

QA collaboration

Requirements elicitation

Data analysis

Troubleshooting technical issues

Tools

SQL

Job description

Compensation: T4: $70-$78 | IC: $85-$90- per hour

Project: All the banks are going through an Intraday Liquidity Mandate. An "Intraday Liquidity program" refers to the systems and processes that financial institutions use to manage their cash flow during the business day, ensuring they can meet payment obligations in real-time. Effective programs use monitoring tools, central bank services, and technology to manage liquidity sources and uses, such as reserve balances and payment flows, to avoid intraday liquidity risk and maintain market stability.

Top Skills:

• Depositories
• Securities settlement
• Payments (real-time and EOD)
• Strong Data Background, Data Mapping
• Strong in data mining and SQL, they need to data profiling
• Excellent Communication!! Need to be proactive and team player, talk to the developers, data definitions, potential to do QA work.
• Being able to elicit requirements from various business & tech teams, data analysis and tech specs documentation.
• Strong Data experience, talking to the SME’s, SQL experience, very technical
• SIT testing and facilitate/support UAT.

Key Responsibilities

• Elicit, analyze, and document business, functional, data, and technical requirements from stakeholders across business and technology teams.
• Support initiatives involving depositories, securities settlement, and the end-to-end post-trade lifecycle.
• Analyze payment processes, including real-time and end-of-day payment flows.
• Work closely with subject-matter experts to understand business processes, systems, data definitions, and integration requirements.
• Perform data mining, data profiling, and detailed data analysis using SQL.
• Create source-to-target data mappings and identify data quality issues, gaps, and inconsistencies.
• Translate complex business and data requirements into detailed functional specifications, technical specifications, process flows, and user stories.
• Collaborate with developers to clarify requirements, validate data definitions, and support solution design and implementation.
• Act as a liaison between business stakeholders, technology teams, developers, and testing teams.
• Develop test scenarios and test cases based on documented business and system requirements.
• Participate in System Integration Testing (SIT) and investigate data or system-related defects.
• Facilitate and support User Acceptance Testing (UAT), including test planning, defect triage, and stakeholder coordination.
• Contribute to QA activities as required to ensure solutions meet business, technical, and data requirements.
• Proactively identify risks, dependencies, data issues, and requirement gaps throughout the project lifecycle.

Required Qualifications

• Strong experience as a Business Systems Analyst within capital markets, financial services, or a similarly complex and regulated environment.
• Demonstrated knowledge of depositories and securities settlement processes.
• Strong understanding of the end-to-end trading and post-trade lifecycle.
• Experience working with payment processing, including real-time and end-of-day payments.
• Advanced SQL skills with hands-on experience in data mining, data profiling, and data validation.
• Strong background in data analysis, data mapping, and data definition documentation.
• Ability to analyze large and complex datasets and communicate findings clearly.
• Experience eliciting requirements from multiple business and technology stakeholders.
• Ability to produce clear, detailed business requirements, functional specifications, technical specifications, process documentation, and data mappings.
• Experience supporting SIT and facilitating UAT.
• Strong understanding of the software development lifecycle and testing processes.
• Excellent written and verbal communication skills.
• Proactive, collaborative, and comfortable taking ownership of deliverables.
• Strong team player who can build effective relationships with business stakeholders, subject-matter experts, developers, and QA teams.
• Highly technical and comfortable participating in detailed conversations about systems, data structures, and data definitions.
• Able to translate complex business and technical concepts for different audiences.
• Strong analytical, investigative, and problem-solving skills.
• Exceptional attention to detail and commitment to data accuracy.
• Comfortable working in a fast-paced environment with multiple stakeholders and competing priorities.