Senior Associate - Data Engineer

New York, Inc.
Lebanon, NJ, United States
16 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
6 years minimum
Compensation
$124,000.0 - $177,000.0
Working hours
Regular working hours

Tech stack

Amazon Web Services Business Analytics Applications Business Logic Cloud Database Databases Computer Engineering Continuous Integration Data as a Services Data Validation Data Integration Data Integrity Data Migration
+22 more
Data Security Relational Databases Software Debugging Amazon DynamoDB Elasticsearch Github PostgreSQL Enterprise Messaging Systems NoSQL Performance Tuning Software Engineering SQL Stored Procedures SQL Databases Data Logging Scripting Freeform SQL System Availability Database Performance Change Data Capture Database Migration Information Technology Terraform

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 .

About the company

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. to learn more about New York Life’s leadership in this space. 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 . 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 page of . Job Requisition ID: 94086

About NY Life Insurance Company Diversity & Humanity-two values that are deeply rooted in the New York Life culture and have laid the foundation for over 175 years of commitment to our employees, agents, policy owners, and the communities where we live and work. At New York Life you become a valued part of a welcoming, inclusive, and caring culture that has a long-standing legacy in stability and growth. The strength of New York Life revolves around our diversified, multi-dimensional business portfolio that goes beyond life insurance, and we want you to be a part of our legacy. 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 a diverse 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. You are our future, and we commit to investing in you accordingly. Visit our to see how our employees and agents are leading the industry and impacting communities. Visit our to learn more about how our company is constantly evolving to meet our clients’ and employees’ needs.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

6:36 min

Funding open source through GitHub Accelerator and Sponsors

Stormy Peters · WWC 2023

1:34 min

Essential commands for running and testing Terraform configurations

Hennie Francis · LIVE

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · WWC 2021

3:16 min

Terminology differences between relational and NoSQL databases

Tim Faulkes · LIVE

Videos

See all

Related articles

See all