Automation & AI Development Analyst (Hybrid)

Sun Life; Kitchener; 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

Global Learning Centre access

Wellness programs

Job summary

Sun Life is hiring an Analyst, Automation Development to design, build, test, deploy and sustain automation and AI-enabled solutions on the Strategic Analytics and Innovation team. You will work with the canonical data layer, apply clean SQL and development practices, and provide guidance to teammates where applicable.

The role emphasizes developing automated workflows using Python, SQL, Power Automate, and AWS Lambda, with strong testing, monitoring and run book maintenance.

Qualifications

• 3–6 years of experience in software development, SQL scripting, data engineering, workflow automation, cloud platform development, or related technical discipline.
• SQL proficiency.
• Python development experience.
• Knowledge of data integration and ETL concepts.
• Strong testing, troubleshooting, documentation, and monitoring discipline.
• Clear communication and stakeholder skills.
• University degree in Computer Science, Information Technology, Software Engineering, or related field.

Responsibilities

• Develop and deploy automation solutions from approved requirements.
• Write, test, and maintain production code using Python, SQL, Power Automate, Microsoft 365 tools, AWS Lambda, and AI tooling.
• Follow source control, code review, change management, and deployment protocols.
• Design and execute functional, integration, and edge-case testing.
• Implement error handling, logging, monitoring, and alerting for deployed solutions.
• Triage failures, resolve defects, and maintain run books and documentation.
• Assess feasibility, data availability, integration constraints, and technical risks.
• Identify dependencies against Keel and other source systems.
• Use shared components and templates to improve consistency and reduce effort.
• Identify opportunities to improve automation practices and efficiency.

Skills

SQL scripting

Python

Data engineering

Workflow automation

Cloud platform development

Communication

Education

Bachelor's degree in Computer Science / Information Technology / Software Engineering

Tools

Power Automate

Microsoft 365

AWS

Source control

Deployment pipelines

AI-assisted development tools

Job description

Sun Life is hiring an Analyst, Automation Development to design, build, test, deploy and sustain automation and AI-enabled solutions on the Strategic Analytics and Innovation team. You will work with the canonical data layer, apply clean SQL and development practices, and provide guidance to teammates where applicable.

The role emphasizes developing automated workflows using Python, SQL, Power Automate, and AWS Lambda, with strong testing, monitoring and run book maintenance.