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.

This role involves the support of our data organization. The role will cover ETL support , Report support and AWS data lake support. As part of the role the candidate is also responsible for technical upgrades/infrastructure changes that are needed on these platforms. There are numerous technologies used by the team (SQL, Oracle, Crystal Reports, SSRS, LOGI, Tableau Informatica, SSIS etc..) so the candidate will have the opportunity to strengthen or learn a wide range of skills. In addition to supporting these processes the role will involve creation of new ETL processes, reports etc. from time to time. The role will involve on call off hours support as part of a regular scheduled rotation.

Preferred Skills

• Strong Microsoft BI skills (SSIS, SSRS, Microsoft stack experience as a very basic minimum).
• Experience with Business Intelligence and reporting tools such as Business Objects, Crystal or LOGIXML.
• Experience with other ETL tools such as PowerCenter Informatica.
• Job scheduling experience (Autosys, Control M)
• Experience of working in the financial services sector (particularly insurance, ideally group benefits)
• Oracle experience highly desirable.
• Technically minded problem solver
• Engineering, system administration and software development (programming) foundation
• Ability to apply testing skills, tools/frameworks, techniques, processes and principles to software solutions in support of defect management and reporting.
• Experience of performance testing coding best practices, and load and performance testing
• Familiarity with and ability to utilize multiple software development methodologies, processes, development best practices and DevOps principles.

Qualifications

• Third level qualification in an IT or related discipline. Or equivalent experience.
• Minimum of 5 years of experience in data engineering/data engineering support or a related field.

Responsibilities

• Monitoring of our ETL processes and reports where necessary
• Troubleshooting urgent failures in our production environment
• Resolving issues and restarting production processes in a timely fashion
• Analyzing data discrepancies in our production processes, finding root cause, making code changes where necessary, testing, implementing solution etc.
• Creating net new ETL or reporting processes for smaller scale items where necessary.
• Dealing directly with our internal business partners to help get to the root of a reported problem.
• Providing detailed updates on work assignments to managers
• Work closely with cross-functional teams to ensure that reported issues are being investigated and resolved in a timely manner.
• Collaborate with and mentor members of the team to ensure knowledge is shared throughout the team.
  

Not ready to apply yet but want to stay in touch? Join our talent community to stay connected until the time is right for you!

Life is brighter when you work at Sun Life
-
Excellent benefits and wellness programs to support the three pillars of your well-being - mental, physical and financial - including generous vacation and sick time, market-leading paid family, parental and adoption leave, a partially-paid sabbatical program, medical plans, company paid life and AD&D insurance as well as disability programs and more
-
Retirement and Stock Purchase programs to help build and enhance your future financial security including a 401(k) plan with an employer-paid match as well as an employer-funded retirement account
-
A flexible work environment with a friendly, caring, collaborative and inclusive culture
-
Great Place to Work Certified in Canada and the U.S.
-
Named as a "Top 10" employer by the Boston Globe's "Top Places to Work" two years running

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

If you are a California resident, the salary range for this position is:
-
Southern region: $103,900 - $155,900 annually
-
Central region: $109,600 - $164,400 annually
-
Northern region: $117,100 - $175,700 annually

If you are a Colorado resident, the salary range for this position is $ 99,200 148,800 annually.

If you are a New York resident, the salary range for this position is $$117,100 - $175,700 annually.

If you are Washington resident, the salary range for this position is $109,600 - $164,400 annually.


-
The full range minimum and maximum listed in the job posting is tied to the GCF level and job family.

We consider various factors in determining actual pay including your skills, qualifications, and experience. In addition to salary, this position is eligible for incentive awards based on individual and business performance as well as a broad range of competitive benefits.

Sun Life Financial is a leading provider of group insurance benefits in the U.S., helping people protect what they love about their lives. More than just a name, Sun Life symbolizes our brand promise of making life brighter -for our customers, partners, and communities. Join our talented, diverse workforce and launch a rewarding career. Visit us at www.sunlife.com/us to learn more.

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.

#LI-remote

Our Affirmative Action Program affirms our commitment to make reasonable accommodation to the known physical or mental limitation of otherwise-qualified individuals with disabilities or special disabled veterans, unless the accommodation would impose an undue hardship on the operation of our business. Please email to request an accommodation.

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.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.