Data Analyst V

TX-HHSC-DSHS-DFPS; Austin (TX); On-site; USD 71,000 - 96,000; Full time

Benefits offered by this job

Health insurance

Defined benefit pension

Generous time off

Job summary

Texas Health and Human Services Commission (HHSC) in Austin, TX seeks a Data Analyst V to perform highly complex data collection, research, reporting, and analysis to monitor and improve PMA efficiencies. The role involves design, maintenance of reports, and back-end data development with collaboration across RSDA and agency staff.

The position requires creating diagrams, logic flows, and documentation for programming work, and presenting findings with concise recommendations for quality

Qualifications

• Ability to perform highly complex data collection, analysis, and reporting.
• Experience with SQL and data modeling for back-end tables and logic.

Responsibilities

• Oversees databases, data collection systems, and data strategies to optimize statistical efficiency and quality.
• Queries and loads data using SQL to support complex analyses.
• Ensures data quality and integrity for reports and dashboards.
• Develops scripts to extract, compile, and present data for Tableau and other visualization tools.
• Collaborates with agency staff to meet requirements and validate results.

Skills

SQL

Data analysis

Data visualization

Reporting

Tools

Tableau

Job description

Join the Texas Health and Human Services Commission (HHSC) and be part of a team committed to creating a positive impact in the lives of fellow Texans. At HHSC, your contributions matter, and we support you at each stage of your life and work journey. 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. Explore more details on the Benefits of Working at HHS webpage.

Functional Title: Data Analyst V Job Title: Data Analyst V Agency: Health & Human Services Comm Department: DAP Foster Care Litigation Posting Number: 19310 Closing Date: 01/25/2027 Posting Audience: Internal and External Occupational Category: Computer and Mathematical Salary Range: $6,377.50 - $8,581.66 Pay Frequency: MonthlySalary Group: TEXAS-B-26 Shift: Day Additional Shift: Telework: Eligible for Telework Travel: Up to 5% Regular/Temporary: Regular Full Time/Part Time: Full time FLSA Exempt/Non-Exempt: Exempt Facility Location: Job Location City: AUSTIN Job Location Address: 4601 W GUADALUPE ST Other Locations: MOS Codes: 0231,0239,0271,0291,2652,2659,6046,6049,8051,8825,8846,8850,14N,14NX,15AX,16KX,181X,182X,183X,1D7X1 1N0X1,1N1X1,1N4X1,1N7X1,255A,25B,26B,350F,350G,351L,351M,352N,35F,35G,35L,35M,514A,514B,5I0,5I1A 65FX,65WX,681X,682X,683X,781X,782X,783X,86P0,8K000,CT,CTR,CTT,CYB10,CYB11,CYB12,CYB13,CYB14,IS,ISM ISS,IT,ITS,SEI15,SEI23

Brief Job Description:

Regulatory Specialty Data and Analytics (RSDA) is a division within the Office of Data, Analytics, and Performance (DAP). RSDA provides analysis, data visualization, and reporting to support Health and Human Services Commission (HHSC) agencies in its stakeholders' operational and decision-making needs.

Under the supervision of the RSDA PMA Manager, the Data Analyst V performs highly complex (senior level) data collection, research, reporting, and analysis to monitor, evaluate, and increase efficiencies for PMA. Work involves gathering and analyzing requirements, report design and implementation, and ongoing maintenance of existing reports and processes. The analyst will work with other RSDA staff as well as other HHSC staff to develop back-end tables and logic to drive reporting; create original programming logic and evaluate and/or modify existing programs to take into account changes in requirements; and will review work products developed by other analysts and to interact with agency Program staff, division managers, and/or other analysts to ensure requirements are met and that all work products are appropriately reviewed and validated.

The analyst will prepare diagrams and logic flowcharts for detailed coding and for the documentation of programming work and may interact with staff from other agencies and outside entities as required to facilitate data collaboration, obtain required work products, or for consultation.

The analyst will participate in system design meetings for new agency initiatives to ensure the agency’s ability to report applicable data.

This position will produce concise, comprehensive technical reports presenting findings, identify alternatives, and recommendations for process improvement, and outline solutions to monitor and implement data quality.

Works under limited supervision, with moderate latitude for the use of initiative and independent judgment.

Essential Job Functions (EJFs):

Infrastructure Support:(30%)

Oversees the development and implementation of databases, data collection systems, and other strategies to optimize statistical efficiency and quality. Compiles, queries, and loads data using SQL and other query languages into databases to support complex analyses. Maintains security protocols for confidential data as it relates to accessing, handling, protecting, and distributing. Oversees the RSDA technical activities to ensure FCL reporting requirements are met.

Data Quality/Integrity Management: (30%)

Monitors and ensures data quality, loading data into databases from a variety of sources, as well as formatting and automating data feeds, to be used as input for ongoing and ad-hoc reporting, performance dashboards, and other reports. Develops scripts or code to extract, compile, and present data or models using computer programming languages such as SQL. Cleans and prepares data, as necessary, to produce data required for Tableau and other data visualization software. Extracts data from multiple sources for multiple report products. Ensures the accuracy of data included in reports.

Identify and Implement Improvements for Data Quality, Integrity, and Management: (30%)

Establishes and updates data quality metrics and recommends and implements improvements to data quality with processes. Ensures data integrity by identifying, establishing, and updating data quality metrics and recommends and implements improvements to data quality ass