Associate Business Systems Analyst

Co-operators; Guelph, Regina, Calgary; Hybrid; CAD 50,000 - 84,000; Full time

Job summary

CGL in Ontario is hiring an Associate Business Systems Analyst to analyze business needs, document requirements and define system specifications. You will support the delivery of technology solutions aligned with business goals while developing expertise in business applications.

Ideal candidates have 1–3 years in IT, a post-secondary IT diploma, strong curiosity, attention to detail and the ability to learn quickly. Hybrid work with 2 days in office supports collaboration and balance.

Qualifications

• 1–3 years of IT or related experience.
• Post-secondary IT diploma completed.
• Ability to learn new applications quickly.
• Strong attention to detail and data quality.
• Knowledge of SQL, Excel, and large data analysis.

Responsibilities

• Analyze business needs, document requirements and system specs.
• Create data flow diagrams to support analysis.
• Execute test scripts, validate results and assist with data reconciliation.
• Troubleshoot data, application, interface, and automation issues.
• Collaborate with seniors to estimate tasks and refine plans.

Skills

SQL

Relational databases

Microsoft Excel

Data analysis

Python

Power BI

APIs/JSON

Postman

Git

Jira

Azure DevOps

Agile practices

Education

Post-secondary diploma in Information Technology or related discipline

Tools

SQL

Power BI

Git

Jira

Azure DevOps

Postman

Python

PowerShell

Job description

Company: CGL
Department: Financial Acctg Services
Employment Type: Regular Full-Time
Work Model: Hybrid (2 days in office)
Language: This role operates in English.
Additional Information: This/these role(s) is/are currently vacant

The Opportunity:

We are a leading Canadian financial services co-operative committed to being a catalyst for a sustainable and resilient society and our team is essential to deliver on this strategy. That’s why we prioritize our people, to ensure we provide a strong culture and development opportunities which enables our team to thrive and to live our purpose. The best part is that you will work with people that care passionately about you, our clients and our communities.

As the Associate Business Systems Analyst, you will analyze business and user needs, document requirements, define system specifications, and support the delivery of technology solutions that align with business objectives while developing expertise in business applications and their impact on the organization.

How you will create impact:

• Contributing to estimating assigned tasks based on prior experience and collaborating with senior team members to validate assumptions and refine estimates.
• Assisting in conducting detailed analyses of business functions, processes, and operational challenges.
• Developing an understanding of application data and creating data flow diagrams to support system analysis and documentation.
• Executing test scripts, validating actual results against expected outcomes, documenting defects, and supporting data reconciliation and calculation testing in collaboration with senior resources as needed.
• Troubleshooting application, data, interface, and automation issues, while escalating complex problems to senior team members when appropriate.

How you will succeed:

• You influence change and are committed to continuous improvement, in order to exceed client expectations.
• You leverage critical thinking skills to identify problems and proactively propose solutions.
• Your strong communication skills allow you to clearly convey messages.
• You’re an effective team player who shares knowledge to support our peers.

To join our team:

• You have 1-3 years of experience in Information Technology or a related field.
• You have a post‑secondary diploma in Information Technology or a related discipline.
• You have strong curiosity and a demonstrated ability to quickly learn new applications and technologies.
• You have strong attention to detail, a commitment to maintaining data quality, and the ability to identify, investigate, and resolve data and system issues
• You have working knowledge of SQL, relational databases, Microsoft Excel, and the analysis of large datasets.
• Having exposure to RPA or automation technologies, Informatica or other ETL/data integration tools, APIs, JSON, Postman, Power BI, or scripting languages such as Python or PowerShell is an asset.
• Having familiarity with Git/GitHub, Jira, Azure DevOps, Agile development practices, financial systems, financial data, or accounting concepts is an asset.

What you need to know:

• You will be subject to a Background check as a condition of employment, in the event you are the successful candidate.

What’s in it for you?

• Training and development opportunities to grow your career.
• Flexible work options and paid time off to support your personal and family needs.
• A holistic approach to your well‑being, with physical and mental health programs and a supportive workplace culture.
• Paid volunteer days to give back to your community.
• In addition to our competitive salary and incentive programs, eligible employees also benefit from a comprehensive total rewards package including group retirement savings plans, pension and benefits (e.g., health and wellness, dental, disability and life coverage), mental health support and an employee assistance program.

Salary information

Expected salary range $50,280 to $83,800

The salary amount for the successful candidate is determined by Co-operators in its discretion and will vary depending on several criteria including but not limited to: local market conditions, geography and relevant job‑related factors such as knowledge, skills, qualification, experience and education.

Employees may also have the opportunity to participate in incentive programs and earn additional compensation tied to individual and/or business performance, or other business metrics.