Business System Analyst

Job summary

Analyze business requirements, systems, data flows, and integrations; create detailed source-to-target mappings and development-ready technical specifications. Identify process gaps and automation opportunities, use SQL for data validation and reconciliation, and support solution design, development, testing, and issue resolution.

Job details

Business System Analyst Full time Toronto- Hybrid We are looking for a technically strong BSA who can independently analyze source and target systems, define detailed data mappings, document business and technical requirements, identify automation opportunities, and support solution design, development, integration, and testing. Key Responsibilities Requirements Analysis: Gather, analyze, validate, and document business, functional, data, and technical requirements. Source-to-Target Mapping: Develop detailed field-level mappings covering data types, transformation and derivation rules, validations, dependencies, and exception handling. System & Integration Analysis: Analyze application architecture, databases, APIs, batch processing, file transfers, interfaces, and end-to-end upstream/downstream data flows. Business Process Analysis & Automation: Document current-state and future-state processes, identify manual touchpoints and process gaps, and define automation requirements to enable end-to-end Straight-Through Processing (STP). Gap Analysis: Identify functional gaps, data discrepancies, integration gaps, manual processes, and required system enhancements. SQL & Data Analysis: Use SQL to analyze source and target data, validate mappings and business rules, perform data reconciliation, and support root-cause analysis and troubleshooting. Development & Testing Support: Collaborate with solution designers, developers, and QA teams on solution design, estimation, SIT/UAT, defect analysis, reconciliation, and issue resolution. Stakeholder Collaboration: Work closely with business partners, architects, vendors, and upstream/downstream application teams to clarify requirements, dependencies, and integration impacts. Independent Delivery: Produce clear, accurate, complete, and development-ready specifications with minimal supervision. Technical Documentation The BSA should be able to create and maintain: Source-to-Target Mapping (STTM) Interface Specification Documents (ISD) Functional Requirements Documents (FRD) Business Rules and Gap Analysis Data, System, and Process Flow Diagrams Test Scenarios and Acceptance Criteria Preferred Qualifications Experience in banking, wealth management, or financial services. Strong technical analysis and data-mapping experience. Working knowledge of mainframe systems, DB2, and legacy application integrations. Familiarity with ETL, data migration, APIs, batch processing, reconciliation, and process automation. Experience working across modern and legacy technologies and complex upstream/downstream integrations. Experience with Jira, Confluence, Visio, Agile delivery methodologies, and AI-assisted analysis/documentation tools. Key Expectation The successful candidate must be able to independently understand existing applications, data flows, integrations, and business processes; identify gaps and automation opportunities; and translate business needs into clear, complete, development-ready technical specifications.

What you’ll do

Analyze business requirements, systems, data flows, and integrations; create detailed source-to-target mappings and development-ready technical specifications. Identify process gaps and automation opportunities, use SQL for data validation and reconciliation, and support solution design, development, testing, and issue resolution.

Requirements

The role calls for strong technical analysis and data-mapping experience, with the ability to independently understand complex applications, integrations, and business processes. Familiarity with banking or financial services, mainframe systems, DB2, ETL, APIs, batch processing, Jira, Confluence, Visio, and Agile delivery is preferred.

Listed skills

• SQL · Preferred
• Technical Documentation · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Requirements Analysis
• Source-to-Target Data Mapping
• System Integration Analysis
• Business Process Analysis
• Process Automation
• Gap Analysis
• SQL
• Data Reconciliation
• Technical Documentation
• Solution Design
• System Integration Testing
• User Acceptance Testing
• Stakeholder Collaboration
• Mainframe Systems
• DB2
• Agile Delivery

Job areas

• Technology
• Data & Analytics
• Software
• Finance & Accounting
• Consulting

More jobs from Epsilon Solutions Ltd.