Lead Data Engineer - ETL & Data Lake (Remote)

Sun Life Financial; Wellesley (MA); Remote; 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 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.