Business Systems Consultant

Sun Life; Waterloo; On-site; CAD 54,000 - 91,000; Full time

Job summary

Sun Life Financial seeks a Business Systems Consultant to join their Canadian Finance team in Waterloo. This role involves supporting data engineering and governance initiatives, ensuring documentation and testing processes are aligned with business needs. The successful candidate will have opportunities to collaborate with various teams, enhancing their skills and contributing to a rewarding work environment.

Benefits

15 vacation days per year

Flexible Benefits

Pension and stock programs

Access to Global Learning Centre

Wellness programs

Qualifications

• 3+ years experience in a technical Business Analyst or data-focused role.
• Expertise in ETL/ELT, AWS tools, data pipelines.
• Solid understanding of data governance principles.

Responsibilities

• Document data pipelines and governance policies.
• Gather technical requirements for BI solutions.
• Develop and execute test plans for AWS systems.

Skills

Data Engineering

Technical Documentation

Collaboration

Testing & QA

Data Governance

Education

Undergraduate degree in Information Systems

Computer Science

Business or related field

Tools

Confluence

JIRA

Job description

Business Systems Consultant page is loaded

Business Systems Consultant

Apply locations Waterloo, Ontario time type Full time posted on Posted Yesterday job requisition id JR00112791

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

About the role:

We are seeking a detail-oriented and technically fluent Business Systems Consultant (BSC) to join our Finance Optimization function within the Canadian Finance team at Sun Life Canada. The successful candidate will support our data engineering, governance, and BI initiatives. This role is critical in ensuring our data pipelines, governance policies, intake processes, and testing protocols are well-documented, traceable, and aligned with business requirements.

What will you do?

Data Engineering & Governance Documentation:

• Document data pipeline architecture, transformations, lineage, and dependencies.
• Maintain current records of data engineering processes and controls.
• Assist in writing and maintaining data governance policies, including data quality, stewardship, metadata, and classification standards.

Business & Technical Requirements Gathering:

• Collaborate with business stakeholders to gather and clarify intake requirements for BI dashboards, reports, and data solutions.
• Translate business needs into clear, structured technical requirements for developers and engineers.
• Create and maintain user stories, acceptance criteria, and process flows.

Testing & QA:

• Develop and execute test plans, test cases, and test scripts for AWS-based systems and services.
• Perform manual and automated testing of software/products, including data transformations and BI solutions.
• Conduct regression testing and system integration testing.
• Assist in coordinating UAT sessions with business users.
• Ensure testing results are documented, and defects are logged, tracked, and resolved.

Cross-Team Collaboration:

• Work closely with BI analysts, data engineers/stewards, and project managers to ensure alignment between technical and business teams.
• Facilitate documentation handoffs and knowledge transfer for future support and scaling.

What do you need to succeed?

• 3+ years of experience in a technical Business Analyst, data analyst, or documentation-focused role.
• Undergraduate degree in Information Systems, Computer Science, Business, or a related field.
• Expertise in data engineering concepts(ETL/ELT, data pipelines/warehouses, AWS tools).
• Experience writing technical documentation (data lineage, test plans, process diagrams).
• Solid understanding of data governance principles (preferred: knowledge of frameworks like DAMA-DMBOK).
• Proficient with documentation and project management tools such as Confluence and JIRA.

What's in it for you?

• Hybrid work environment
• A friendly, collaborative, and inclusive culture
• 15 vacation days per year
• Flexible Benefits from the day you join to meet the needs of you and your family
• Pension, stock and savings programs to help build and enhance your future financial security
• The opportunity to move along a variety of career paths with amazing networking potential
• Access to our Global Learning Centre, available 24/7 for your learning needs
• Wellness programs that support the three pillars of your health – mental, physical and financial

Recent Awards:

• We are honoured to be recognized as a 2022, 2023 and 2024 Best Workplaces in Canada by Great Place to Work Canada
• Great Place to Work list for Best Workplaces for #HybridWork 2022
• Great Place to Work list for Best Workplaces for Professional Development in Canada 2022
• Named “Best Places to Work” by Glassdoor, 2021 and 2023

The Base Pay range is for the primary location for which the job is posted. It may vary depending on the work location of the successful candidate or other factors. In addition to Base Pay, eligible Sun Life employees participate in various incentive plans, payment under which is discretionary and subject to individual and company performance. Certain sales focused roles have sales incentive plans based on individual or group sales results.

Diversity and inclusion have always been at the core of our values at Sun Life. A diverse workforce with wide perspectives and creative ideas benefits our Clients, the communities where we operate and all of us as colleagues. We welcome applications from qualified individuals from all backgrounds.

Persons with disabilities who need accommodation in the application process, or those needing job postings in an alternative format, may e-mail a request to [e-mail] .

We are proud to be a hybrid organization that offers our employees the choice and flexibility to work from both the office and virtually based on the needs of the business, our Clients and you! Several work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

Salary Range:

54,000/54 000 - 91,000/91 000

Job Category:

Advanced Analytics

Posting End Date:

03/07/2025

Shine together

At Sun Life, you can be your most brilliant self. Our supportive, flexible, and inclusive work environment is one where you – and your career – can thrive. Whatever your aspirations, collaborative leaders and colleagues are ready to help you learn, grow, and succeed.

We’re a global company with a passion for people. Our purpose is to help Clients achieve lifetime financial security and live healthier lives. As a team of 30,000 across 26 countries, our impact is far-reaching, and locally relevant There’s power in numbers. As part of Sun Life’s growing team, you have an impact on people in your community and around the world.

Shape the future

With an optimistic eye on a brighter future, we drive to innovate. Be part of leading change, push boundaries and try new ways of working. Use data to drive bold actions. Be agile and pivot as we test and learn. At Sun Life, we’re driving transformation, sustainability and innovation for our Clients, employees, partners, and communities. Join us. Together, we can make the future brighter.