Senior Associate - Data Engineer
Role details
Job location
Tech stack
Job description
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. Key Responsibilities:
- Design and Develop Solutions:
- 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.
Platform Management and Optimization:
- 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.
Collaboration and Continuous Improvement:
- 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.
Support and Maintenance:
- Participate in Level 3 on-call support rotation.
- Ensure systems are highly available, secure, resilient, and designed to scale efficiently.
Requirements
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., * 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
- AWS or Industry Certification credentials and Life Insurance domain knowledge are additional plus.
Bachelor's degree in Computer Engineering, Computer Science, MIS, or a related field preferred but not required Job Level: LEVELPF4
Benefits & conditions
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., Salary Range: $124,000-$177,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. 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. to discover more about our comprehensive benefit options or visit our .