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. 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.
Numbers & Facts
Location
New York, New York
Job Type
Full-time
Salary
$109,900–$146,500 Per Year
Description
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.
Responsibilities:
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