Business Systems Analyst
- Toronto, ON, Canada
$120,000 to $130,000 CAD / year · Contract
Applications open in a new tab.
Job details
- Pay
- $120,000 to $130,000 CAD / year
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
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.
More about this job
Responsibilities
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.
Skills
- 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
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
- Finance & Accounting
- Consulting
Keywords
- Business Systems Analysis
- Technical Business Analysis
- Data Business Analysis
- Source-To-Target Mapping
- SQL
- Technical Specifications
- Data Profiling
- Data Validation
- Data Reconciliation
- System Integration
- APIs
- Batch Processing
- File Transfers
- Data Flows
- ETL
- Data Migration
- Data Quality
- Process Automation
- STP
- Gap Analysis
- Jira
- Confluence
- Visio
- Agile
- System Integration Testing
- User Acceptance Testing
- Root-Cause Analysis
- BFSI