Lead Engineers

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

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.

• 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

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
• five years of progressive experience in data engineering, data engineering support, or a related occupation
• experience with system 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)
• experience with IBM DataStage

The salary range for this position is one hundred fifty thousand to one hundred sixty thousand dollars annually for full-time employment.

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.

This position qualifies for our employee referral program.

We are dedicated to creating a work environment