Lead Engineers

Sun Life; Wellesley (MA); Remote; USD 150,000 - 160,000; Full time

Benefits offered by this job

Vacation time

Sick leave

Family leave

Medical insurance

Life insurance

Disability coverage

401(k) matching

Stock options

Sabbatical

Job summary

Sun Life U.S. is seeking a Lead Engineer - Data Support in Wellesley Hills, MA (remote). You will own ETL and data lake support, serve as SME on Oracle and SQL data warehouses, and mentor a cross-functional team to ensure timely data delivery.

The role requires a strong background in data engineering, production support, and BI tools; offer 100% telecommuting from anywhere in the U.S., a competitive salary, and an incentive program.

Qualifications

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

Responsibilities

• Monitor data lake processes and ETL workloads.
• Troubleshoot production failures and conduct performance testing.
• Analyze data discrepancies and implement fixes.
• Develop new ETL or reporting processes as needed.
• Collaborate with business partners to resolve data issues.
• Mentor team members and share knowledge.

Skills

ETL

Data lake

Oracle

SQL

Production support

Education

Bachelor's degree in CS/related field

Tools

Informatica

Hadoop

Autosys

Control-M

AWS

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.

Visit our website to discover how Sun Life is making life brighter for our customers, partners and communities.

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. 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; and 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. 100% Telecommuting permitted from anywhere in the U.S.

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. 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.

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.

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.

Life is brighter when you work at Sun Life

At Sun Life, we prioritize your well-being with comprehensive 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
• flexible, inclusive and collaborative work environment that supports career growth

We're proud to be recognized in our communities as a top employer. Proudly Great Place to Work Certified in Canada and the U.S., we've also been recognized as a "Top 10" employer by the Boston Globe's "Top Places to Work" for two years in a row. Visit our website to learn more about our benefits and recognition within our communities.

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

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

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.

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.

Job Category:

IT - Application Development

Posting End Date:

29/10/2026