Back to results

Closed listing

Business system analyst

  • Toronto, ON, Canada

Full-time

This opening has closed.

The original listing is kept below for reference.

Job details

Job type
Full-time
Closing date
Experience
Business Systems Analyst (BSA) with 3-6 years of experience in data-driven transformation initiatives.
Posting language
English
Posted

Similar jobs hiring now

Search current openings

Original job description

Archived listing. The details below describe a past opening.

Job Description

Business Systems Analyst (BSA) with 3-6 years of experience in data-driven transformation initiatives. The ideal candidate will possess strong Business Analysis capabilities combined with hands-on knowledge of 3+ years in Azure Data Factory (ADF), Azure Databricks (ADB), PySpark, and SQL. Banking and financial services experience is highly preferred.

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

________________________________________

Key Responsibilities

Business Analysis & Requirements Management

  • Gather, analyze, and document 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 teams.
  • Facilitate Agile ceremonies including backlog grooming, sprint planning, and UAT support.

Data Analysis & Mapping

  • Perform source-to-target mapping (STTM) and data lineage analysis.
  • Conduct data profiling, reconciliation, validation, and quality assessments using SQL.
  • Analyze data transformation requirements and identify gaps across source and target systems.
  • Support regulatory, compliance, and operational data initiatives.

Azure Data Platform Support

  • Collaborate with Data Engineers working on Azure Data Factory pipelines.
  • Support analysis of Azure Databricks workflows and PySpark transformations.
  • Review data ingestion, transformation, and orchestration requirements.
  • Assist in defining business rules and validation logic for ETL/ELT processes.
  • Participate in testing and validation of ADF/ADB solutions.

Stakeholder & Project Coordination

  • Liaise with Business, Technology, Architecture, Data Governance, and Operations teams.
  • Communicate project status, risks, dependencies, and remediation plans.
  • Support production issue investigations and root-cause analysis.
  • Ensure alignment with enterprise data governance and compliance standards.

Technical Skills

  • Strong SQL querying, data analysis, and data validation skills.
  • 3+ years of knowledge of Azure Data Factory (ADF) and Azure Databricks (ADB).
  • Understanding of PySpark-based data transformation processes.
  • Experience with Data Mapping, Data Lineage, and Data Quality analysis.
  • Familiarity with Azure Data Lake, Azure SQL, and cloud-based data platforms.
  • Experience using JIRA, Confluence, Azure DevOps, or similar tools.
More about this job

Responsibilities

Gather and document business requirements, translate them into technical specifications, and coordinate Agile delivery and user acceptance testing. Analyze and validate data, support Azure-based data integration solutions, and coordinate with business, engineering, governance, and operations teams.

Requirements

Requires 3–6 years of experience in business systems analysis and data-driven transformation initiatives, including 3+ years of knowledge of Azure Data Factory and Azure Databricks, plus PySpark and SQL. Banking and financial services experience is highly preferred, along with data mapping, lineage, quality analysis, and familiarity with Azure data platforms and project collaboration tools.

Skills

  • Business Analysis
  • Requirements Management
  • SQL
  • Azure Data Factory
  • Azure Databricks
  • PySpark
  • Data Mapping
  • Data Lineage
  • Data Quality Analysis
  • Data Profiling
  • Data Validation
  • ETL/ELT
  • Agile
  • Stakeholder Management
  • Azure Data Lake
  • Azure DevOps

Visa sponsorship

Not detected in the job text

Categories

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

Keywords

  • Business Systems Analyst
  • Business Analysis
  • Requirements Elicitation
  • User Stories
  • Acceptance Criteria
  • Agile
  • Backlog Grooming
  • Sprint Planning
  • User Acceptance Testing
  • SQL
  • Azure Data Factory
  • Azure Databricks
  • PySpark
  • Source-To-Target Mapping
  • Data Lineage
  • Data Profiling
  • Data Reconciliation
  • Data Quality
  • ETL/ELT
  • Azure Data Lake
  • Azure SQL
  • JIRA
  • Confluence
  • Azure DevOps
  • Data Governance
  • Banking
  • Financial Services
  • Root-Cause Analysis

Report this job