Business Systems Analyst (BSA)

Aarorn Technologies Inc; Toronto; Hybrid; CAD 68,880; Full time

Job summary

A leading tech consulting firm in Toronto is seeking a skilled Business Systems Analyst (BSA) with expertise in data engineering and banking/wealth management. The role involves collaborating with stakeholders to gather requirements, supporting data ingestion processes, and developing data views using SQL. The ideal candidate has strong analytical skills, Agile experience, and familiarity with Python. This contract position offers a pay rate of $50 per hour and requires on-site presence three times a week.

Qualifications

• Strong understanding of banking or wealth management processes.
• Proficiency in SQL, including querying and optimization.
• Hands-on experience in Agile delivery environments.

Responsibilities

• Partner with stakeholders to understand data requirements.
• Support design and validation of data ingestion processes.
• Develop and maintain domain-based data views using SQL.
• Refine user stories and define acceptance criteria.

Skills

Data analysis

SQL proficiency

Banking processes knowledge

Agile experience

Basic Python knowledge

Job description

Job Title: Business Systems Analyst (BSA) – Data Engineering
Location: Toronto, ON (3x onsite a week)
Employment Type: Contract
Pay Rate: $50/HR INC

Job Description

We are seeking an experienced Business Systems Analyst (BSA) with strong exposure to data engineering, data analysis, and banking/wealth management domains. The candidate will work closely with business stakeholders, data engineers, and technology teams to define requirements, support data ingestion initiatives, build domain‑specific data views, and ensure high‑quality delivery.

Key Responsibilities

Business & Domain Collaboration

• Partner with banking and wealth management stakeholders to understand data requirements and regulatory nuances.
• Translate business needs into functional and technical specifications.

Data Ingestion & Analysis

Support design and validation of data ingestion processes.

Ensure pipelines align with business use cases and compliance standards.

View Creation & SQL Development

• Develop and maintain domain‑based data views (portfolios, transactions, accounts) using SQL.
• Optimize and validate views for reporting and analytics.

Story Grooming & Requirements Management

• Refine user stories and define clear acceptance criteria.
• Support sprint planning and backlog refinement in Agile environment.

Developer & Technical Support

• Act as liaison between business and engineering teams.
• Support troubleshooting and requirement clarifications.

Data Analysis & Documentation

• Perform exploratory data analysis (EDA).
• Maintain documentation including workflows, business rules, and data mappings.

Qualifications & Skills

Domain Knowledge

• Strong understanding of banking or wealth management processes such as asset management, onboarding, compliance, portfolio and transaction reporting.

Technical Skills

• Proficiency in SQL (joins, querying, optimization).
• Basic knowledge of Python.
• Familiarity with ETL pipelines and APIs.

Agile Experience

• Hands‑on experience in Agile delivery environments.

Disclaimer: AI tools may assist in the recruitment process; however, all hiring decisions are made by the recruitment team based on a comprehensive evaluation of candidates.