Opens LinkedIn
- Employment type
- Contract, Full-time
- Experience level
- Senior · 5+ years
- Posting language
- English
- Working hours
- 40 hours per week
- Office presence
- 4 days per week
- Seniority
- Mid-Senior level
- Application method
- Direct apply is available
Job summary
Gather and document business, functional, data, and technical requirements; create detailed source-to-target mappings and technical specifications; and analyze systems, integrations, data flows, and processes. Use SQL to validate and reconcile data, identify gaps and root causes, and collaborate with delivery teams on solution design, testing, defect analysis, and issue resolution.
Job details
Job Title: Business Systems Analyst Location: Downtown Toronto, ON Work Arrangement: Hybrid: 3-4days a week Employment Type: Full-time Duration: Permanent Domain: BFSI Salary: 120k to 130K Application Deadline: October 30th, 2026 SKILLS REQUIRED. We are seeking a technically strong Business Systems Analyst (BSA) with expertise in source-to-target data mapping, SQL, system integration analysis, and technical documentation. Required Skills & Experience Strong experience as a Business Systems Analyst, Technical Business Analyst, or Data Business Analyst. Hands-on experience with source-to-target data mapping and detailed technical specifications. Strong SQL skills for data profiling, validation, reconciliation, and troubleshooting. Experience analyzing application integrations, APIs, batch processing, file transfers, and end-to-end data flows. Knowledge of ETL, data migration, data quality, and process automation. Ability to independently analyze complex systems and translate business needs into development-ready requirements. Experience with Jira, Confluence, Visio, and Agile delivery methodologies Key Responsibilities Gather, analyze, validate, and document business, functional, data, and technical requirements. Develop detailed Source-to-Target Mapping (STTM) documents, including field-level mappings, transformation rules, data types, validations, dependencies, and exception handling. Analyze application architecture, databases, APIs, batch processes, file transfers, interfaces, and upstream/downstream data flows. Document current-state and future-state business processes, identify gaps, and define automation requirements to improve STP. Perform gap analysis to identify data discrepancies, integration issues, manual processes, and required system enhancements. Use SQL for data analysis, mapping validation, data reconciliation, root-cause analysis, and troubleshooting. Collaborate with architects, developers, solution designers, QA teams, vendors, and business stakeholders throughout the delivery lifecycle. Support solution design, effort estimation, System Integration Testing (SIT), User Acceptance Testing (UAT), defect analysis, and issue resolution. Prepare clear, accurate, and complete technical specifications with minimal supervision. Assess integration dependencies and impacts across legacy and modern applications. EEOC Compliance: We are an equal opportunity employer, and all qualified applicants will receive consideration for employment. DISCLAIMER AI Usage Policy: Pacer Group uses AI to assist in screening applications. Final hiring decisions are made by human recruiters based on qualifications and experience.
What you’ll do
Gather and document business, functional, data, and technical requirements; create detailed source-to-target mappings and technical specifications; and analyze systems, integrations, data flows, and processes. Use SQL to validate and reconcile data, identify gaps and root causes, and collaborate with delivery teams on solution design, testing, defect analysis, and issue resolution.
Requirements
Requires substantial experience as a Business Systems Analyst or in a related technical or data analysis role, with hands-on source-to-target mapping, detailed technical specifications, and strong SQL skills. Candidates should also have experience with integrations and end-to-end data flows, ETL or data migration, Agile delivery, and tools such as Jira, Confluence, and Visio.
Listed skills
- Technical Documentation · Preferred
- SQL · Preferred
- Data Validation · Preferred
- Jira · Preferred
- Agile · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Source-To-Target Data Mapping
- SQL
- System Integration Analysis
- Technical Documentation
- Data Profiling
- Data Validation
- Data Reconciliation
- API Analysis
- ETL
- Data Migration
- Data Quality
- Process Automation
- Jira
- Confluence
- Visio
- Agile
Job areas
- Technology
- Data & Analytics
- Software
- Finance & Accounting
- Consulting
More jobs from Pacer Group
Platform Engineer
- Hybrid
- Toronto, ON
- Posted Oct 14, 2026
Java Full Stack Developer
- On-site
- Montréal, QC
- Posted Oct 14, 2026
Azure Data Engineer
- Hybrid
- Toronto, ON
- Posted Oct 13, 2026
SAP FICO Consultant
- Hybrid
- AB
- Posted Oct 13, 2026
