Manager, Data Integration

Overview

Manages the Enterprise Data Integration platform that serves the reporting and analytical needs for VN Health, as well as IT consumers. Responsible for Service Delivery Life Cycle (SDLC) of Data Integration projects including managing and preparing detailed technical design documents from functional requirement documents, designing and developing ETL (Extract, Transform and Load) framework, establishing DB application schemas and developing database code, leading the unit and system testing of end-to-end integration, and performing release management and production support as needed. Works under general supervision.

What We Provide

• Referral bonus opportunities
• Generous paid time off (PTO), starting at 30 days of paid time off and 9 company holidays
• Health insurance plan for you and your loved ones, Medical, Dental, Vision, Life and Disability
• Employer-matched retirement saving funds
• Personal and financial wellness programs
• Pre-tax flexible spending accounts (FSAs) for healthcare and dependent care
• Generous tuition reimbursement for qualifying degrees
• Opportunities for professional growth and career advancement
• Internal mobility, generous tuition reimbursement, CEU credits, and advancement opportunities

What You Will Do:

• Manages the ongoing implementation and maintenance of VNS Health’s Enterprise Data Integration Platform, delivering data sharing, data movement, and data warehouse capabilities. Responsible for developing, testing, and managing the data warehouse using extracts from VNS Health’s various data sources.
• Creates end-to-end ETL solutions involving Informatica workflows and mappings, Oracle PL/SQL procedures and functions, and Unix shell scripting to load VNS Health data from disparate source systems into the Operational Staging, Warehouse, and Reporting layers of the Data Lake stack.
• Participates in planning, organizing, and coordinating departmental activities and responsibilities, including developing overall project plans and timelines.
• Manages and supports the user community and Information Systems Development groups. Leads, guides, and provides technical support and training to data warehouse development staff.
• Provides technical consultation to users of various data warehouses and advises on data conflicts and inappropriate data usage.
• Develops solution prototypes, prepares test scripts, and conducts testing for data replication, extraction, loading, cleansing, and data modeling within the data warehouse environment.
• Maintains knowledge of software tools, programming languages, scripts, and shells that effectively support data warehouse operations across different operating systems.
• Oversees unit and system testing of ETL and data warehouse jobs, ensuring adherence to established Quality Assurance standards and practices. Promotes fully tested and approved code into higher environments.
• Establishes standards and strategies in collaboration with IT and VNS Health leadership for website and corporate intranet planning and development.
• Performs all responsibilities inherent in a managerial role, including ensuring effective staff training, evaluating employee performance, contributing to departmental budget development, and making decisions regarding hiring, promotions, terminations, and salary adjustments, as appropriate.
• Participates in special projects and performs other duties as assigned

Qualifications

Education:

Bachelor's Degree in Computer Science, Information Systems, or a related field of Engineering required

Work Experience:

• Minimum of five years of experience in managing Data Integration projects working on ETL framework for Data Warehouse projects, preferably using Snowflake, Python, Airflow and AWS cloud environment required
• Hands on experience creating mappings, mapplets, sessions, workflows, and worklets required
• Experience with performance tuning techniques on mapping and session levels (DTM buffer/block size configurations, partitioning and etc.) required
• Working experience in using parameters and variables required
• Hands on experience in writing complex SQL queries and performance tuning of SQLs required
• Experience in Unix shell scripting required
• Experience with Advanced Scheduling tools such as Autosys, Airflow, Control-M, etc. preferred
• Working knowledge of data modeling, and understating various aspects of logical, conceptual and physical modeling of data warehouse projects required
• Ability to work independently, take initiative and contribute to new ideas required

Pay Range

USD $109,900.00 - USD $146,500.00 /Yr.

About Us

VNS Health has been committed to meeting the needs of New Yorkers for over 130 years. We’re one of the largest nonprofit home- and community-based health care organizations in the country, and today, more than 11,500 team members work together to make a difference in the lives of more than 99,000 patients and members on any given day. What We Provide

• Referral bonus opportunities
• Generous paid time off (PTO), starting at 30 days of paid time off and 9 company holidays
• Health insurance plan for you and your loved ones, Medical, Dental, Vision, Life and Disability
• Employer-matched retirement saving funds
• Personal and financial wellness programs
• Pre-tax flexible spending accounts (FSAs) for healthcare and dependent care
• Generous tuition reimbursement for qualifying degrees
• Opportunities for professional growth and career advancement
• Internal mobility, generous tuition reimbursement, CEU credits, and advancement opportunities

What You Will Do:

• Manages the ongoing implementation and maintenance of VNS Health’s Enterprise Data Integration Platform, delivering data sharing, data movement, and data warehouse capabilities. Responsible for developing, testing, and managing the data warehouse using extracts from VNS Health’s various data sources.
• Creates end-to-end ETL solutions involving Informatica workflows and mappings, Oracle PL/SQL procedures and functions, and Unix shell scripting to load VNS Health data from disparate source systems into the Operational Staging, Warehouse, and Reporting layers of the Data Lake stack.
• Participates in planning, organizing, and coordinating departmental activities and responsibilities, including developing overall project plans and timelines.
• Manages and supports the user community and Information Systems Development groups. Leads, guides, and provides technical support and training to data warehouse development staff.
• Provides technical consultation to users of various data warehouses and advises on data conflicts and inappropriate data usage.
• Develops solution prototypes, prepares test scripts, and conducts testing for data replication, extraction, loading, cleansing, and data modeling within the data warehouse environment.
• Maintains knowledge of software tools, programming languages, scripts, and shells that effectively support data warehouse operations across different operating systems.
• Oversees unit and system testing of ETL and data warehouse jobs, ensuring adherence to established Quality Assurance standards and practices. Promotes fully tested and approved code into higher environments.
• Establishes standards and strategies in collaboration with IT and VNS Health leadership for website and corporate intranet planning and development.
• Performs all responsibilities inherent in a managerial role, including ensuring effective staff training, evaluating employee performance, contributing to departmental budget development, and making decisions regarding hiring, promotions, terminations, and salary adjustments, as appropriate.
• Participates in special projects and performs other duties as assigned

Education:

Bachelor's Degree in Computer Science, Information Systems, or a related field of Engineering required

Work Experience:

• Minimum of five years of experience in managing Data Integration projects working on ETL framework for Data Warehouse projects, preferably using Snowflake, Python, Airflow and AWS cloud environment required
• Hands on experience creating mappings, mapplets, sessions, workflows, and worklets required
• Experience with performance tuning techniques on mapping and session levels (DTM buffer/block size configurations, partitioning and etc.) required
• Working experience in using parameters and variables required
• Hands on experience in writing complex SQL queries and performance tuning of SQLs required
• Experience in Unix shell scripting required
• Experience with Advanced Scheduling tools such as Autosys, Airflow, Control-M, etc. preferred
• Working knowledge of data modeling, and understating various aspects of logical, conceptual and physical modeling of data warehouse projects required
• Ability to work independently, take initiative and contribute to new ideas required