Apply on Employer Site

Texas Health and Human Services · 5 hours ago

Data Analyst II

Corpus Christi, TX

Contract

Onsite

Mid Level

$4,263/mo - $6,779/mo

Texas Health and Human Services is committed to creating a positive impact in the lives of Texans. The Quality Improvement Data Analyst performs routine to moderately complex data analysis work to monitor and improve the quality of care and services provided to individuals served at state supported living centers.

Health Care

No H1B

Responsibilities

Attends work on a regular basis and may be required to work a specific shift schedule or, at times, even a rotating schedule, extended shift and/or overtime in accordance with agency leave policy and performs other duties as assigned

May serve in an on-call status on a rotating schedule as required to meet operational needs of the facility

Develops and maintains databases and reports using software tools including but not limited to MS Access, MS Excel, and SQL Maintains a relational database system and spreadsheets to track and trend quality of care data

Designs and maintains administrative reports using data from an electronic health record and internal monitoring tools and databases

Creates and updates reports from data entered into the electronic health record

Executes the procedures necessary to save, retrieve, and recover databases from hardware and software failures

Works within the backend of software applications to review queries and resolve operational problems

Develops and implements database procedures to collect and track data with sufficient particularity to identify trends, among, within and/or regarding program areas, living units, work shifts, protections/supports/services, areas of care, staff members and/or individuals receiving services and supports

Ensures the integrity, security and accessibility of the SSLC’s databases, data and reports

Develops and implements tools to track the accuracy and integrity of data reporting

Establishes processes for analyzing and validating data used to calculate outcome measures

Conducts frequent audits using reports to verify information entered into the electronic health record is accurate

Reconciles data reports, identifying data gaps, errors, irregularities, variances, inconsistencies and redundancies in the information gathered

Provides guidance to SSLC staff in the collection, review, and validation of electronic health data required for tracking and trending performance improvement efforts and service monitoring

Oversees, develops, and/or assists in the development and presentation of trend reports

Writes queries to access data for analysis and reporting

Works with interdisciplinary teams to research and correct data issues

Assists in identifying and interpreting data patterns and trends

Ensures program staff can easily use the information pulled from the databases

Troubleshoots with facility staff on entering data correctly into a system

Provides support for programs across the SSLCs in data or training on reporting, explaining information extracted

Responds to ad hoc data requests from program staff and state-office

Collects data for information requests

Requests Integrated Resident Information System (IRIS) access for staff and resets IRIS passwords as assigned

Acts as a liaison with state office data analysts and HHSC IT

Collaborates effectively with others including members of the Quality Assurance/Quality Improvement (QA/QI) Council to ensure opportunities for collection and analysis of data are maximized

Develops, and/or assists in the development, maintenance and presentation of management tools and department trend reports for quality assurance and improvement initiatives such as Corrective Action Plans (CAPs) or Quality Improvement Plans (QIPs)

Other duties as assigned include but are not limited to actively participating and/or serving in a supporting role to meet the agency’s obligations for disaster response and/or recovery or Continuity of Operations (COOP) activation

Qualification

MS AccessMS ExcelSQLData analysisReport designProblem solvingCritical thinkingTeam playerEffective communicationAttention to detail

Required

High School diploma, GED, or equivalent education

Work experience with MS Access and Excel

Work experience in data analysis, research, and report design

Work experience in designing, developing, and maintaining queries and reports

Knowledge, or ability to gain knowledge, of agency programs, policies, and service delivery processes

Strong working knowledge of Microsoft Access and Microsoft Excel, including how to write formulas

Skill managing data in a relational database management system, including the development of queries, and report development software

Skill in the use of computers and applicable software in conducting data searches and data cleaning

Skill in the proficient use of MS Excel including formulas

Skill in complex problem solving and critical thinking

Ability to gather, review, and analyze data for trends

Ability to distill large collections of data into an easily readable format that can be tracked and trended

Ability to maintain accuracy and attention to detail

Ability to prioritize work and meet deadlines

Ability to communicate effectively both orally and in writing

Ability and willingness to learn new systems, such as SharePoint

Ability and willingness to be a team player and work well with a variety of stakeholders

Preferred

Technical school or college/university level coursework in data science, business analytics, computer science, computer information systems, management information systems, accounting, finance, mathematics, statistics, economics, or a related field is preferred

Experience with MS SharePoint is preferred

Experience working with electronic health records is preferred