Senior Data Platform Engineer - ETL & Data Lake (Remote)

sunlife; United States; Remote; USD 150,000 - 160,000; Full time

Job summary

Sun Life U.S. is seeking Lead Engineers - Data Support to cover ETL and data lake support, acting as a SME on Oracle and SQL data warehouse support, and leading upgrades and infrastructure changes on these platforms.

You will monitor data lake processes, troubleshoot production failures, and collaborate with business partners to identify root causes. The role requires a bachelor's degree in a technical field and 5+ years in data engineering.

Qualifications

• Bachelor's degree (foreign equivalent accepted) in computer/data science, computer/electronics engineering, or closely related field.
• Five years of progressive experience in data engineering, data engineering support, or related occupation.
• Experience with system administration and software development (programming) foundation.
• Experience in performance testing, load testing, and related best practices.
• 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 other ETL.
• Troubleshoot urgent production failures and apply performance testing best practices; facilitate load testing.
• Resolve technical issues and restart production processes promptly.
• Analyze data discrepancies, identify root cause, implement code changes, test and deploy solutions.
• Create new ETL or report processes for smaller items as needed.
• Collaborate with internal partners to identify root causes of issues.
• Provide updates to managers and support defect management and reporting.
• Work with cross-functional teams to ensure data issues are investigated and resolved in a timely manner.
• Mentor team members to share knowledge across data science, engineering, and software development.

Skills

ETL

SQL

Data lake

Oracle

Performance testing

Troubleshooting

Data warehouse

Mentoring

Education

Bachelor's degree

Tools

Informatica PowerCenter

Hadoop

Qlik

Autosys

Control-M

IBM DataStage

Job description

Sun Life U.S. is seeking Lead Engineers - Data Support to cover ETL and data lake support, acting as a SME on Oracle and SQL data warehouse support, and leading upgrades and infrastructure changes on these platforms.

You will monitor data lake processes, troubleshoot production failures, and collaborate with business partners to identify root causes. The role requires a bachelor's degree in a technical field and 5+ years in data engineering.