Data Analyst for SSLC Quality Assurance

Texas Health & Human Services Commission•Austin, TX

33d•Remote

About The Position

The Data Analyst V performs complex data analysis and research work within the State Supported Living Center (SSLC) Quality Improvement division. Serves as Data Analyst for SSLC State Office and the 13 state supported living centers (SSLCs). Trains State Office and SSLC facility staff on the use of SSLC applications and reports. Serves as a subject matter expert for those staff. Designs reporting systems, data warehouses, and databases for the 13 SSLCs and State Office for specific data sets utilizing the electronic health record and other SSLC-specific applications. Provides guidance on the development of forms and reports in the SSLC Monitoring and Tracking System (MATS). Develops and maintains databases and reports using software tools such as Business Objects, SQL, MS Access, MS Excel, and Tableau. Oversees, develops, and/or assists in the development and presentation of statewide trend reports. Identifies and manages organizational performance measures (metrics) and other quality initiatives. Provides guidance to SSLC staff in the collection, review, and validation of electronic health record data required for tracking and trending performance improvement efforts and service monitoring. Reconciles data reports provided by other data analysts at the Center level, identifying data gaps, errors, anomalies, and inconsistencies. Collects and oversees gathering of information requests from various stakeholders. Serves as liaison to HHSC Enterprise IT for current SSLC electronic health record systems. Provides information to all discipline coordinators at State Office for analysis of information and identification of data needs. Communicate with facility Quality Improvement departments, data analysts, and Records departments in all SSLCs concerning data entry into the SSLC electronic health record, MATS, and other SSLC-specific data applications. Works under the general supervision of the Quality Assurance Manager with moderate latitude for the use of initiative and independent judgment.

Requirements

Basic knowledge of local, state, and federal laws related to the program area to include Intermediate Care Facilities/Individuals with Intellectual Disabilities (ICF/IID), Texas Administrative Code (TAC), and HHSC policies and procedures related to State Supported Living Centers, or ability to gain that knowledge.
Knowledge of security procedures for handling, protecting, and distributing confidential data.
Knowledge and technical expertise regarding data models and data relationships.
Working knowledge and understanding of electronic health records.
Strong knowledge of reporting packages (e.g., Business Objects or Tableau) and database management software (e.g., SQL).
Strong analytical skills.
Advanced skills in using MS Access and MS Excel.
Ability to compile, correlate, and analyze data.
Ability to prepare technical reports, to communicate effectively, to train, lead and coordinate the work of others.
Ability to collect, interpret, organize, verify, and disseminate significant amounts of information with attention to detail and accuracy.
Ability to develop queries and extract data for tracking and trending analysis and report development.
Ability to lead projects and workgroups to comply with reporting requirements.
Ability to coordinate actions of team members to meet reporting requirements, meet ad hoc reporting requirements, and perform data analysis.
Ability to work on a variety of projects (multi-tasking) and to meet all deadlines.
Graduation from an accredited four-year college or university with major 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 in data analysis, research, compilation, and/or reporting work.
Experience in designing, developing, and maintaining queries and reports.

Nice To Haves

Experience working with electronic health records is strongly preferred.
Experience working in an ICF/IID facility is preferred.

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, such as special projects, special investigations, and ad hoc assignments.
Oversees the collection, organization, validation, and analysis of information and prepares materials in response to requests for program information and special reports such as those for LBB, Legislature, Media, and Open Records requests, and acts as liaison with agencies and internal programs to explain agency/program statutory requirements.
Develops and maintains databases and reports using software tools such as Business Objects, SQL, MS Access, MS Excel, and Tableau.
Provides support for programs across the SSLCs with extracting data, training on reporting, explaining extracted information, and providing information to all discipline coordinators at State Office for analysis of information.
Monitors data and identifies potential trends within reports that will be addressed by specific program staff.
Troubleshoots with facility staff on entering data correctly into a system. Reconciles each month's movements for enrollment list, researching to find what has caused gaps or errors and correcting that through process improvements or training. Follows up to ensure errors do not reoccur.
Develops automated reports, reviews the reports for any errors, and reconciles their work.
Oversees the completion of and monitors required administrative and performance reports, studies, and specialized projects and recommends appropriate changes at the SSLCs and State Office.
Provides consultative services and technical assistance related to data systems, including guidance and training, to staff.
Serves as backup for SSLC and State Office data analysts when problems arise (providing document requests or other data requested, troubleshooting data systems for information not collected in the current electronic health record system in their absence).
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. Such participation may require an alternate shift pattern assignment and/or location.

Benefits

Our comprehensive benefits package includes 100% paid employee health insurance for full-time eligible employees, a defined benefit pension plan, generous time off benefits, numerous opportunities for career advancement and more.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume