Senior Associate - Data Engineer

New York Life Insurance Co•New York, NY

2d•$124,000 - $177,000•Hybrid

About The Position

Our New York Life culture has laid the foundation for over 175 years of commitment to our employees, agents, policy owners, and the communities where we live and work. Here you become a valued part of a welcoming, inclusive, and caring organization with a long-standing legacy in stability and growth. The strength revolves around our diversified, multi-dimensional business portfolio that goes beyond life insurance. As a Fortune 100 company and industry leader, we provide an environment where you can explore your career ambitions, offering opportunities to tackle meaningful challenges and stretch your skills while balancing work and life priorities. You will be part of an inclusive team guided by our belief to always be there for each other–providing the support and flexibility to grow and reach new heights while making an impact in the lives of others. At New York Life, we value career development, collaboration, innovation, and inclusiveness. Our culture supports both virtual and in-person interactions, providing opportunities for personal and professional growth. Join us to be part of a company committed to doing the right thing and making a positive impact. We are seeking a Database Engineer to join the team managing a critical application. The ideal candidate will have hands-on experience developing and maintaining database solutions using both SQL and NoSQL technologies. You will be responsible for writing and optimizing database queries, developing stored procedures, functions, and views, and supporting application development through robust data models. Additional responsibilities include implementing data validation rules, ensuring data integrity and performance, and collaborating closely with application developers and analysts to translate business requirements into scalable database solutions. A strong foundation in relational database design, scripting, and performance tuning is essential, along with familiarity with cloud-based database platforms.

Requirements

6+ years’ experience as a developer with the following qualifications.
Experience in build business logic using SQL, stored procedures and triggers.
Experience in building Database system for High Availability
Experience working with both SQL (PostgreSQL) & NoSQL DB (Elastic Search & DynamoDB) solutions
Model & Design Database components in PostgreSQL
Develop DB Functions, Stored Procedures, Triggers
Analyze & Tune SQL scripts for handing High volume transactions
Experience enabling CDC solutions & AWS DMS
Experience working with Messaging systems AWS MSK
GitHub & CI/CD using Terraform
Monitoring and optimizing DB system performance, space utilization, data security
Strong analytical, problem solving, debugging skills.
Demonstrable experience of being able to work to very tight timelines on multiple detailed activities simultaneously
Ability to work in team in diverse environment
Good verbal and written communication and organizational skills

Nice To Haves

AWS or Industry Certification credentials and Life Insurance domain knowledge are additional plus.

Responsibilities

Implement functional requirements into efficient and maintainable database solutions (e.g. via SQL, stored procedures, triggers).
Design, model, and develop database objects such as tables, views, stored procedures, and user-defined functions that align with application logic and business needs.
Develop and optimize complex SQL queries to ensure performance, accuracy, and scalability.
Build and manage SQL and NoSQL databases, ensuring reliability, security, and data integrity across systems.
Support and implement data integration processes, including Change Data Capture (CDC) and AWS Database Migration Service (DMS) for syncing and migrating data.
Work closely with cross-functional teams to deliver consistent and reliable data services as part of broader application and analytics solutions.
Continuously monitor and tune database performance, manage storage capacity, and troubleshoot issues in a fast-paced production environment.
Leverage GitHub & CI/CD using Terraform
Identify root cause analysis leading to solutions that correct defects, security concerns or performance problems.
Establish and maintain monitoring, logging, alerting, and cost-control procedures to ensure optimal platform performance.
Work closely with Business Analysts, Architects, Engineers, DBAs, and other stakeholders to understand requirements and build flexible, scalable solutions.
Participate in quarterly on-site planning and strategy sessions.
Participate in Level 3 on-call support rotation.
Ensure systems are highly available, secure, resilient, and designed to scale efficiently.