| Datawarehouse Architect at Remote, Remote, USA |
| Email: [email protected] |
| From: priyanka verma, Triwave Solutions Inc [email protected] Reply to: [email protected] Client : State of Vermont Duration : 8 Months(Extendable) Role : Datawarehouse Architect PURPOSE BACKGROUND The Vermont Department of Health (VDH) is seeking a Data Architect to perform analysis and produce recommendations to inform the vision for development of a data warehouse that combines data from across multiple VDH programs. The scope of this work is limited to design and planning. The primary products to be produced via this effort include a VDH Data Warehouse Strategy Report, technical architecture, data model, data flow, and data architecture models as outlined in the deliverables section of this document. These products will inform a future project to build and implement a warehouse. EXISTING TECHNOLOGY ENVIRONMENT The Vermont Department of Health currently maintains multiple independent data systems. While many of these are integrated to facilitate data sharing and reporting the Department does not currently have a central data warehouse. The systems include very large databases such as the Shared Public Health Information Exchange (SPHINX) which houses State vital records (births and deaths) along with the States immunization registry, vaccine inventory and multiple childhood health screening registries; and systems that support the States public health laboratory. In addition, there are multiple smaller systems both internally developed and vendor hosted which contain data anticipated to be included in the VDH Data Warehouse. The VDH is a Department within the States Agency of Human Services (AHS). The AHS has defined a vision for a Unified Data Health Space (UDHS) that includes data from VDH and the other Departments within the Agency. A critical element of this is the Medicaid Data Warehouse and Analytics Solution (MDWAS). This context must be considered in determining the model and architecture for the VDH Warehouse. The VDH warehouse is independent, but consideration should be given in design to potential future integration with MDWAS . The State of Vermont Agency of Digital Services (ADS) defines standards for data modeling, architectural vision, roadmap and standards for governing, modeling storing and delivering data within the enterprise. Parallel to the work to be performed under this contract ADS is engaged in efforts to update and define these standards. The work under this contract must include engagement with those developing these standards to assure alignment of deliverables to the current standard. The technology platforms that support VDH systems are primarily Microsoft. The data in State of Vermont developed systems is primarily hosted in SQL databases on or planned to migrate to Azure virtual machines. The current enterprise tool for integration is Mulesoft. It is anticipated Verato will be used for establishing a Master Person Index. Data in vendor hosted SaaS solutions, may be supported by different technology. Core data systems include Electronic Birth Registration System (EBRS) Electronic Death Registration System (EDRS) Vermont Immunization Registry (IMR) Universal Developmental Screening Registry (UDS) Vermont Early Hearing Detection & Intervention Program (VTEHDI) Healthy Homes and Lead Poisoning Surveillance System (HHLPSS) National Electronic Disease Surveillance System (NEDSS) Base System (NBS) Vermont Cancer Registry (VCR) Statewide Incident Reporting Network (SIREN) Vermont Advance Directives Registry (VADR) Enhanced HIV/AIDS Reporting System (eHARS) Vermont Prescription Monitoring System (VPMS) StarLIMS WIC Management Information System (Ceres) Vermont Newborn Screening Program REQUIREMENTS: For this particular request, knowledge requirements include: o Proficiency in data modeling and design o Expert knowledgeable of data quality and governance processes, such as data profiling, data cleansing, data validation, data lineage, data security, data privacy, and data compliance o Expertise in the principles and components of master data management including master person index. o Knowledge of the Verato master data management platform preferred o Experience in SQL development and database administration o Proficiency in Visio (for creation of all models) o Knowledge of use of MuleSoft for integration. o Experience working with legal context governing sharing of public health data including HIPAA, 42 CRF Part 2 is preferred. o Experience in Data warehouse design and ETL including expert knowledge of appropriate tools, technologies and strategies employed in data warehouse development, such as ETL (extract, transform, load) tools, databases, data marts, data lakes, data warehouses as a service, and business intelligence tools. Keywords: information technology |
| [email protected] View all |
| Thu Feb 29 00:45:00 UTC 2024 |