Data Analyst V

Texas Health and Human Services; Austin (TX); On-site; USD 71,178 - 95,775; Full time

Benefits offered by this job

100% paid employee health insurance

Defined benefit pension plan

Generous time off benefits

Career advancement opportunities

Job summary

Texas Health and Human Services seeks a Data Analyst V to perform highly complex data collection, analysis, and reporting for the RSDA division within DAP. You will design reports, develop back-end data logic, and drive data quality improvements while collaborating with agency staff to ensure requirements are met.

The role emphasizes SQL-based data loading, Tableau visualization, and back-end scripting, with opportunities to influence reporting processes and data governance.

Qualifications

• Graduation from an accredited four-year college or university with major coursework in data science, business analytics, computer science, or a related field.
• Experience in data analysis, compilation, and reporting work; education and experience may be substituted for one another, up to four years.
• Experience with data and applications related to foster care or child welfare reporting and visualization preferred.

Responsibilities

• Oversees development and implementation of databases and data collection systems to optimize efficiency and quality.
• Loads and queries data using SQL to support complex analyses.
• Develops data quality metrics and monitors data integrity across reports and dashboards.
• Communicates findings and recommendations to stakeholders and supports system design meetings for new initiatives.
• Mentors team members and guides data management best practices.

Skills

Statistics & analysis

Relational databases

Data troubleshooting

Advanced analytics

Data tools: SQL/Tableau

Communication

Initiative

Data analysis & coding

Education

Bachelor's degree in data science or related field

Tools

SQL Developer

Toad

Tableau

Python

R

Job description

Date: Jul 27, 2026

Location: AUSTIN, TX

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: Monthly

Salary 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 associated with processes.
• Ensures data integrity by identifying gaps, errors, and anomalies, inconsistencies, and redundancies in the content, structure, and relationships within the data.
• Provides suggestions for systematic changes that will improve the collection of data and align data infrastructure with business needs.
• Provides routine updates on the stats of projects and initiatives.

Coordination: (10%)

• Customer service focused. Utilizes strong communication skills to explain CCL/FCL data processes and data management to negotiate information and resources needed to ensure successful initiatives.
• Determines the scope, purpose, timeline, and expected outcomes of assignments.
• Helps develop cost estimates and budgets for technical FCL initiatives.
• Coordinates with Program Subject Matter Experts (SME’s) to ensure accuracy of reporting tools, workflows, reporting procedures and to improve data quality.
• Provides guidance related to the selection and use of preferred data management and analytic tools; defines, develops, and implements data and reporting standards.
• Provides guidance and direction to other areas needing technical expertise.
• Mentors team members.

Knowledge Of

Knowledge, Skills and Abilities (KSAs)

• Knowledge of statistics and analyzing data sets; running queries, report writing, and presenting findings; and record keeping, including security procedures for handling, protecting, and distributing confidential data.
• Understanding of and demonstrated skill in relational databases, data processing practices, and theory.
• Knowledge of or strong aptitude to learn CCL and FCL data

Skill In

• Skill in researching and troubleshooting data issues and solving complex problems.
• Skill in report development and automation.
• Skill in complex analytic work, identifying trends and concerns, and recommending opportunities for improvement as well as areas of excellence.
• Skill in using software such as SQL, SQL*Plus, PL/SQL, Tableau, Excel, TOAD, Oracle, SQL Developer, Business Intelligence tools, Python, R, and/or SAS.

Ability To

• Ability to work hours as needed to meet defined deadlines and support the agency’s mission-critical reporting requirements.
• Ability to present information to a variety of audiences verbally and in writing and to communicate clearly, concisely, and effectively.
• Ability to exercise independent judgment and show initiative.
• Ability to analyze, consolidate, and interpret complex data, procedures, and systems and to write or revise program code or prepare reports as required.
• Comprehension of data solutions, reporting methodologies, math, and statistical report design.
• Ability to creatively solve complex data problems, apply new technology, and perform detailed work accurately under stressful conditions while managing multiple projects and tight deadlines.

Registrations, Licensure Requirements Or Certifications

N/A

Initial Screening Criteria

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. Experience in data analysis, compilation, and reporting work. Experience with Oracle, SQL Developer, Toad, Tableau, or other database development tools. Experience and education may be substituted for one another, up to four years. Experience with data and applications related to development of Child or Foster Care program reports and visualizations is preferred.

Additional Information

Candidate must also pass fingerprint and criminal background check.

Active Duty, Military, Reservists, Guardsmen, And Veterans

Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to those listed in this posting. All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information please see the Texas State Auditor’s Job Descriptions, Military Crosswalk and Military Crosswalk Guide at Texas State Auditor's Office - Job Descriptions.

ADA Accommodations

In compliance with the Americans with Disabilities Act (ADA), HHSC and DSHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.

Pre-Employment Checks And Work Eligibility

Depending on the program area and position requirements, applicants selected for hire may be required to pass background and other due diligence checks.

HHSC uses E-Verify. You must bring your I-9 documentation with you on your first day of work. Download the I-9 Form

Telework Disclaimer

This position may be eligible for telework. Please note, all HHS positions are subject to state and agency telework policies in addition to the discretion of the direct supervisor and business needs.

Nearest Major Market: Austin