Lead Engineers

Sun Life•Wellesley, MA

2d•$150,000 - $160,000•Remote

About The Position

Sun Life U.S. is a major provider of employee and government benefits, serving approximately 50 million Americans. The company offers a range of benefits and services, including dental, vision, disability, absence management, life, supplemental health, medical stop-loss insurance, and healthcare navigation, through employers, industry partners, and government programs. With over 6,400 employees and associates, Sun Life U.S. operates nationwide and has partner dental practices. The company's Purpose is to help clients achieve lifetime financial security and live healthier lives, guided by values of caring, authentic, bold, inspiring, and impactful. Joining Sun Life means working with passionate colleagues and supportive leaders who foster growth and celebrate contributions, enabling meaningful impact on clients' lives.

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.

Responsibilities

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