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. Discover how you can make a difference in the lives of individuals, families and communities around the world.

:

Do you want to build and maintain mission critical data processing and transformation systems that will help run one of Canada's biggest financial institutions? Do you enjoy being part of a tight-knit, empowered team? Do you have experience writing data manipulation code in a cloud using Python and/or Pyspark? If so, we'd like to hear from you!

We are looking for an Extract, Transform, and Load (ETL) Developer with a strong technical background and cloud experience to join the Corporate Application Solutions (CAS) team.

This is an exciting opportunity to be part of the IT organization dedicated to excellent customer service through digital transformation, supporting continuous learning, career growth and diversity.

What will you do?

• Provide ongoing support and maintenance of AWS Glue ETL and related integration components, including on-call support on a rotation basis, problem analysis, resolution, and escalation.
• Participate in Requirement Analysis, Estimation, Solution & Design, and Development and Implementation of applications hosted on AWS.
• Contribute to defining timetables, project plans and product roadmaps.
• Configure and install software products, patches, vendor releases in multiple environments.
• Enhance and support the Glue, Lambda, and ETL jobs.
• Apply analysis skills to understand and assess the impact of infrastructure and technical changes within the environment.
• Provide recommendations and alternatives for system enhancements.
• Take complete ownership of work assignments and ensure the successful completion of assigned tasks.
• Establish and maintain relationships with overseas and 3rd party team members, business partners, subject matter experts and software vendors.
• Create and maintain technical documentation for supported systems.
• Ensure Sun Life Information Security Policies and GCC are adhered to in any solution.
• Maintain effective communication with management, team members and the business.

What you need to succeed:

• Bachelor's degree in computer science, computer engineering, or equivalent experience.
• 5+ years of experience working with complex technical environments involving multiple IT platforms. We use Windows, Unix, Linux, Cloud, and ETL technologies.
• 3+ years of experience creating ETL jobs using cloud technologies (e.g., Glue, Data Bricks).
• Experience in creating Python scripts using data libraries.
• Skill with Spark, PySpark, or Scala.
• Experience with Relational SQL (Oracle, PostgreSQL, SQL Server) databases.
• Strong knowledge of SQL query language - able to perform all CRUD operations.
• Experience in any object-oriented/object function scripting language, such as Python.
• Experience with Windows/Linux/Unix scripting languages.
• Proficient with the ITIL framework and processes such as Change, Incident, Problem and Configuration Management.

Preferred Skills:

• Experience with SFTP and TCP network protocols.
• Experience with integrating vendor packages into an established Production environment consisting of various technologies and platforms.
• Knowledge of Active Directory, Single Sign-On and Web Hosting concepts.
• Good understanding / hands-on experience with AWS data services - like Glue, Step function, Lambda, AWS Workflows, S3, Redshift, ODS.
• Experience in working with AWS SDK and integration with various AWS services.
• Hands-on experience with DevOps tools (e.g., Git, Jenkins, SourceTree, Ansible).
• Strong analytical and problem-solving skills with ability to analyze situations/problems systematically and deliver effective right-sized solutions in a timely manner.
• Strong organizational and planning skills.
• Excellent verbal and written communications skills.
• Experience with managing and coordinating team activities in a multi-site environment.

Nice to have:

• Experience with ETL development tools (PowerCenter, Informatica and/or SSIS).
• Experience with PowerShell scripting.
• Experience with Job schedulers (Control-M).
• Experience with Tableau reporting system.
• Experience with PostgreSQL.

Notes/Unique requirements:

• Occasional weekend and after-hours work.
• On-call support as part of a rotation.
• Occasional travel between Sun Life locations may be required depending on work assignments.
• Must be able to obtain Reliability Status through the Government of Canada before a start date can be confirmed (includes a background check with fingerprinting by the RCMP).

#LI- Remote

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 .

At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible 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: 80,000/80 000 - 130,400/130 400

Job Category: IT - Application Development

Posting End Date: 29/11/2022