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
Added
RQ00812 – Business Intelligence Specialist – Oracle – Senior
S M Software Solutions Inc · Toronto, ON, Canada
Added
RQ00812 – Business Intelligence Specialist – Oracle – Senior
S M Software Solutions Inc · Toronto, ON, Canada
Added
RQ00812 – Business Intelligence Specialist – Oracle – Senior
S M Software Solutions Inc · Toronto, ON, Canada
Added
RQ00812 – Business Intelligence Specialist – Oracle – Senior
S M Software Solutions Inc · Toronto, ON, Canada
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.
“Tekshapers is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.”
*Disclaimer: This E-Mail may contain Confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, kindly notify us at itsupport@tekshapers.com and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution, and/or publication of this e-mail, its contents, or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful.
Internet communication cannot be guaranteed to be secured or error-free as information could be delayed, intercepted, corrupted, lost, or contain viruses. Tekshapers. does not accept any liability for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this e-mail.
More about this job
Responsibilities
Gather and document business and functional requirements, translate them into technical specifications, and support Agile delivery, testing, and user acceptance. Analyze and validate data, support Azure-based data integration initiatives, coordinate across business and technology teams, and help resolve production issues while maintaining governance and compliance.
Requirements
The role seeks a Business Systems Analyst with 3–6 years of experience in data-driven transformation, including at least 3 years of knowledge of Azure Data Factory and Azure Databricks, plus familiarity with PySpark and strong SQL skills. Banking or financial services experience is highly preferred, along with experience in data mapping, lineage, quality analysis, cloud data platforms, and tools such as JIRA, Confluence, or Azure DevOps.
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
- Consulting
- Finance & Accounting
Keywords
- Business Systems Analyst
- Business Analysis
- Requirements Elicitation
- User Stories
- Use Cases
- Acceptance Criteria
- Agile
- 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
- Banking
- Financial Services
- Data Governance
- Regulatory Compliance
- Root-Cause Analysis