Senior Associate, Data Engineer
New York, NY, US
New York Life Insurance Co
Protect and build your future with comprehensive one-on-one guidance from New York Life. Learn about our life insurance and financial product offerings.Job Requisition ID: 91765
Location Designation: Fully Onsite
Location: 51 Madison Avenue, New York, New York 10010, position allows telecommute option.
Offered Wage: $170,373.00/year
Duties: Support Software Developers, Database Architects, Data Analysts, and Data Scientists related to data initiatives and ensures data design and delivery is consistent for business and technical efforts. Identify, design, and implement internal process improvements for greater scalability, optimize data delivery, and automate manual processes. Work with Data, Design, and Product stakeholder teams and executive teams and assists with resolving data-related technical issues. Expand and optimize data and data pipelines and optimizes data flow and collection for cross-functional teams. Work with stakeholders to support their data infrastructure needs while assisting with data-related technical design efforts. Assemble large, complex data sets that meet non-functional and functional business requirements. Build required infrastructure for optimal data extraction, transformation, and loading (ETL) from multiple data sources leveraging SQL technologies. Build analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics, including operational efficiency and customer acquisition.
Education & Experience Requirements: Master’s degree or foreign education equivalent in computer science, Engineering Management, Information Technology,
or
a related field plus three (3) years of experience as a Senior Associate, Data Engineer, or related occupation designing, developing, and implementing data solutions to solve business and technical challenges within the annuity and financial services industries or, alternatively, employer is willing to accept a Bachelor's degree or foreign education equivalent in Computer Science, Engineering Management, Information Technology , or related field and five (5) years of experience as a Senior Associate, Data Engineer, or related occupation designing, developing, and implementing data solutions to solve business and technical challenges within the annuity and financial services industries. Must also possess two (2) years in each of the following skills: (1) Writing annuity-specific business applications to execute critical create, read, update, and delete (CRUD) operations related to annuity data warehouses leveraging SQL, SQL Server, and Oracle relational databases to support the development of annuity administration system rules and system transactional logics; (2) Creating database objects (including entities, attributes, constraints, relationships, and joins) and relational database designs (including normalization) to support future business enhancements to the annuity administration system database leveraging MySQL and SQL Server relational database management systems and Amazon DynamoDB non-relational database management system; (3) Providing fixed deferred annuities, variable deferred annuities, and immediate annuities and Oracle and SQL database technology subject matter expertise for existing database designs, data elements, and annuity administration systems operation to business and software development teams to facilitate seamless design, development, troubleshooting, and system enhancements for day-to-day business needs; (4) Generating metrics-monitoring applications and dashboards to enable business and development teams to make data-driven decisions to improve current system performance and support future updates to the annuity administration and data warehouse leveraging Oracle, MySQL, SQL Server, and PostgreSQL relational databases, and Tableau and Qlik business intelligence (BI) reporting and data discovery tools; and (5) Writing relational database management system (RDBMS) annuity administration systems data warehouse queries leveraging data definition language (DDL), data manipulation language (DML), and data query language (DQL) to retrieve current data, update the database to understand existing system behavior, support future business needs, and perform administration system updates.
Position allows telecommute option.
Eligible for Employee Referral Program.
Overtime eligible: Exempt
Discretionary bonus eligible: Yes
Sales bonus eligible: No
Pay Transparency
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 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 the Foundation. 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: 91765
Tags: Business Intelligence Computer Science Data pipelines Data warehouse DDL DynamoDB Engineering ETL MySQL Oracle Pipelines PostgreSQL Qlik RDBMS Security SQL Tableau
Perks/benefits: Career development Salary bonus
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.