Business system analyst

Business System Analyst

Job Type: Full Time



Location: Toronto, ON



Work Model: Hybrid 4 Days Onsite Primary Skills

Business Analysis, Azure Data Factory & Databricks, SQL/PySpark

Job Description

We are seeking an experienced Business System Analyst with 3 6 years of experience supporting data-driven transformation initiatives . The ideal candidate will combine strong Business Analysis and requirements management capabilities with hands-on knowledge of Azure Data Factory (ADF), Azure Databricks (ADB), PySpark, and SQL .

The successful candidate will act as a bridge between business stakeholders, data engineering teams, architecture, and technology partners to gather requirements, perform data analysis, support data integration initiatives, and drive the successful delivery of enterprise data solutions.

Experience within the Banking and Financial Services domain is highly preferred.

Key Responsibilities Business Analysis & Requirements Management

• Gather, analyze, document, and manage business and functional requirements.
• Conduct stakeholder workshops, requirement elicitation sessions, and impact assessments.
• Prepare BRDs, FRDs, User Stories, Process Flows, Use Cases, and Acceptance Criteria .
• Translate business requirements into detailed technical specifications for development and data engineering teams.
• Facilitate Agile ceremonies including backlog grooming, sprint planning, and requirements discussions.
• Support User Acceptance Testing (UAT) and coordinate business validation activities.

Data Analysis & Mapping

• Perform Source-to-Target Mapping (STTM) and data lineage analysis.
• Conduct data profiling, reconciliation, validation, and data quality assessments using SQL.
• Analyze data transformation requirements and identify gaps between source and target systems.
• Define and document business rules, transformation logic, and validation requirements.
• Support regulatory, compliance, and operational data initiatives.
• Collaborate with data engineering teams to ensure accurate implementation of business requirements.

Azure Data Platform Support

• Collaborate with Data Engineers working on Azure Data Factory (ADF) pipelines.
• Support analysis and validation of Azure Databricks (ADB) workflows and PySpark transformations.
• Review data ingestion, transformation, orchestration, and integration requirements.
• Assist in defining business rules and validation logic for ETL/ELT processes .
• Participate in testing and validation of ADF and ADB solutions.
• Analyze data processing issues and support troubleshooting and root-cause analysis.

Stakeholder & Project Coordination

• Act as a liaison between Business, Technology, Architecture, Data Governance, and Operations teams.
• Communicate project status, risks, dependencies, issues, and remediation plans.
• Coordinate requirements and deliverables across multiple technical and business teams.
• Support production issue investigations and root-cause analysis.
• Ensure solutions align with enterprise data governance, security, and compliance standards.
• Maintain clear and accurate project and technical documentation.

Required Skills & Experience

• 3 6 years of Business Systems Analysis / Business Analysis experience .
• Strong experience in requirements gathering, documentation, stakeholder management, and data analysis.
• 3+ years of knowledge/experience with Azure Data Factory (ADF) .
• 3+ years of knowledge/experience with Azure Databricks (ADB) .
• Strong SQL querying, data analysis, and data validation skills.
• Understanding of PySpark-based data transformation processes .
• Experience with Data Mapping, Data Lineage, and Data Quality analysis.
• Experience working with source-to-target mapping and ETL/ELT processes.
• Strong understanding of Agile/Scrum delivery methodologies.

Technical Skills

• Azure Data Factory (ADF)
• Azure Databricks (ADB)
• PySpark
• SQL
• Azure Data Lake
• Azure SQL
• Cloud-based data platforms
• Data Mapping & Source-to-Target Mapping
• Data Lineage
• Data Quality & Validation
• ETL/ELT concepts
• JIRA, Confluence, Azure DevOps, or similar tools

Preferred Qualifications

• Experience in the Banking or Financial Services domain.
• Understanding of regulatory, compliance, and data-governance requirements.
• Experience supporting enterprise data transformation or modernization initiatives.
• Familiarity with Azure-based data architecture and cloud data platforms.
• Experience working with cross-functional Agile teams.

Key Competencies

• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management abilities.
• Ability to translate complex business requirements into clear technical requirements.
• Strong attention to detail and data quality focus.
• Ability to work effectively with both business and technical teams.
• Strong documentation and presentation skills.