Analyst, Automation Development

Sun Life; Southwestern Ontario; Hybrid; CAD 60,000 - 97,000; Full time

Benefits offered by this job

Hybrid work environment

15 vacation days per year

Flexible Benefits

Pension, stock and savings programs

Learning Centre access

Wellness programs

Job summary

Sun Life Financial is seeking an Analyst, Automation Development within the Global Investments Strategic Analytics and Innovation team. You will design, build, test, deploy, and maintain automation and AI-enabled solutions, working with the canonical data layer and writing clean SQL and production code.

Key duties include developing automations from approved requirements, ensuring reliability through testing, monitoring, and documentation, and collaborating with stakeholders to enable reusable

Qualifications

• 3–6 years of software development, SQL scripting, data engineering, workflow automation, cloud platform development, or a related technical discipline.
• SQL proficiency and Python development experience.
• University degree in a related technical discipline or equivalent experience.

Responsibilities

• Develop and deploy automation solutions using Python, SQL, Power Automate, and AWS Lambda.
• Ensure quality through functional, integration, and edge-case testing; implement logging and monitoring.
• Triage failures, resolve defects, maintain run books, and keep documentation current.
• Assess feasibility, data availability, and integration constraints; identify dependencies and reuse opportunities.

Skills

SQL scripting

Data engineering

Python development

Automation workflows

Cloud development

Problem solving

Education

University degree in CS/IT/SE or related

Tools

Python

SQL

Power Automate

AWS Lambda

Microsoft 365 tools

Job description

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.

At Sun Life, we're driven by our Purpose: helping our Clients achieve lifetime financial security and live healthier lives. Our values shape how we work: caring, authentic, bold, inspiring, and impactful.

When you join Sun Life, you'll work with passionate colleagues and empowering leaders who support your growth and celebrate your contributions, so you can make a meaningful difference in our Clients' lives.

Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description

About the role

The Analyst, Automation Development is a fully functional, independently operating role within Sun Life Global Investments on the Strategic Analytics and Innovation team. The role is responsible for designing, building, testing, deploying, and maintaining automation and AI-enabled solutions from approved specifications. The role works directly with the canonical data layer, applies clean SQL and development practices, and ensures deployed solutions are reliable, documented, monitored, and supportable. The incumbent is fully proficient in the critical skills, knowledge, and competencies required for the role and may provide guidance to less experienced team members where applicable.

Develop and Deploy Automation Solutions

• Build automations and AI-enabled workflows from approved requirements.


• Write, test, and maintain production code using Python, SQL, Power Automate, Microsoft 365 tools, AWS Lambda, and approved AI tooling.


• Follow source control, code review, change management, and deployment protocols.

Ensure Quality, Reliability, and Sustainment

• Design and execute functional, integration, and edge-case testing.


• Implement error handling, logging, monitoring, and alerting for deployed solutions.


• Triage failures, resolve defects, maintain run books, and keep solution documentation current.

Support Feasibility, Design, and Reuse

• Assess requirements for feasibility, data availability, integration constraints, and technical risk.


• Identify dependencies against Keel and other source systems.


• Use shared components, templates, and documented standards to improve consistency and reduce future build effort.


• Identify opportunities to improve automation practices, increase efficiency, and enhance consistency across repeatable solutions.

What do you need to succeed

• 3-6 years of experience in software development, SQL scripting, data engineering, workflow automation, cloud platform development, or a related technical discipline.


• SQL proficiency.


• Python development experience.


• Knowledge of data integration and ETL concepts.


• Strong testing, troubleshooting, documentation, and monitoring discipline.


• Strong logic, analytical thinking, and structured problem-solving skills with a high attention to detail.


• Clear communication skills, with sound judgment, and ability to work successfully with technical and non-technical stakeholders.


• University degree in Computer Science, Information Technology, Software Engineering, or a related technical discipline; or an equivalent combination of education and experience.

Preferred Skills

• Experience with Power Automate, Microsoft 365 workflow tools, AWS services, source control, code review, deployment pipelines, and AI-assisted development tools such as Claude Code or Bedrock.

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, 2024 and 2025 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.

We may use artificial intelligence to support candidate sourcing, screening, interview scheduling.

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

Salary Range

60,000/60 000 - 97,000/97 000

Job Category

Advanced Analytics

Posting End Date

01/10/2026