Data Analyst V

Texas Health and Human Services Commission

$76K — $102K *
Education, Government & Non-Profit
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in social science, business, statistics, or related field (4 years of experience can substitute education)
  • 3+ years of experience in managing and analyzing health and human services-related data
  • Proficiency in SQL and experience with statistical tools (e.g., SAS, Excel)
  • Knowledge of Medicaid Long-term Care programs and relevant data reporting
  • Experience in data validation and integrity checks for large datasets

Responsibilities

  • Perform complex data analysis to support policy and program decisions for Medicaid Long-term Care
  • Identify and resolve data gaps, errors, and inconsistencies in datasets
  • Compile and manipulate data using SQL, SAS, and other tools for various analyses
  • Prepare and interpret comprehensive technical reports for stakeholders
  • Engage with customers to understand and address data reporting needs
  • Lead data analytic efforts and guide team members while reviewing project deliverables
  • Participate in special projects and serve as a subject matter expert for long-term care data

Benefits

  • Eligibility for telework options
  • Opportunity to work in a supportive team environment
  • Professional development opportunities
  • Access to public service retirement and health benefits
  • Potential participation in agency committees and workgroups
Full Job Description
Functional Title: Data Analyst V Job Title: Data Analyst V Agency: Health & Human Services Comm Department: DAP Analytics & Decision Sup Posting Number: 21312 Closing Date: 12/09/2026 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: Days (First) 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:

The Data Analyst V reports to the Manager of the Aging and Disability Reporting team in the Data Dissemination and Reporting section of the Office of Data, Analytics and Performance (DAP). The DA V performs highly complex (senior level) data analysis to inform policy and program decisions for Medicaid Long-term Care programs. The DA V consults with internal and external customers to identify and support Aging and Disability data reporting needs. Using standard statistical tools, methods and techniques, the DA V compiles and queries service utilization, provider and other long-term care data sets. Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data. Provides data validation and integrity checks for long-term care program data. The DA V prepares concise, comprehensive technical reports to present and interpret the data for program staff, leadership, advisory committees and other stakeholders. Reviews project deliverables to ensure compliance with customer needs and agency/department policies. The DA V serves as a resource for colleagues and is a key contributor in a complex and crucial data analytic environment. This position will guide the data analytic work of other team members. The DA V works under limited supervision with considerable latitude for the use of initiative and independent judgment.

Essential Job Functions (EJFs):

EJF 1. Data Quality/Integrity: Provides suggestions regarding systematic changes that will improve the efficiency and quality of data analysis processes. Assesses data quality by identifying any missing, erroneous, incongruent, or duplicate data in data sets used by the unit. Coordinates with other internal groups within DAP or other areas to improve data quality. Consults and provides requirements for the improvement of data collection systems and the methods used to perform data analytics. 25%

EJF 2. Data Analysis: Determines the most effective method to address a given data request, construct a performance measure, or monitor various service trends. Compiles and manipulates data points using SQL, SAS, or other languages from a variety of source formats, to support complex analyses related to monitoring Medicaid Long-term Care programs. Cleans and prepares data to produce datasets required for data analysis. 20%

EJF 3. Reporting: Oversees the interpretation of analysis results to inform the team's presentations and reports of the results. Prepares comprehensive standard and ad-hoc reports, in written, graphical and oral format, for internal and external audiences. Ensures accuracy of data included in reports. 20%

EJF 4. Customer Focus and Communication: The Analyst engages with a variety of people across the agency, to build strong relationships and to find creative solutions to analytic projects. Utilizes communication skills to gather the information necessary from customers to assess and address their needs. Explains analysis results in clear and non-scientific language as necessary to ensure that customers can leverage the information in decision-making. Coordinates with program subject matter experts and leadership to both ensure accuracy in approach for the analysis and to inform staff of findings in a timely manner. 20%

EJF 5. Special projects and assignments as assigned/required: Serves on agency committees and workgroups as an SME consultant for long-term care data. Prepares and updates standard operating procedures and processes for long-term care reporting. (15%)

Knowledge, Skills and Abilities (KSAs):

Knowledge of reporting and BI tools: Cognos, Crystal Reports, Business Objects, etc.

Knowledge of data bases such as Oracle, Access and/or SQL Server.

Knowledge of HHSC program data and reporting.

Knowledge of data quality and integrity processes.

Knowledge/Skill with Excel macro development a plus.

Skill in creating SQL statements for creating data sets and data base modifications.

Skill in Data Warehouse, Cognos, PL/SQL, Snowflake a plus.

Skill in communicating with individuals at all management levels on technical issues.

Ability to work and communicate effectively with others.

Ability to gather, assemble, correlate, and analyze facts; to devise solutions to problems; to prepare concise reports; develop and evaluate policies and procedures.

Ability to perform detailed work accurately and in accordance with standards.

Ability to meet deadlines and work on projects with changing priorities.

Ability to read and understand requirements/design specifications and propose logical solutions to meet requirements/specifications.

Ability to operate effectively as a member of a team managing multiple projects.

Ability to read, interpret, and analyze existing documentation and reports.

Ability to create/maintain technical documentation of work/project assignments.

Ability to interpret and report on data analytic findings.

Ability to exercise independent judgment and show initiative.

Registrations, Licensure Requirements or Certifications:

N/A

Initial Screening Criteria:

Graduation from an accredited 4-year college or university with major coursework in a social science, business, statistical or related field. Education and experience may be substituted for each other, up to four years. Three or more years of experience with acquisition, collection, management, analyses and dissemination of health and human services-related data and/or other large datasets preferred.

Additional Information:

Any employment offer is contingent upon available budgeted funds. The offered salary will be determined in accordance with budgetary limits and the requirements of the HHSC Human Resources Manual. Selected candidates must be legally authorized to work in the U.S. without sponsorship. Selected candidates must be willing to work from an HHS office located in Austin, designated by the hiring manager.

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.

Similar Jobs

More Jobs at Texas Health and Human Services Commission

More Education, Government & Non-Profit Jobs

  • City of Philadelphia
    Commissioner of Labor Relations
    $150K — $250K + excellent benefits package *
    City of Philadelphia
    Philadelphia, PA 19102 (Philadelphia County)
  • State Of Delaware
    Director of Accounting
    $130K *
    State Of Delaware
    Dover, DE 19904 (Kent County)
  • Deputy Building Official
    $80K — $150K + gloucester county government offers an excellent benefit package *
    Gloucester County
    Gloucester, VA 23061 (Gloucester County)
  • Deputy Assessor
    $80K — $150K + gloucester county government offers an excellent benefit package *
    Gloucester County
    Gloucester, VA 23061 (Gloucester County)
  • Civil Engineer II
    $80K — $150K + gloucester county government offers an excellent benefit package *
    Gloucester County
    Gloucester, VA 23061 (Gloucester County)

Find similar Data Analyst V jobs: