Lead Engineers

Sun Life Financial; Wellesley (MA); On-site; USD 150,000 - 160,000; Full time

Benefits offered by this job

Generous vacation & sick time

Family leave & parental leave

Medical coverage

Life & AD&D insurance

Disability programs

Sabbatical program

401(k) employer match

Stock purchase options

Employer-funded retirement account

Job summary

Sun Life U.S. is seeking a Lead Engineers – Data Support in Wellesley Hills, MA for ETL and data lake support. You will be the subject-matter expert on Oracle and SQL data warehouse, lead upgrades, and serve as an escalation point for Data Lake support.

100% telecommuting permitted from anywhere in the U.S. Responsibilities include monitoring data lake processes, troubleshooting production issues, and coordinating with business partners to resolve data discrepancies.

Qualifications

• Bachelor's degree in computer/data science, computer/electronics engineering, or closely related field.
• Five years of progressive experience in data engineering or related occupation.
• Experience with ETL tools (Informatica PowerCenter, Hadoop, or Qlik).
• Job scheduling experience (Autosys, Control-M).
• Experience with IBM DataStage.

Responsibilities

• Monitor data lake processes and ETL pipelines.
• Troubleshoot production issues and perform load/performance testing.
• Resolve production issues and restart processes promptly.
• Analyze data discrepancies; identify root causes and implement fixes.
• Create new ETL or reporting processes as needed.
• Collaborate with internal partners to identify root causes of issues.
• Provide updates on projects and apply testing methodologies to software solutions.
• Work with cross-functional teams to ensure timely data issue resolution.
• Mentor team members and share knowledge across data science, engineering, and development.

Skills

ETL engineering

SQL & Oracle

Data Lake & warehouse

Performance testing

Education

Bachelor's degree in Computer/Data Science or related field

Tools

Informatica PowerCenter

Hadoop

Qlik

Autosys

Control-M

IBM DataStage

Job description

Sun Life U.S. is one of the largest providers of employee and government benefits, helping approximately 50 million Americans access the care and coverage they need. Through employers, industry partners and government programs, Sun Life U.S. offers a portfolio of benefits and services, including dental, vision, disability, absence management, life, supplemental health, medical stop-loss insurance, and healthcare navigation. We have more than 6,400 employees and associates in our partner dental practices and operate nationwide. At Sun Life, we're driven by our Purpose: helping our Clients achieve lifetime financial security and live healthier lives. Our values shape how we work: caring, authentic, bold, inspiring, and impactful. When you join Sun Life, you'll work with passionate colleagues and empowering leaders who support your growth and celebrate your contributions, so you can make a meaningful difference in our Clients' lives.

Job Description

This Notice is being provided as a result of the filing of an application for permanent Alien Labor Certification for the relevant job opportunity and any person may provide documentary evidence bearing on the application to the Certifying Officer for the Department of Labor,U.S. Department of Labor, Employment and Training Administration, Office of Foreign Labor Certification, 200 Constitution Avenue NW, Room N-5311, Washington, DC 20210.

Lead Engineers – Data Support (Sun Life Financial [U.S.] Services Company, Inc., Wellesley Hills, MA): Will cover ETL (extract, transform and load) support and data lake support, act as a subject-matter expert on Oracle and SQL data warehouse support, serve as an escalation point for Data Lake technical support, and lead technical upgrades and infrastructure changes required on these platforms. 100% Telecommuting permitted from anywhere in the U.S.

Duties include:

• Monitor data lake processes and other ETL
• Troubleshoot urgent failures in production environment and apply performance testing coding best practices as well as facilitate load and performance testing
• Resolve technical issues and restart production processes in a timely fashion
• Analyze data discrepancies in production processes, find root cause, make code changes where necessary, test, implement solution, etc.
• Create net new ETL or report processes for smaller scale items where necessary
• Deal directly with internal business partners to identify root cause of reported technical problems
• Provide detailed updates on technical project assignments to managers and apply testing skills, tools/frameworks, techniques, processes and principles to software solutions to support of defect management and reporting processes
• Work closely with cross-functional teams to ensure reported data 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 applying data science, engineering, system administration, and software development (programming) foundation
• Perform daily duties utilizing applicable technologies tools including but not limited to: Business Intelligence and reporting tools including Business Objects, Crystal, or LOGIXML; Microsoft BI/Microsoft stack; ETL tools such as Informatica PowerCenter, Hadoop, or Qlik; Job scheduling tools (Autosys, Control M); AWS Cloud (EC2, EMR, S3, Kinesis, Dynamo); Application Programming Interface (API); Gateway; and LAMDA.

Minimum Requirements

bachelor’s degree (foreign equivalent degrees accepted) in computer/data science, computer/electronics engineering, or a closely related technical field of study, and five years of progressive experience in data engineering, data engineering support, or a related occupation, including: experience withsystem administration and software development (programming) foundation; experience in performance testing coding best practices as well as load and performance testing; experience with ETL tools such as Informatica PowerCenter, or Hadoop, or Qlik; Job scheduling experience (Autosys, Control M), and experience with IBM DataStage.

This position qualifies for our employee referral program.

Salary

The salary range for this position is one hundred fifty thousand to one hundred sixty thousand dollars annually for full-time employment. At our company, we are committed to pay transparency and equity. The salary range for this role is competitive nationwide, and we strive to ensure that compensation is fair and equitable. Your actual base salary will be determined based on your unique skills, qualifications, experience, education, and geographic location. In addition to your base salary, this position is eligible for a discretionary annual incentive award based on your individual performance as well as the overall performance of the business. We are dedicated to creating a work environment where everyone is rewarded for their contributions.

Benefits

• Generous vacation and sick time
• Market-leading paid family, parental and adoption leave
• Medical coverage
• Company paid life and AD&D insurance
• Disability programs
• Partially paid sabbatical program
• 401(k) employer match
• Stock purchase options
• Employer-funded retirement account

EEO and Diversity Commitments

We are committed to fostering an inclusive environment where all employees feel they belong, are supported and empowered to thrive.

We are dedicated to building teams with varied experiences, backgrounds, perspectives and ideas that benefit our colleagues, clients, and the communities where we operate.

We encourage applications from qualified individuals from all backgrounds.

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.

Sun Life will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including applicable fair chance ordinances.

We do not require or administer lie detector tests as a condition of employment or continued employment.

Accommodations

We will make reasonable accommodations to the known physical or mental limitations 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 [e-mail] to request an accommodation.

For applicants residing in California, please read our employee California Privacy Policy and Notice.

Legal Notices

NOTE: This posting is in compliance with the filing of an Application for Labor Certification. Applicants should report directly to the employer, and not the local State Employment Service Office.

Job Category: IT - Application Development Posting End Date: 29/10/2026