Share of this job’s tasks that AI is already used for at work, from real usage. It is not a forecast of job loss, and a low number means no use seen yet. Source: Anthropic Economic Index.

Check how this applies to your own job

Skills this job asks for

Say which you have and which you want to build. We use it to match you to jobs like this one.

About the job

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 3 0 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.