Associate, AWS Data Engineer

New York Life; Overland Park (KS); Hybrid; USD 80,000 - 105,000; Full time

Benefits offered by this job

Leave programs

Adoption assistance

Student loan repayment

Job summary

New York Life is seeking an AWS Data Engineer to build and maintain cloud-based data pipelines on AWS for its Institutional Life unit. The role emphasizes ETL/ELT development, data analysis, dashboards, and data-quality governance in a regulated environment.

The position requires SQL, Python, and proficiency with AWS services (S3, Glue, Lambda, Step Functions, Athena, Redshift, Aurora PostgreSQL). Hybrid work arrangement in Overland Park, KS is offered.

Qualifications

• Working knowledge of AWS data services, ETL/ELT concepts, SQL, Python, and relational or non-relational data sources.
• Familiarity with financial-services or insurance data — policy administration, premium payments, or reconciliation workflows — is a plus.
• You can analyze technical problems and communicate clearly with engineers, actuaries, and business partners in a regulated environment.

Responsibilities

• Develop and maintain ETL/ELT data pipelines using AWS services (S3, Glue, Lambda, Step Functions, Athena, Redshift, Aurora PostgreSQL).
• Write and maintain SQL queries to analyze datasets and support reporting and analytics; develop dashboards and reports.
• Follow data governance, security, privacy, validation, and data-quality standards; monitor data workflows and resolve issues.

Skills

SQL

Python

ETL/ELT concepts

Data analysis

Data governance

Tools

S3

Glue

Lambda

Step Functions

Athena

Redshift

Aurora PostgreSQL

RDS

Job description

Location Designation

Hybrid - 3 days per week

Business Unit Overview

The Institutional Life (IL) business provides sophisticated life insurance solutions for the Bank-Owned Life Insurance (BOLI), Corporate-Owned Life Insurance (COLI), and Institutional COLI (ICOLI) markets. These solutions are designed to help organizations attract, retain, and reward highly compensated executives and professionals.

Role Overview

The AWS Data Engineer supports the development, maintenance, and analysis of cloud-based data solutions on AWS within the Institutional Life (IL) business at New York Life. Working within established technical standards and with moderate guidance from senior engineers or technical leads, this role develops and maintains data pipelines, performs data analysis, supports dashboards and reporting, and monitors data quality. The position applies knowledge of AWS data services, SQL, and Python to solve data engineering and analytical problems in the context of BOLI, COLI, and ICOLI product administration — while continuing to build higher-level technical capabilities.

What You’ll Do

• Develop and maintain ETL/ELT data pipelines using established designs, standards, and AWS services such as S3, Glue, Lambda, Step Functions, Athena, Redshift, and Aurora PostgreSQL. Support data ingestion and transformation from approved sources — including Salesforce, REST APIs, and legacy mainframe feeds — and troubleshoot routine pipeline and data-processing issues.
• Write and maintain SQL queries to analyze datasets and support defined business reporting and analytical requirements. Develop and maintain dashboards and reports using approved visualization tools such as AWS Quick.
• Follow established data governance, security, privacy, validation, error-handling, and data-quality standards. Monitor AWS data workflows and services using established monitoring procedures; resolve routine issues and elevate complex problems.
• Assist with data storage, pipeline performance, reliability, and cost-optimization efforts using established practices. Document technical configurations, data workflows, operating procedures, and troubleshooting steps.
• Collaborate with engineers, analysts, and business partners to understand defined requirements and complete assigned solutions. Work with moderate guidance, seeking direction for new, ambiguous, architectural, or complex assignments.

What You’ll Bring

• Working knowledge of AWS data services, ETL/ELT concepts, SQL, Python, and relational or non-relational data sources. Familiarity with financial-services or insurance data — policy administration, premium payments, or reconciliation workflows — is a plus. You can analyze technical problems using established practices and communicate clearly with engineers, actuaries, and business partners in a regulated‑industry environment.

Required Skills

• 2+ years of relevant experience in data engineering, data analytics, cloud data technologies, or a related discipline, or an equivalent combination of education and experience.
• Working knowledge of core AWS data services such as S3, Glue, Lambda, Step Functions, Athena, Redshift, Aurora PostgreSQL, and RDS, plus ETL/ELT concepts and data-processing practices appropriate to insurance and financial‑services data.
• Proficiency with SQL and working knowledge of Python for data processing or automation.
• Experience with relational and/or non‑relational data sources and the ability to create or maintain dashboards and reports using a visualization platform.
• Understanding of basic cloud security, IAM, encryption, data quality, and governance concepts.
• Ability to analyze straightforward technical problems using established practices and communicate technical information clearly.

Preferred Skills

• Exposure to Terraform or another infrastructure‑as‑code tool for managing AWS resources.
• Exposure to AWS Step Functions for workflow orchestration, Apache Spark, EMR, or CI/CD practices.
• AWS certification or equivalent cloud training.
• Familiarity with AWS generative‑AI services, including Amazon Bedrock and Bedrock AgentCore, for agentic or analytics use cases

Pay Transparency

Salary Range: $80,000 - $105,000

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.

Company Overview

At New York Life, our 180-year legacy of purpose and integrity fuels our future. As we evolve into a more technology-, data-, and AI-enabled organization, we remain grounded in the values that drive lasting impact.

Our diverse business portfolio creates opportunities to make a difference across industries and communities—inviting bold thinking, collaborative problem-solving, and purpose-driven innovation. Here, you’ll find the rare balance of long-standing stability and forward momentum, supported by an inclusive team that honors tradition while embracing progress.

As a Fortune 100 mutual company, we offer a place to grow your skills, contribute to meaningful work, and deliver solutions that matter. Your ideas drive what’s next, and your growth powers it.

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.

Our Commitment to Inclusion

At New York Life, fostering an inclusive workplace is fundamental to who we are and how we serve our communities. We have a longstanding commitment to creating an environment where individuals can contribute their best and succeed together. This foundation is rooted in our core values of humanity and integrity, ensuring that every employee feels valued and supported. By embracing a broad range of perspectives and experiences, we achieve greater success and fulfill our promise of providing financial security and peace of mind to families across all communities.

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.

Visit our LinkedIn to see how our employees and agents are leading the industry and impacting communities.

Visit our Newsroom to learn more about how our company is constantly evolving to meet our clients' and employees’ needs.

#LI-SV1 #LI-HYBRID