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