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 exp