Texas Health and Human Services Commission requires the services of 3 Systems Analyst 3, hereafter referred to as Candidate(s), who meets the general qualifications of Systems Analyst 3, Applications/Software Development and the specifications outlined below for the Texas Health and Human Services Commission.
The COVID-19 pandemic has strained Texas resources and data sharing capabilities in unprecedented ways. The need for immediate and accurate data in order to make daily decisions is essential to a successful response for Texas constituents. The Department of State Health Services (DSHS) relies on the collection and dissemination of COVID-19 related data from different sources to respond to the pandemic.
Through the newly-implemented Infectious Disease Data Integration (IDDI) platform, the agency collected and integrated data from various critical, but disparate source systems. Though IDDI moved the agency’s goals forward to collect, integrate and curate the required data set, the continued differences in data formats, variances in the data quality of the source systems, and the unprecedented volume of data that is now collected on a daily basis poses a continued challenge to maintain uniformity and integrity and provide public accessibility to this critical data that IDDI has integrated, curated and reported. It is imperative for DSHS to overcome this challenge of collecting, sharing and exchanging data with key stakeholders. Additionally, in March 2021, the passage of Senate Bill (SB) 969 in the 87th Legislature now requires DSHS to develop a standardized method for reporting data concerning public health disasters to ensure the accessibility and integrity of critical data to all key stakeholders, including Texas citizens during a public health disaster.
The Public Health Data Sharing (PHDS) project will help DSHS comply with SB 969 as well as fulfill the needs identified in the data assessment carried out by HHS.
HHSC IT is currently implementing a data sharing platform with Informatica PowerCenter / IDQ, Snowflake and AWS technologies with a goal to accomplish improved collection, integration, and curation of COVID-19 related data sets.
· Responsible for development using Informatica Data Quality and PowerCenter
· Assist DSHS program area use of the SHARP Platform to its fullest potential
· Resolve any data source ingestion issues
· Operationalize ingestion of new data sources as needed
· Other work includes, but is not limited to:
· Validation of performance metric requirements
· Creation of EPICS/User Stories
· Creation and validation of dashboard and report mock-ups
· Automation of data acquisition from a variety of data sources
· Dashboard and report development
· Testing – integration, load and stress, and user
· Deployment / publication internally and externally
· Operations support and enhancement of the SHARP platform
· All other duties as assigned.
Experience as an ETL engineer implementing data integration pipelines for a data mart or a data warehouse using Informatica PowerCenter and IDQ.
Experience in data validation (pre and post ETL processing) for checking the accuracy and quality of data.
Experience creating shell scripts using borne or c shell.
Bachelor’s degree in Computer Science, Information Systems, or Business or equivalent experience.
Working knowledge of AWS IAM, networking, infrastructure, storage, and database services.
Member of an agile team that focus on delivering business value.
Excellent oral and written communication skills.
Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required.
Prior experience in the Healthcare Industry**
Prior experience with an HHS agency**
Relevant AWS Certification
Note: Prior experience working of a State of Texas agency is desireable.