Senior Associate, Data Engineer (White Plains, New York)

New York Life • New York, NY

1d • Onsite

About The Position

Expand and optimize data, data pipelines, data flow and collection for cross-functional teams. Support software developers, database architects, data analysts, and data scientists related to data initiatives and ensure 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 stakeholders to support data infrastructure needs and assist 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 using SQL technologies. Build analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics, including operational efficiency and customer acquisition. Work with data, design, and product stakeholder teams and executive teams and assists with resolving data-related technical issues.

Requirements

• Master's degree in Computer Science, Engineering Management, Information Technology, or a related field (willing to accept foreign education equivalent) plus three (3) years of experience in designing, developing, and implementing data solutions to solve business and technical challenges within the annuity and financial services industries.
• Alternatively, a Bachelor's degree in Computer Science, Engineering Management, Information Technology, or a related field (willing to accept foreign education equivalent) plus and five (5) years of experience in designing, developing, and implementing data solutions to solve business and technical challenges within the annuity and financial services industries.
• Experience must include 2 years in each of the following skills: 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; 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; 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; 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, 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 and update the database to understand existing system behavior and support future business needs, and perform administration system updates.

Responsibilities

• Expand and optimize data, data pipelines, data flow and collection for cross-functional teams.
• Support software developers, database architects, data analysts, and data scientists related to data initiatives and ensure 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 stakeholders to support data infrastructure needs and assist 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 using SQL technologies.
• Build analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics, including operational efficiency and customer acquisition.
• Work with data, design, and product stakeholder teams and executive teams and assists with resolving data-related technical issues.

Benefits

• Eligible for Employee Referral Program.
• Employees are eligible for an annual discretionary bonus.
• Employees may also be eligible to participate in an incentive program.
• 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.
• We continue to refine and add benefits to our offering, so that you can flourish both inside and outside of work.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level