Senior ETL Lead

4 weeks ago

Lebanon, New Jersey, United States New York Life Insurance Company Full time
Senior ETL Lead Opportunity at New York Life Insurance Company

We are seeking a highly skilled Senior ETL Lead to join our Corporate Finance Technology function at New York Life Insurance Company. As a key member of our team, you will be responsible for delivering end-to-end ETL solutions and enhancements for various initiatives, ensuring re-use, scalability, reliability, and alignment with our company's vision and strategy.

Key Responsibilities:
  • Work closely with Business Analysts and Data Modelers to review business requirements, understand business processes, data entities, data producers, consumers, and data dependencies between departments.
  • Balance various and conflicting support priorities, applying data analysis, data modeling, and quality assurance techniques to establish, modify, or maintain data structures and associated components.
  • Design, code, test, correct, and document complex programs or processes and scripts from agreed specifications, using agreed standards and tools, to achieve a well-engineered result.
  • Oversee team activities related to coding, unit testing, system testing, resolve defects originating during system test, and deploy fixes for defects when needed.
  • Investigate production data issues and provide workarounds/fixes for 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 efforts & projects.
Requirements:
  • 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.
What We Offer:
  • 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 a 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.

  • Senior Associate

    4 weeks ago

    Lebanon, New Jersey, United States New York Life Insurance Company Full time

    As a key member of the Technology team at New York Life, you will have the opportunity to contribute to groundbreaking initiatives that shape the company's digital landscape.Leverage cutting-edge technologies like Generative AI to increase productivity, streamline processes, and create seamless experiences for clients, agents, and employees.We are currently...

  • Senior Database Developer

    3 weeks ago

    Lebanon, New Hampshire, United States Dartmouth-Hitchcock Health Full time

    Job SummaryAs a Senior Database Developer at Dartmouth-Hitchcock Health, you will be responsible for designing and developing Enterprise Data Warehouse components. This role requires collaboration with business and technology departments to understand system data and its use, and providing support around the data and how it is integrated within the EDW...

  • Senior Accounting Professional

    1 week ago

    Lebanon, New Jersey, United States Vaco Full time

    Senior Accountant Job OverviewVaco is working with a leading financial institution that seeks a skilled Senior Accountant to fill a key role in their accounting and finance team due to growth.The ideal candidate will have a strong understanding of GAAP and experience with Fiserv Prologue and Premier Navigator, with at least 2 years of accounting experience....

  • Senior Software Engineer

    2 weeks ago

    Lebanon, New Hampshire, United States Focus Staff Full time

    About the RoleWe are seeking a skilled Senior Software Engineer to join our team and contribute to the development of cutting-edge technology solutions.As a key member of our software development team, you will be responsible for designing, developing, and testing complex software systems.Key ResponsibilitiesDesign and develop software applications using a...

  • Senior Manufacturing Engineer

    3 weeks ago

    Lebanon, New Hampshire, United States strategic HR inc. Full time

    Job Title: Senior Manufacturing EngineerCompany Description: Strategic HR Inc. is a leading provider of innovative solutions for manufacturing and engineering. Our team is dedicated to delivering high-quality products and services that meet the needs of our clients.Career Opportunity: We are seeking a highly skilled Senior Manufacturing Engineer to join our...

  • Senior Associate

    3 weeks ago

    Lebanon, New Hampshire, United States New York Life Insurance Company Full time

    Job Summary:We are seeking a highly skilled QA Test Lead to lead our quality assurance practice within the Field Productivity value stream at New York Life Insurance Company.The ideal candidate will have a strong background in software testing, leadership experience, and a passion for quality.Key Responsibilities:Lead and mentor a team of QA engineers,...

  • Senior DevOps Engineer

    4 weeks ago

    Lebanon, New Hampshire, United States 5PY US Quintiles, Inc. Full time

    Job OverviewAs a Senior DevOps Engineer at 5PY US Quintiles, Inc., you will be responsible for designing, architecting, and implementing technologies that underpin the IQVIA Clinical eSource platform. You will create and manage standardized software development environments, develop automated systems for deployment, monitoring, and fault tolerance, and...

  • Senior Salesforce Administrator

    3 weeks ago

    Lebanon, New Hampshire, United States StepStone Group Full time

    Job Description:The Senior Salesforce Administrator will be responsible for maintaining, implementing, and configuring Salesforce to meet the company's objectives. This role will partner with cross-functional teams to provide technical support and generate data-driven insights to drive business growth.Key Responsibilities:Execute a comprehensive Salesforce...

  • Senior Associate

    3 weeks ago

    Lebanon, New Hampshire, United States New York Life Insurance Company Full time

    Job Title: Senior Associate - Agile Project ManagerAt New York Life Insurance Company, we are seeking a highly skilled Senior Associate - Agile Project Manager to join our team. As a key member of our Technology Value Stream, you will play a critical role in driving projects from inception to completion using SAFe agile methodology and tools.Key...

  • Clinical Secretary, Senior

    3 weeks ago

    Lebanon, New Hampshire, United States Dartmouth-Hitchcock Health Full time

    Job SummaryThe Dartmouth-Hitchcock Health team is seeking a highly skilled and experienced Senior Clinical Secretary to join their Occupational & Environmental Health team. As a key member of the team, the successful candidate will provide independent standard administrative support, advanced and confidential secretarial work, and a wide range of customer...

  • Senior Associate

    3 weeks ago

    Lebanon, New Hampshire, United States New York Life Insurance Company Full time

    Job SummaryNew York Life Insurance Company is seeking a highly skilled Senior Associate Automation Test Engineer to lead our Corporate Systems Development division. As a key member of our team, you will be responsible for designing and developing automation frameworks, tests, and scripts to validate the functionality, accuracy, and efficiency of our...

  • Senior Process Engineer

    3 weeks ago

    Lebanon, New Hampshire, United States LHH Full time

    LHH is seeking a highly skilled Senior Process Engineer to join their team in a manufacturing setting near Lebanon, IN.This is an opportunity to make a strong impact in process engineering, new product development, tooling, and more.The compensation is commensurate to experience and will range between $110,000-125,000 per year plus bonus and includes...

  • Senior Human Resources Manager

    3 weeks ago

    Lebanon, New Hampshire, United States Thermo Fisher Scientific Full time

    Job Summary:The Senior HR Manager will serve as the site HR lead for our Tennessee sites, partnering with the Site Leadership Teams and reporting functionally to Field HR organization. This role will be based at our manufacturing facility in Nashville, TN, and provide support to Memphis, TN, and Rockwood, TN.Key Responsibilities: Provides HR expertise,...

  • Senior Industrial Engineer

    4 weeks ago

    Lebanon, New Hampshire, United States FUJIFILM Dimatix, Inc Full time

    Job SummaryFujifilm Dimatix, Inc. is seeking a highly skilled Senior Industrial Engineer to join our team. As a key member of our manufacturing department, you will be responsible for developing and maintaining equipment and labor capacity models. Your expertise in lean systems and Six Sigma will drive operational excellence in manufacturing, and you will be...

  • Senior Clinician Investigator in Intervention and Health Care Delivery Science

    4 weeks ago

    Lebanon, New Hampshire, United States Dartmouth-Hitchcock Health Full time

    OverviewThe Department of Psychiatry at Dartmouth-Hitchcock Health is seeking a mid-career or Senior Clinician Investigator and faculty member with an established research program in interventions, health care delivery science, or implementation science.This position involves three main components:Research: Lead and continue to build a successful program of...

  • Corporate Vice President of Technology Delivery

    4 weeks ago

    Lebanon, New Jersey, United States New York Life Insurance Company Full time

    Job SummaryWe are seeking a highly skilled Technology Delivery Lead to join our team within the Client Prospecting Value Stream. This role is focused on developing and executing a multi-year roadmap that drives shared outcomes across the business and technology.The successful candidate will oversee and partner with talented analysts, architects, and...

  • Senior Production Supervisor

    3 weeks ago

    Lebanon, New Hampshire, United States Hillandale Farms Full time

    Hillandale Farms Job Description:Job Title: Lead Processing AssociateIn this role at Hillandale Farms, you will be responsible for overseeing the daily activities of the Shell Egg Processing Plant. This includes managing staffing, working with USDA and maintenance personnel, and leading employees in a professional and respectful manner.Key...

  • Program Manager

    3 weeks ago

    Lebanon, New Hampshire, United States Dartmouth Health Full time

    Job SummaryThe Clinical Project Coordinator will be responsible for the management and successful execution of various projects designed to grow the clinical and translational research enterprise at Dartmouth Health. This role involves managing multiple projects, liaising with internal and external stakeholders, reporting to SYNERGY leadership in a matrixed...

  • Program Manager for Clinical and Translational Research

    3 weeks ago

    Lebanon, New Hampshire, United States Dartmouth Health Full time

    Job Summary:The Project Manager for SYNERGY at Dartmouth Health is responsible for the management and successful execution of various projects designed to grow the clinical and translational research enterprise at Dartmouth Health, Dartmouth College, the White River Junction Veterans Hospital, and affiliated institutions.This role involves managing multiple...

  • Hospice Care Navigator

    3 weeks ago

    Lebanon, New Hampshire, United States Otterbein SeniorLife Full time

    Job DescriptionAt Otterbein SeniorLife, we are seeking a skilled Hospice Care Navigator to join our team. The ideal candidate will have a strong background in sales and marketing, with a passion for delivering exceptional care to seniors.Key Responsibilities:Develop and manage a contact and leads database to drive sales and growth.Establish relationships...