Hybrid role in Overland Park, KS supporting data engineering for New York Life’s Institutional Life business. You’ll build and improve AWS-based data solutions that help teams deliver reliable analytics and reporting, working with established designs, standards, and modern AWS services. This position offers a $80,000 to $105,000 salary range, discretionary bonus eligibility, and access to a broad set of employee benefits, including leave programs, adoption assistance, and student loan repayment programs.
What you’ll do
- Develop and maintain ETL/ELT data pipelines using approved designs and AWS services including 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 analytics needs.
- 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 escalate complex problems when needed.
- Support 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 deliver assigned solutions.
- Work with moderate guidance, seeking direction for new, ambiguous, architectural, or complex assignments.
What you bring
- 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: S3, Glue, Lambda, Step Functions, Athena, Redshift, Aurora PostgreSQL, and RDS, along with 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 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, IAM, encryption, data quality, and governance concepts.
- Ability to analyze straightforward technical problems using established practices and communicate technical information clearly.
Technologies you may work with
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 - $105,000
- Overtime eligible: Exempt
- Discretionary bonus eligible: Yes
- Sales bonus eligible: No
- Employees are eligible for an annual discretionary bonus
- Click here to discover more about comprehensive benefit options or visit the NYL Benefits Site
- Leave programs
- Adoption assistance
- Student loan repayment programs
