Associate Business Systems Analyst

The Co-operators Group; Guelph; Hybrid; CAD 50,000 - 84,000; Full time

Benefits offered by this job

Flexible work options

Paid time off

Well-being programs

Volunteer days

Total rewards package

Job summary

CGL, located in Ontario, invites applications for the Associate Business Systems Analyst. This regular full-time role is hybrid (2 days in office) and English-speaking. You will analyze business needs, document requirements, and support technology solutions aligned with business goals.

The position emphasizes data quality, tooling knowledge, and collaboration across IT and finance stakeholders, with opportunities for growth and comprehensive rewards.

Qualifications

• 1–3 years of experience in Information Technology or a related field.
• Post-secondary diploma in Information Technology or related discipline.
• Strong curiosity and ability to quickly learn new applications and technologies.
• Strong attention to detail and commitment to maintaining data quality.
• Working knowledge of SQL, relational databases, Excel, and data analysis of large datasets.
• Exposure to RPA or automation tech, ETL/data integration tools, APIs, JSON, Power BI, or scripting languages is an asset.
• Familiarity with Git/GitHub, Jira, Azure DevOps, Agile practices, financial systems, or accounting concepts is an asset.

Responsibilities

• Analyze business and user needs and document requirements.
• Define system specifications and support delivery of technology solutions.
• Develop data flow diagrams to support analysis and documentation.
• Execute test scripts and document defects; support data reconciliation and testing.
• Troubleshoot application, data, interface, and automation issues and escalate as needed.

Skills

Analytical thinking

Strong communication

Team player

Attention to detail

Curiosity / quick learner

Education

Post-secondary IT diploma

Tools

SQL

Relational databases

Microsoft Excel

Power BI

JSON

Postman

Python

PowerShell

Git/GitHub

Jira

Azure DevOps

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.