Senior Associate, Sr Data Engineer

New York Life Insurance Company; New York (NY); Hybrid; USD 95,000 - 163,000; Full time

Job summary

An established industry player is seeking a Senior Data Engineer to design and execute a modern data management strategy. In this hybrid role, you will leverage cutting-edge technologies like AWS and Azure to build scalable data solutions that drive innovation and efficiency. You'll collaborate with talented teams to enhance data pipelines and ensure the integrity of data across various platforms. This position offers a unique opportunity to contribute to groundbreaking initiatives that shape the digital landscape while enjoying a supportive and inclusive work environment. Join a company committed to investing in your growth and making a meaningful impact in the lives of clients and communities.

Benefits

Flexible working hours

Adoption assistance

Student loan repayment programs

Leave programs

Comprehensive benefits package

Qualifications

• 8+ years of experience in enterprise-level delivery of Data Engineering solutions.
• Strong background in Operational Data Stores and Dimensional Modeling.
• Proven experience in ETL/ELT tools like AWS Glue.

Responsibilities

• Design and implement data pipelines using AWS and Azure services.
• Collaborate with teams to deliver high-quality data solutions.
• Monitor and troubleshoot data pipeline performance.

Skills

Data Engineering

AWS

Azure

Python

PySpark

ETL/ELT

SQL

Data Quality

Education

Bachelor's degree in Computer Science or Engineering

Certification in Data Management

Tools

IDMC

DBT

Redshift

Snowflake

Databricks SQL

Job description

Location Designation:Hybrid - 3 days per week

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 willbe part ofan inclusive teamguided by our belief to always be there for each other-providing the support and flexibilityto 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 LinkedIn to see how our employees and agents are leading the industry and impacting communities.

Visit our Newsroom to learn more about how our company is constantly evolving to meet our clients' and employees' needs.

As part of AI&D, you'll have the opportunity to contribute to groundbreaking initiatives that shape New York Life's digital landscape. Leverage cutting-edge technologies like Generative AI to increase productivity, streamline processes, and create seamless experiences for clients, agents, and employees. Your expertise fuels innovation, agility, and growth - driving the company's success.

Role Overview:

We are seeking energetic and passionate Senior Data Engineer to design and execute our company's modern data management strategy. As a key member of Enterprise Data Platform team, you will work with talented engineers, architects, data scientists and end users to reimagine, design and build the next generation of Insurance solutions in the cloud leveraging nascent and modern technologies and platforms including AWS and Azure cloud, APIs, and AI. You will be responsible for the design, development and deployment of optimal data pipelines taking advantage of leading-edge technologies through experimentation and iterative refinement. You will assist other team members in building and executing automation that effectively and repeatably ensures quality, security, integrity and maintainability of our solutions. You will also be responsible for the evaluation of existing data pipeline architecture, evolve and enhance the foundation, participate in product ideation and technology stack evaluation and recommendations

What You'll Do:

• Engages in collaborative relationships across architecture, product management, data and product delivery teams to design, implement solutions based on defined business challenges and outcomes
• Participateonscrum teams working in short sprints and ensureon time deliverywith high quality
• Build and maintain Data engineering solutions on cloud platforms using AWS or Azure services.
• Design, develop, and implement scalable data transformations and ETL/ELT processes using Python, PySpark, and or Data Integration tools IDMC, DBT
• Collaborate with Data Architects and Data analysts to understand data requirements and translate them into scalable, high performant data integration and pipeline solutions.
• Develop and maintain data models and schemas to support data integration and analysis
• Monitor and troubleshoot data pipeline performance, identifying and resolving bottlenecks and issues
• Optimize and tune data integration pipelines for performance, reliability, and scalability
• Implement data quality and validation checks to ensure accuracy and integrity of data through testing
• Build the infrastructure required for optimal ETL/ELT of data from a wide variety of data sources using SQL and AWS big data technologies
• Develop and debug code in PySpark/Spark/Python. Strong SQL and query optimization techniques
• Maintaining high degree of knowledge and expertise in cloud-based technologies contributing to go forward best practices, standards and patterns
• Active participant in relevant communities of practice to exchange ideas and knowledge

What You'll Bring:

• Eight or more years of experience in enterprise-level delivery of Data Engineering solutions.
• Deep understanding of modern data architecture, including experience with data lakes, data warehouses, data marts, relational and dimensional modeling, data quality, and master data management.
• Strong background in Operational Data Stores, Dimensional Modeling, and supporting application data architecture. Experience with Redshift, Snowflake, Databricks SQL, Oracle, Postgres, MySQL, and understanding of best practice architectural concepts for relational data models.
• 8 + Years of design and implementation of ETL/ELT framework for complex warehouses/data marts.
• Proven experience in ETL/ELT tools IDMC, DBT, AWS Glue.
• Proficiency with languages such as Python, PySpark
• Strong knowledge on AWS Cloud technologies.
• Strong, demonstratable hands-on experience with data engineering and data pipelines
• Proficient in cloud architecture and best practices, particularly with AWS Cloud tools such as Amazon RDS, Redshift, AWS DMS, AWS Glue, Amazon S3, AWS Lambda, and more.
• Hands-on development mentality, with a willingness to troubleshoot and solve complex problems.
• Identify, recommend, and implementELT processes and architectureimprovements.
• Assist and verify design of solution and production of all design phase deliverables.
• Bachelor's degree in computer science or an Engineering discipline
• Certification in data management (structure and unstructured), and/or cloud architecture or engineering a plus
• Certification in delivery methodologies such as Scaled Agile a plus

Pay Transparency

Salary Range:$95,000-$162,500

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.Click hereto discover more about our comprehensive benefit options or visit our NYL Benefits Site.

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. Click here 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 theFoundation.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 Careers page of www.NewYorkLife.com.

Job Requisition ID:91574