Senior Associate, Data Engineer

New York Life Insurance; New York (NY); On-site; USD 95,000 - 163,000; Full time

Job summary

Join a forward-thinking company as a Data Engineer, where you will build and optimize data pipelines using cutting-edge AWS technologies. This role involves designing robust data infrastructures, leveraging your expertise in Python and SQL, and collaborating with talented teams to drive data-driven insights. You will play a crucial part in transforming data capabilities that empower various applications and analytics. If you are passionate about data engineering and want to make a meaningful impact in a dynamic environment, this opportunity is perfect for you.

Benefits

Comprehensive benefits package

Leave programs

Adoption assistance

Student loan repayment programs

Annual discretionary bonus

Incentive program participation

Qualifications

• 3+ years of experience as a Cloud Data Engineer or similar role.
• Proficient in AWS services for data management and processing.
• Strong background in data pipeline architecture and ETL processes.

Responsibilities

• Design and develop data infrastructure for enterprise applications.
• Optimize data pipeline architecture using AWS and SQL.
• Collaborate with cross-functional teams to meet data needs.

Skills

AWS Cloud Technologies

Python

Data Engineering

SQL

Data Integration

ETL/ELT

Data Streaming

Education

Bachelor’s degree in Data Science

Bachelor’s degree in Computer Engineering

Tools

AWS RDS

AWS DMS

AWS Glue

AWS S3

AWS Lambda

PySpark

Job description

Location Designation: Hybrid - 3 days per month

The Enterprise Data Management team provides transformative data capabilities and solutions that serve as the core data, reporting, and analytics platform for the Insurance & Agency Group at New York Life (NYL). The Enterprise Data Management team is looking for a Data Engineer with the skills listed below.

Job Overview:

Build, expand, and optimize data pipeline architecture using Amazon Web Services cloud, Python and Pyspark. Utilize tools like Amazon Relational Database Service (AWS DMS), AWS Glue, Amazon Simple Storage Service (AWS S3), AWS Lambda triggers & functions, etc. Leverage Data Engineering strategies, Data Lake/Lakehouse/Data Warehouse technologies, and streaming/real-time data to bring data into the ecosystem for consumption. Use SQL for data analysis.

What You’ll Do:

• Design and develop enterprise infrastructure and platforms required for data engineering.
• Use AWS Cloud technologies to support data needs for expansion of Machine Learning/Data Science capabilities, applications/mobile apps/systems, BI/analytics, and cross-functional teams.
• Create methods and routines to transition data from on-premise systems to the AWS Cloud.
• Store data in AWS Cloud platform and develop transformational logic based on business rules.
• Create and maintain optimal data pipeline architecture. Test and implement data environments.
• Assemble large, complex data sets to meet functional/non-functional business requirements.
• Build the infrastructure required for optimal ETL/ELT (extraction, transformation, and loading) of data from a wide variety of data sources using SQL and AWS big data technologies.
• Utilize AWS Cloud tools like Amazon Relational Database Service (AWS DMS), AWS Glue, Amazon Simple Storage Service (AWS S3), AWS Lambda triggers & functions, to ingest data sets and create pipelines.
• Develop and debug code in PySpark/Spark/Python. Use SQL and/or Postgres.
• Use Data Pipeline, workflow management, and orchestration service tools.
• Collaborate with Cloud Data Architects, Data Engineers, DBAs, Analytics & Software Engineers.
• Interact with stakeholders, Product Management, and Design teams to understand data pipeline requirements, design solutions, and resolve issues.

What You’ll Bring:

• 3+ years as a Cloud Data Engineer, Data Engineer, Data Architect, AWS Engineer, etc.
• 3+ years with Amazon Relational Database Service (RDS), AWS Database Migration Service (AWS DMS), Amazon Simple Storage Service (S3) Data Lake, AWS Lambda, etc. in shared service, hybrid environments.
• Highly scalable Data stores, Data Lake, Data Warehouse, Lakehouse, and unstructured datasets.
• Data integration, data processing, data streaming, message queuing, and/or ETL/ELT.
• Ability to lead a team of developers.
• Bachelor’s degree in Data Science, Computer Engineering, or related field preferred.

Pay Transparency

Salary Range: $95,000-$162,500

Overtime eligible: Exempt

Discretionary bonus eligible: Yes

Sales bonus eligible: No

Actual base salary will be determined based on several factors but not limited to individual’s experience, skills, qualifications, and job location. Additionally, employees are eligible for an annual discretionary bonus. In addition to base salary, employees may also be eligible to participate in an incentive program.

Our Benefits

We provide a full package of benefits for employees – and have unique offerings for a modern workforce, including leave programs, adoption assistance, and student loan repayment programs. Based on feedback from our employees, we continue to refine and add benefits to our offering, so that you can flourish both inside and outside of work. Click here to discover more about our comprehensive benefit options or visit our NYL Benefits Site.

Our Diversity Promise

We believe in a diverse workforce because it is our mission to advocate for the financial security and success of people in every community. This is why diversity, equity, and inclusion (DEI) are guiding principles that are embedded in our brand and our culture. Click here to learn more about how we have been recognized for our leadership.

Recognized as one of Fortune’s World’s Most Admired Companies, New York Life is committed to improving local communities through a culture of employee giving and volunteerism, supported by the Foundation. We're proud that due to our mutuality, we operate in the best interests of our policy owners. To learn more about career opportunities at New York Life, please visit the Careers page of www.NewYorkLife.com.

Job Requisition ID: 91532