Project DescriptionThe Data Integration Lead is responsible for leading the data integration (ETL) development for data warehouse solutions that deliver diverse reporting and analytic capabilities to health and human services customers in the public and private sector. This role oversees the team that develops data integration programs that load, transform and extract data from the data warehouse, and assures that architecture and development follow data warehouse best practices. This individual works with DW architects, data architects, hardwaresoftware engineers, DBAs, application vendors and managed services to ensure enterprise DW solutions are reliable, scalable, flexible and low maintenance. This position requires a bachelor's degree or equivalent experience. The candidate must demonstrate expertise in data warehouse concepts, practices, and procedures, has technical hands on experience implementing data warehouse solutions, has lead teams responsible for ETL development, and demonstrates extensive application development experience and the judgment to set, plan and implementation goals. This individual should also have strong communication skills and the ability to provide consultation to customers and collaborate internally on complex projects as the lead contributorspecialist. This position typically reports to a lead architect, manager or head of a unitdepartment Responsibilitiesbull Manages a team of developers performing ETL activities bull Review business and technical requirements and ensure the data integration platform meets requirements bull Apply industry best practices for ETL design and development bull Lead design, development and implementation of end-to-end complex ETL system using Datastage tools bull Plan and lead ETL development efforts for team utilizing Datastage tools bull Produce written deliverables for technical design, system testing and implementation activities bull Lead implementation of ETL systems that are operationally stable, efficient and automated bull Lead implementation of technical solutions that are scalable, aligned with the enterprise architecture and can adapt to changes in business bull Lead implementation of ETL systems that maximize re-usable componentsservices, collectshare metadata, incorporate audit, reconciliation and exception handling bull Lead implementation of parallel processing, load balancing, near real-time and real-time ETL processes bull Lead implementation of entity resolution applications to build master indexes for members, providers, payers, etc. bull Establish master data management programs bull Implement monitoring and measurement of data quality as defined by business rules bull Ensure adherence to architectural governance standards and practices bull Implement best practices, standards of excellence, and guidelines for programming teams bull Coordinate System Testing activities bull Lead development, documentation and application of best practices and procedures that govern DW implementations and operations bull Contribute to the recruiting, mentoring, and growth of team members bull Off hour and weekend support may be required to meet project milestones Mandatory Skillsbull 2 years' experience as leading ETL development for data warehouse projects (healthcare preferred) bull 5 years' experience programming ETL programs using standard languages or tools (Datastage preferred) bull 5 years' experience performing data analysis and profiling, and designing ETL systemsprograms bull Expert SQL skills bull In depth understanding of data integration best practices, leading industry applications and features such as master data management, entity resolution, data quality assessment, metadata management, etc. bull Understanding of data warehouse best practices bull Good communication skills bull Good interpersonal skills and the ability to collaborate with other technical teams, project management, client management and business analysts Nice-to-Have Skillsbull Health and human services experience bull Experience implementing ETL on Oracle or IBM database platform The Data Integration Lead can work remotely.