City : North York

Category : Full-time

Industry : Finance

Employer : Sun Life Financial

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:

We are looking for an experienced and high-performing individual to join our Data and Analytics Delivery team as a Software Engineer on the Delivery team. This development role is responsible for the building, deployment, and support of data integration for BI reporting and analytic solutions, and application integration solutions using Informatica, Python, AWS Glue and supporting tools and services. The Delivery team is involved in exciting projects using leading-edge technologies and leveraging our AWS Cloud based data platform for advanced analytics and data science.

What will you do?

• Assist in design, development and implementation of end-to-end complex ETL system using Informatica PowerCenter, Python, Glue or other AWS related technologies

• Apply company best practices for ETL design and development

• Produce written deliverables for technical design, system testing and implementation activities

• Implement ETL systems that are operationally stable, efficient, and automated

• Implement technical solutions that are scalable, aligned with the enterprise architecture and can adapt to changes in business

• Conduct System Testing - execute job flows, investigate system defects, resolve defects and document results

• Deliver solutions according to Systems Development Life Cycle (SDLC) methodology for either waterfall or agile projects

• Develop and manage effective working relationships with other departments, groups or personnel with whom work must be coordinated.

What do you need to succeed?

• Minimum 3 years experience in developing solutions for data warehouse loads and system integrations using ETL tools such as Informatica PowerCenter

• Minimum 1 year hands-on expertise on AWS Cloud Computing environment and experience with building ETL using AWS Glue (Python)

• Minimum 1 year experience with Big Data with knowledge of MapReduce and Hive

• Spark expertise is desirable

• Minimum 1 year experience with Python script development using PySpark, Python libraries, configuration driven and object-oriented ETL

• Experience creating complex data frames/structures in Hadoop for data integration and complex calculations

• Ability to work in a global multi-site environment and working in a matrix environment, onshore/offshore IT model

Preferred Skills

• Experience with production implementation change management processes

• Experience with project management and software development life cycle/SDLC; Agile and Lean  

• Excellent documentation skills including technical writing

• Strong communication and analytical skills, including conceptual, requirements interpretation, solution creation and problem-solving abilities

What’s in it for you?

• A flexible work schedule, provided it includes core working hours

• Competitive salary

• Being part of our journey in developing the next greatest digital experience

• Flexible Benefits from the day you join to meet the needs of you and your family

• Wellness programs that support the three pillars of your health – mental, physical, and financial

• Membership to a highly collaborative, supportive, and productive team

• An extensive support system for continual learning including company-run courses, access to online learning platforms

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 thebrightside@sunlife.com.

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:

Job Category:

Posting End Date: