Business Systems Analyst

Adastra Group; Toronto; Hybrid; CAD 85,000 - 95,000; Full time

Benefits offered by this job

Career progression

Competitive compensation

Benefits plan

Referral program

Best Managed Companies award

Flexible environment

Diverse workplace

Job summary

Adastra seeks a highly analytical Business Systems Analyst to bridge business needs and technology solutions in a hybrid Toronto role. You will gather requirements, analyze data, and support system enhancements to drive operational efficiency.

You will use SQL and Python for data insights, collaborate with stakeholders and development teams, and help deliver scalable, value-driven solutions across departments.

Qualifications

• Bachelor's degree in Business, Information Systems, Computer Science, or related field.
• 2–4+ years as a Business/Systems Analyst.
• Strong SQL proficiency (complex queries, joins, performance).
• Python for data analysis and scripting (Pandas, NumPy).
• Experience gathering and documenting requirements (BRDs, FRDs, user stories).
• Familiarity with data visualization/BI tools (Tableau, Power BI).
• Understanding of relational databases (SQL Server, Oracle, PostgreSQL, MySQL).
• Excellent communication and stakeholder management skills.
• Experience working in Agile/Scrum environments.

Responsibilities

• Gather, document, and analyze business requirements from stakeholders.
• Translate needs into functional specs and user stories for development.
• Write and optimize SQL queries to extract and validate data.
• Use Python for data analysis, automation, and scripting.
• Perform data validation and quality checks.
• Create process diagrams, workflows, and system docs.
• Support UAT — write test cases, execute tests, log defects.
• Collaborate with developers, QA, and product owners.
• Identify opportunities for process improvement.
• Build reports and dashboards for decision-making.
• Act as liaison between business and IT teams.

Skills

SQL proficiency

Python for data analysis

Requirements gathering

Agile/Scrum

Communication

Stakeholder management

Data visualization

Education

Bachelor's degree in Business, Information Systems, Computer Science, or related field

Tools

Tableau

Power BI

SQL Server

Oracle

PostgreSQL

MySQL

Pandas

NumPy

Job description

Overview

Adastra is seeking a highly analytical Business Systems Analyst to bridge the gap between business needs and technology solutions. This role is responsible for gathering and translating requirements, analyzing data, and supporting the delivery of system enhancements and business initiatives.

The successful candidate will leverage SQL, Python, and data analysis skills to identify insights, improve processes, validate data quality, and support informed decision-making. Working closely with business stakeholders, developers, QA teams, and product owners, this individual will play a key role in delivering scalable solutions that drive operational efficiency and business value.

Primary Location: Toronto, ON

Work Model: Hybrid 3-Days Onsite

Employment Type: Permanent Full-Time

Vacancy Status: New

Compensation Range: $85,000 - $95,000 CAD

RESPONSIBILITIES

• Gather, document, and analyze business requirements from stakeholders across departments
• Translate business needs into functional specifications and user stories for development teams
• Write and optimize SQL queries to extract, analyze, and validate data across systems
• Use Python for data analysis, automation, and building scripts/tools to support business processes
• Perform data validation, reconciliation, and quality checks
• Create process flow diagrams, workflows, and system documentation
• Support UAT (User Acceptance Testing) — write test cases, execute tests, and log defects
• Collaborate with developers, QA, and product owners throughout the SDLC
• Identify opportunities for process improvement and system enhancements
• Build reports and dashboards to support business decision-making
• Act as liaison between business units and IT/development teams

QUALIFICATIONS, SKILLS & EXPERIENCE

• Bachelor's degree in Business, Information Systems, Computer Science, or related field
• 2–4+ years of experience as a Business/Systems Analyst
• Strong proficiency in SQL (complex queries, joins, stored procedures, performance tuning)
• Working knowledge of Python for data analysis and scripting (Pandas, NumPy, etc.)
• Experience with requirements gathering and documentation (BRDs, FRDs, user stories)
• Familiarity with data visualization/BI tools (Tableau, Power BI, or similar)
• Understanding of relational databases (SQL Server, Oracle, PostgreSQL, MySQL)
• Excellent communication and stakeholder management skills
• Experience working in Agile/Scrum environments

ABOUT ADASTRA

Adastra is a global leader in AI and data-driven transformation, helping organizations lead with artificial intelligence—responsibly, strategically, and at scale. With over 25 years of experience, Adastra empowers enterprise clients to unlock business value through data innovation, operational excellence, and smart customer engagement.

Trusted by some of the world’s most prominent brands, Adastra delivers end-to-end solutions grounded in thoughtful strategy, robust governance, and deep technical expertise. From defining vision to ensuring execution, Adastra guides organizations through every stage of their AI, data and cloud journey—building future-ready capabilities and delivering measurable, lasting impact.

Adastra serves clients across key industries including financial services, automotive, manufacturing, technology, media and telecom (TMT), healthcare, retail, and professional services. The company employs more than 2,000 professionals across North America, Europe, and Asia.

WHAT WE OFFER

• Opportunity for advancement and career progression
• Competitive compensation package
• Comprehensive benefits plan
• Successful referral program
• The opportunity to work with one of Canada’s 50 Best Managed Companies
• Satisfaction of working for a reputable company
• A flexible, dynamic, and diverse workplace

EQUAL OPPORTUNITY EMPLOYER

In our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status, or any other ground as described in the Ontario Human Rights Code.In addition, accommodation will be provided during the hiring process. Adastra Corporation’s implementation and support of employment initiatives, encourage diversified labour force participation and equal access to opportunities based on merit and performance.