Associate, AWS Data Engineer

Join a mission-driven team supporting cloud data solutions for New York Life’s Institutional Life (IL) business. This hybrid role in Overland Park, Kansas helps build and improve AWS-based ETL/ELT pipelines, ensure data quality, and enable reporting and dashboards that business partners can rely on.

Compensation: $80,000 to $105,000 per year. Overtime eligible: Exempt. Bonus: Annual discretionary bonus eligible. (No sales bonus.)

Hybrid work: 3 days per week in Overland Park, KS.

What you’ll do

• Develop and maintain ETL/ELT data pipelines using established designs, standards, and AWS services including S3, Glue, Lambda, Step Functions, Athena, Redshift, and Aurora PostgreSQL.
• Support data ingestion and transformation from approved sources such as Salesforce, REST APIs, and legacy mainframe feeds, including troubleshooting routine pipeline and data-processing issues.
• Write and maintain SQL queries to analyze datasets and support defined business reporting and analytical needs.
• Develop and maintain dashboards and reports using approved visualization tools, including AWS Quick.
• Apply data governance and security standards, including privacy, validation, error-handling, and data-quality requirements.
• Monitor AWS data workflows and services using established procedures, resolve routine issues, and escalate more complex problems.
• Contribute to improvements in storage, pipeline performance, reliability, and cost optimization using established practices.
• Document configurations, data workflows, operating procedures, and troubleshooting steps.
• Collaborate with engineers, analysts, and business partners to understand requirements and deliver assigned solutions.

What you bring

• 2+ years of relevant experience in data engineering, data analytics, cloud data technologies, or a related discipline, or an equivalent education and experience combination.
• Working knowledge of core AWS data services: 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.
• SQL proficiency and working knowledge of Python for data processing or automation.
• Experience working with relational and/or non-relational data sources, plus the ability to create or maintain dashboards and reports using a visualization platform.
• Understanding of basic cloud security, including IAM, encryption, data quality, and governance concepts.
• Ability to analyze straightforward technical problems using established practices and communicate technical information clearly.

Nice to have

• 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 such as Amazon Bedrock and Bedrock AgentCore for agentic or analytics use cases.

Tools and technologies

AWS, S3, Glue, Lambda, Step Functions, Athena, Redshift, Aurora PostgreSQL, RDS, SQL, Python, ETL/ELT, Salesforce, REST APIs, Amazon Bedrock, Bedrock AgentCore, Terraform, Apache Spark, EMR, CI/CD, AWS Quick, IAM, encryption.

Benefits

• Salary range: $80,000 to $105,000
• Overtime eligible: Exempt
• Discretionary bonus eligible: Yes
• Sales bonus eligible: No
• Annual discretionary bonus eligibility for employees
• Leave programs
• Adoption assistance
• Student loan repayment programs
• Access to comprehensive benefit options via the NYL Benefits Site