Lead Engineers

Sun Life • Wellesley, MA

1d • Remote

About The Position

Sun Life Financial (U.S.) Services Company, Inc. is hiring Lead Engineers – Data Support to provide ETL and data lake support. The role serves as a subject-matter expert for Oracle and SQL data warehouse support, acts as an escalation point for Data Lake technical support, and leads technical upgrades and infrastructure changes for these platforms. The position is 100% telecommuting from anywhere in the U.S.

The Lead Engineer monitors data lake and other ETL processes, troubleshoots urgent production failures, resolves technical issues, and analyzes production data discrepancies to identify root causes and implement tested fixes. The role may create new ETL or reporting processes for smaller-scale needs, works directly with internal business partners, and provides project updates to managers. It also works across teams to investigate and resolve data issues and mentors colleagues to promote knowledge sharing.

Requirements

• Bachelor’s degree, or foreign equivalent, in computer/data science, computer/electronics engineering, or a closely related technical field.
• Five years of progressive experience in data engineering, data engineering support, or a related occupation.
• Experience with system administration and a software development (programming) foundation.
• Experience with performance-testing coding best practices and load and performance testing.
• Experience with ETL tools such as Informatica PowerCenter, Hadoop, or Qlik.
• Job scheduling experience with Autosys or Control M.
• Experience with IBM DataStage.

Responsibilities

• Monitor data lake processes and other ETL processes.
• Troubleshoot urgent failures in the production environment and apply performance-testing coding best practices.
• Facilitate load and performance testing.
• Resolve technical issues and restart production processes in a timely manner.
• Analyze data discrepancies in production processes, identify root causes, make code changes where necessary, test, and implement solutions.
• Create new ETL or reporting processes for smaller-scale items when necessary.
• Work directly with internal business partners to identify the root causes of reported technical problems.
• Provide managers with detailed updates on technical project assignments.
• Apply testing skills, tools, frameworks, techniques, processes, and principles to software solutions supporting defect management and reporting processes.
• Work with cross-functional teams to ensure reported data issues are investigated and resolved in a timely manner.
• Collaborate with and mentor team members to share knowledge across the team.
• Lead technical upgrades and infrastructure changes required for the supported platforms.

Benefits

• Generous vacation and sick time.
• 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 supporting career growth.
• Eligible for a discretionary annual incentive award based on individual and business performance.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior