Join Sun Life as a Senior Python ETL Developer

At Sun Life, your unique background, experience, and perspective are highly valued. Here, you'll be encouraged, empowered, and challenged to be your best self. You will collaborate with dynamic colleagues who are experts in their fields and eager to share their knowledge with you. Our leaders will inspire and help you reach your potential and soar to new heights.

Every day presents new and exciting opportunities to positively impact the lives of 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: Senior Python ETL Developer

Are you passionate about building and maintaining mission-critical data processing and transformation systems for one of Canada’s largest financial institutions? Do you thrive in a tight-knit, empowered team environment? If you have experience writing data manipulation code in the cloud using Python and/or PySpark, we want to hear from you!

We are seeking an Extract, Transform, and Load (ETL) Developer with strong technical and cloud experience to join the Corporate Application Solutions (CAS) team. This is an exciting opportunity within our IT organization dedicated to excellent customer service, digital transformation, continuous learning, career growth, and diversity.

Responsibilities:

• Provide ongoing support and maintenance of AWS Glue ETL and related components, including on-call support, problem analysis, and resolution.
• Participate in requirement analysis, estimation, solution & design, development, and implementation of applications hosted on AWS.
• Contribute to defining project plans and product roadmaps.
• Configure and install software products and patches in multiple environments.
• Enhance and support Glue, Lambda, and ETL jobs.
• Apply analysis skills to understand the impact of infrastructure and technical changes.
• Provide recommendations for system enhancements.
• Take ownership of work assignments and ensure successful completion.
• Maintain relationships with overseas and third-party team members, business partners, and software vendors.
• Create and maintain technical documentation.
• Ensure compliance with Sun Life Information Security Policies.
• 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 IT environments involving multiple platforms, including Windows, Unix, Linux, Cloud, and ETL.
• 3+ years of experience creating ETL jobs using cloud technologies (e.g., Glue, Data Bricks).
• Experience creating Python scripts using data libraries and skills with Spark, PySpark, or Scala.
• Experience with SQL databases (Oracle, PostgreSQL, SQL Server) and strong knowledge of SQL query language.
• Proficiency in object-oriented/object-function scripting languages, such as Python, and Windows/Linux/Unix scripting languages.
• Familiarity with the ITIL framework and processes like Change, Incident, and Configuration Management.

Preferred Skills:

• Experience with SFTP and TCP network protocols.
• Knowledge of integrating vendor packages into an established Production environment.
• Understanding of Active Directory, Single Sign-On, and Web Hosting concepts.
• Hands-on experience with AWS data services and tools like DevOps (e.g., Git, Jenkins, SourceTree, Ansible).
• Strong analytical and problem-solving skills.
• Excellent organizational, planning, and communication skills.
• Experience managing and coordinating team activities in a multi-site environment.

Nice to Have:

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

Notes/Unique Requirements:

• Occasional weekend and after-hours work.
• On-call support on a rotation basis.
• Occasional travel between Sun Life locations.