Location Designation:Hybrid - 3 days per month
The Enterprise Data Management team provides transformative data capabilities and solutions that serve as the core data, reporting, and analytics platform for the Insurance & Agency Group at New York Life (NYL). The Enterprise Data Management team is looking for a Data Engineer with the skills listed below.
Job Overview:
Build, expand, and optimize data pipeline architecture using Amazon Web Services cloud, Python and Pyspark. Utilize tools like Amazon Relational Database Service (AWS DMS), AWS Database Migration Service (AWS DMS), AWS Glue, Amazon Simple Storage Service (AWS S3), AWS Lambda triggers & functions, etc. Leverage Data Engineering strategies, Data Lake/Lakehouse/Data Warehouse technologies, and streaming/real-time data to bring data into the ecosystem for consumption. Use SQL for data analysis.
What You'll Do:
- Design and develop enterprise infrastructure and platforms required for data engineering.
- Use AWS Cloud technologies to support data needs for expansion of Machine Learning/Data Science capabilities, applications/mobile apps/systems, BI/analytics, and cross-functional teams.
- Create methods and routines to transition data from on-premise systems to the AWS Cloud.
- Store data in AWS Cloud platform and develop transformational logic based on business rules.
- Create and maintain optimal data pipeline architecture. Test and implement data environments.
- Assemble large, complex data sets to meet functional/non-functional business requirements.
- Build the infrastructure required for optimal ETL/ELT (extraction, transformation, and loading) of data from a wide variety of data sources using SQL and AWS big data technologies.
- Utilize AWS Cloud tools like Amazon Relational Database Service (AWS DMS), AWS Database Migration Service (AWS DMS, AWS Glue, Amazon Simple Storage Service (AWS S3), AWS Lambda triggers & functions, to ingest data sets and create pipelines.
- Develop and debug code in PySpark/Spark/Python. Use SQL and/or Postgres.
- Use Data Pipeline, workflow management, and orchestration service tools.
- Comfortable with SQL for data analysis.
- Collaborate with Cloud Data Architects, Data Engineers, DBAs, Analytics & Software Engineers.
- Interact with stakeholders, Product Management, and Design teams to understand data pipeline requirements, design solutions, and resolve issues.
What You'll Bring:
- 1-3 years as a Cloud Data Engineer, Data Engineer, Data Architect, AWS Engineer, etc.
- 1-3 years with Amazon Relational Database Service (RDS), AWS Database Migration Service (AWS DMS), Amazon Simple Storage Service (S3) Data Lake, AWS Lambda, etc. in shared service, hybrid environments.
- Highly scalable Data stores, Data Lake, Data Warehouse, Lakehouse, and unstructured datasets.
- Data integration, data processing, data streaming, message queuing, and/or ETL/ELT.
- Ability to lead a team of developers.
- Bachelor's degree in Data Science, Computer Engineering, or related field preferred.
#LI-KV1
Pay Transparency
Salary Range:$62,400-$102,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 here to discover more about our comprehensive benefit options or visit our NYL Benefits Site.
Our Diversity Promise
We believe in a diverse workforce because it is our mission to advocate for the financial security and success of people in every community. This is why diversity, equity, and inclusion (DEI) are guiding principles that are embedded in our brand and our culture. Click here to learn more about how we have been recognized for our leadership.
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:91050