Corporate Vice President - Senior ETL Lead

Location Designation: Hybrid - 3 days per month

When you join New York Life, you're joining a company that values career development, collaboration, innovation, and inclusiveness. We want employees to feel proud about being part of a company that is committed to doing the right thing. You'll have the opportunity to grow your career while developing personally and professionally through various resources and programs. New York Life is a relationship-based company and appreciates how both virtual and in-person interactions support our culture.

We are currently seeking a Senior ETL Lead within the New York Life Corporate Finance Technology function to deliver end-to-end ETL solutions & enhancements for all initiatives hosted in a variety of environments while considering re-use, scalability, reliability and alignment with New York Life's vision and strategy. The role primarily be responsible for Finance Technology ETL & Integration areas. ETL Lead should have good understanding of business processes as well to influence the simplification and optimization in these functions.

You will:

• Work closely with the Business Analyst and Data Modeler to review business requirements, understand business processes, data entities, data producers, consumers, and the data dependencies between various departments.

• Balance various & conflicting support priorities

• Apply data analysis, data modelling, and quality assurance techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions).

• Design, code, test, correct and document complex programs or processes and scripts from agreed specifications, and subsequent iterations, using agreed standards and tools, to achieve a well-engineered result.

• Design and construct large ETL mappings, packages workflows.

• Gather requirements, work on high level design, implement (code) and deliver efficient and scalable DW solutions in high data growth environment.

• Oversee team activities related to coding, unit testing, system testing, resolve defect originating during system test and deploy the fixes for the defects when needed.

• Investigate production data issues and provide workaround/fixes for the issues in an SME role.

• Lead successful design and implementations of ETL processes of NYL Finance Technology ETL platform by managing expectations and risks, ensuring appropriate organizational structures, principles, tools, and responsibilities.

• Function as a bridge between technical and business audiences during solution planning, development, and deployment.

• Potentially lead the team of ETL and Integration developers & consultants and own end-to-end delivery of all the efforts &/ projects.

• Create reliable solution plans that include cost estimates and optimized delivery approaches by working with the business and multi-disciplinary teams.

Your key responsibilities

• Understand business logic and implement measures to ensure data accuracy and accessibility.

• Deliver on time and with high level quality as per SLA through project life cycle.

• Lead business intelligence application solutions delivery across multiple programs/projects in the portfolio.

• Review and analyze business requirements and provide technical feasibility and estimates with regards to data access, extracts, and transformations.

• Making modifications to existing applications and modules in accordance with written specifications.

• Work closely with the QA / Testing team to help identify/implement defect reduction initiatives.

• Work closely with the Architecture team to make sure architecture standards and principles are followed during development.

• Take part in code reviews and maintain all documentation.

• Will need to engage with Project Managers, Business Analysts and Application DBA to implement ETL Solutions.

• Must be able to multi-task between various tasks and projects.

• Ability to work across multiple projects with a variety of individuals and groups.

• Design and develop scalable integration solutions, preferably using MuleSoft.

• Coordinate with business and IT teams to ensure MuleSoft implementations align with business objectives.

• Ensure adherence to MuleSoft best practices.

• Actively participate in knowledge sharing within the team.

• Stay updated with DataStage and MuleSoft advancements and industry trends.

To qualify for the role, you must have.

• Extensive Data Warehousing Experience, having Big Data or Hadoop is a plus.

• Strong development experience with DataStage, having Big Integrate is a plus.

• Good experience with writing complex SQL, PL/SQL queries around Data Analysis, Data Lineage & Reconciliation preferably in Oracle.

• 9 + years of creating Data Lineage documents, Source to Target (STM) Mapping documents and Low-Level Technical Specification Documents.

• 9 + Years of design and implementation of ETL/ELT framework for complex warehouses/data marts.

• 6 + Years of DataStage 8.7 or Higher.

• 6 + Years of DataStage Parallel Job Design.

• Hands-on development mentality, with a willingness to troubleshoot and solve complex problems.

• Assess requirements for completeness and accuracy.

• Conduct impact assessment and determine size of effort based on requirements.

• Identify, recommend, and implement ETL processes and architecture improvements.

• Assist and verify design of solution and production of all design phase deliverables.

• Identify bugs when developers are not able to do so.

• Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture.

• Resolve difficult design and development issues.

• Drive the build and testing teams coordinating the day-to-day project activities for the team.

• Have expertise in ETL and Integration tools (preferably DataStage, AWS Glue & MuleSoft).

• Strong Oracle/MSSQL, UNIX and Windows experience.

• Led and governed a team of ETL developers working on multiple projects/products.

• Drove and maintained complex multi-year business outcome driven roadmaps.

• Strong analytical and problem-solving skills, and the ability to adapt to a fast-paced environment.

• Full life cycle software development experience.

• Keen ability to prioritize and handle multiple assignments.

Ideally, you will also have

• Bachelor's Degree or equivalent in Engineering, Computer Science, IT, Mathematics, or related field preferred

• 15+ years overall IT industry experience, with 7+ years in a Lead role.

• Experience working as an Analyst, Developer & Tech Lead for Finance applications and Financial Modeling related positions within a financial services or technology firm, life insurance industry experience is a plus.

• Considerable experience in coming up with new technical design concepts that would help in performance improvements in both ETL(DataStage) and Integration (MuleSoft) domains.

• Good working knowledge and understanding of the latest cloud computing and data technologies (like AWS Glue), business drivers, emerging computing trends, and deployment options.

Preferable to have knowledge of:

• Life Insurance Industry.

• On-site/Off-site Development Model.

• SAP and MuleSoft

#LI-KV1

Salary range: $132,500-$197,500

Overtime eligible: Exempt

Discretionary bonus eligible: Yes

Sales bonus eligible: No

Click here to learn more about our benefits. Starting salary is dependent upon several factors including previous work experience, specific industry experience, and/or skills required.

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. We invite you to bring your talents to New York Life, so we can continue to help families and businesses "Be Good At Life." To learn more, please visit LinkedIn, our Newsroom and the Careers page of www.NewYorkLife.com.

Job Requisition ID: 90429