Lead Data Analyst

Texas Health and Human Services; Austin (TX); Hybrid; USD 71,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Pension plan

Paid time off

Career advancement

Job summary

Texas Health and Human Services (HHSC) is seeking a Lead Data Analyst to oversee complex data collection, analysis, and reporting for Texas State Hospitals. You will work with SQL, Tableau, and other BI tools to drive performance insights and improve data quality across initiatives.

Reporting to the Director of Data Analytics, you will design backend data structures, develop robust reports, and coordinate with HHSC stakeholders.

Qualifications

• Graduation from an accredited four-year college with major coursework in data science, business analytics, computer science, or related field.
• Experience in data analysis, research, compilation, and reporting.
• Experience designing, developing, and maintaining queries and reports; familiarity with electronic health records preferred.

Responsibilities

• Oversees development and implementation of databases and data collection systems to optimize statistical efficiency and data quality.
• Loads and queries data using SQL to support complex analyses and dashboarding.
• Produces concise technical reports to present findings and recommendations.
• Mentors team members and guides best practices for data management and reporting.

Skills

SQL

Tableau

Excel

Oracle

SAS

Data analysis

Education

Bachelor's degree in data science / related field

Tools

SQL

Tableau

Job description

Date: Aug 10, 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: Lead Data AnalystJob Title: Data Analyst VAgency: Health & Human Services CommDepartment: Hospitals SectionPosting Number: 19941Closing Date: 09/09/2026Posting Audience: Internal and ExternalOccupational Category: Computer and MathematicalSalary Range: $6,377.50 - $10,785.83Pay Frequency: Monthly
Salary Group: TEXAS-B-26Shift: DayAdditional Shift: Days (First)
Telework
Travel: Up to 5%Regular/Temporary: RegularFull Time/Part Time: Full timeFLSA Exempt/Non-Exempt: Exempt
Facility Location:Job Location City: AUSTIN
Job Location Address: 909 W 45TH ST BLDG 552
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
Would you thrive in an environment where you learn and grow personally and professionally all while helping make a positive impact on people’s lives? Do you appreciate being around others like yourself who are dependable, trustworthy, hard workers who believe in the value of teamwork? HSCS is dedicated to building an atmosphere where employees feel valued and supported while providing specialized care for Texans in need. HSCS is comprised of ten psychiatric hospitals, two youth residential treatment facilities, and thirteen state supported living centers. Psychiatric hospitals are a hub of excellence for forensic mental health and complex psychiatric care, with all facilities accredited by The Joint Commission. They provide state-of-the‑art treatment that is recovery‑oriented and science‑based. If providing hope and healing through compassionate, innovative, and individualized care interests you, we welcome your application for the position below.

Under the direction of the Director of Data Analytics, the Data Analyst V performs highly complex (senior level) data collection, research, reporting, and analysis to monitor, evaluate, and increase efficiencies for Texas State Hospitals (SH). Work involves gathering and analyzing data requirements, report design and implementation, and ongoing maintenance of existing reports and processes. Position requires being familiar with The Joint Commission Standards. The analyst will work with other SH 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. The analyst will interact with agency program staff, division staff, other analysts and stakeholders to ensure data 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 SH initiatives to ensure the ability for SHs to collect and report applicable data. This position will produce concise, comprehensive technical reports to present findings, identify alternatives, and make recommendations for process improvement, and outline solutions to monitor and implement data quality. This position will analyze the data and interpret results of the analysis. Works under limited supervision, with moderate latitude for the use of initiative and independent judgment.

Performs other duties as assigned. Other duties as assigned include 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.

Essential Job Functions (EJFs)
Attends work on a regular basis and may be asked 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.

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 or 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 SH technical activities to ensure reporting requirements are met. Participates in the hospital information management committee/medical records committee/ governing body. 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, such as National Association of State Mental Health Program Directors Research Institute (NRI) statewide performance indicators, and various ad hoc requests for reports and analysis related to SH records and data. Ensures the accuracy of data included in reports. 30%

Establishes and updates data quality metrics and recommends and implements improvements to data quality with processes. Ensures data integrity by identifying gaps, errors, and anomalies, inconsistencies, and redundancies in the content, structure, and relationships within the data and implementing needed improvements for data quality and processes. Provides suggestions for systematic changes that will improve the collection of data and align data infrastructure with business needs. Provides routine updates on the status of projects and initiatives. 25%

Knowledge of statistics and analyzing data sets; running queries, report Coordination: Customer service focused. Utilizes strong communication skills to explain 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 SH 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. Participates in legislative review process, requested reports, and other requests as it relates to SH records and data. Mentors team members. 10%

Performs other duties as assigned. 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. (5%)

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.

Knowledge of data solutions, reporting methodologies, math, and statistical report design.

Knowledge of or strong aptitude to learn and interpret SH data.

Skill in relational databases, data processing practices, and theory.

Skill in researching and troubleshooting data issues and solving complex problems.

Skill in report development and automation.

Skill in using software such as Tableau, Excel, Oracle, SQL, Business Intelligence tools and SAS.

Skill in complex analytic work, identifying trends and concerns, and recommending opportunities for improvement as well as areas of excellence.

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.

Ability to present information to a variety of audiences verbally and in writing and to communicate clearly, concisely, effectively, and timely.

Ability to exercise independent judgment and show initiative.

Ability to work hours as needed to meet defined deadlines and support the agency’s mission‑critical reporting requirements.

Ability to oversee and/or supervise the work of others as necessary.

Ability to analyze, consolidate, and interpret complex data, procedures, and systems and to write or revise program code or prepare reports as required.

Registrations, Licensure Requirements Or Certifications
None

Initial Screening
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.

Experience Working With Electronic Health Records Is Strongly Preferred.
Experience working in a State Hospital is preferred.

Additional Information
Applicants must pass a fingerprint criminal background check, pre‑employment drug screen, and registry checks including the Client Abuse/Neglect Reporting System (CANRS), Nurse Aid, Medication Aide and Employee Misconduct, List of Excluded Individuals/Entities (LEIE). Males between the ages of 18-25 must be registered with the Selective Service.

All applicants must be at least 18 years of age to be considered for employment at a state‑operated facility. Waco and Terrell Center for Youth applicants must be 21 years of age.

Flexibility in work hours may be required for this position. The position may be required to work overtime and/or extended hours.

Compliance with HHSC immunization policy and state hospital operating procedures related to immunizations is required. According to the Centers for Disease Control and Prevention, healthcare workers are considered to be at significant risk for acquiring or transmitting hepatitis B, measles, mumps, rubella, varicella (chicken pox), tetanus, diphtheria, pertussis (whooping cough), and influenza. All these diseases are vaccine preventable. As a result, state hospital policy requires employees be vaccinated according to their level of contact with individuals. In the event you choose to not be immunized for the influenza virus, you may be required to wear a mask and take other protective measures.

Review our Tips for Success when applying for jobs at DFPS, DSHS and HHSC.

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