HR Reporting Data Analyst

Austin, United States

Date: Sep 16, 2025

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: HR Reporting Data Analyst
Job Title: Data Analyst III
Agency: Health & Human Services Comm
Department: HR STAFF
Posting Number: 9260
Closing Date: 10/16/2025
Posting Audience: Internal and External
Occupational Category: Computer and Mathematical
Salary Group: TEXAS-B-22
Salary Range: $4,801.16 - $6,281.33
Pay Frequency: Monthly
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 III performs moderately complex data analysis work. Analyzes HR data and produces custom workforce reports on a recurring and ad-hoc basis. This role uses SQL, SQR, and SuccessFactors to extract recruitment data, maintains an Access-based repository for report tracking, and implements automation to improve report production. The analyst supports data validation, visualization, documentation, and small improvements to day-to-day operations, collaborating with stakeholders to ensure timely and accurate reporting. Works under general supervision with limited latitude for the use of initiative and independent judgment.

Essential Job Functions (EJFs):

EJF 1 — Custom workforce reporting, scheduling, and distribution (25%)

Creates and runs custom workforce reports on a recurring (daily/weekly/monthly) and ad-hoc basis.
Develops reports using SQL and SQR; validate results and ensure alignment with stakeholder needs.
Documents each report’s purpose, data sources, and main metrics; maintains a distribution list.
Manages reports in an Access database for tracking and governance.
Explores and implements automation to reduce manual reporting effort.

EJF 2 — Recruitment data extraction (10%)

Extracts recruitment data from SuccessFactors (SAP) and other data sources to support reporting needs.
Validates recruitment data accuracy and completeness for hiring analytics.

EJF 3 — Data design, storage, and maintenance (15%)

Designs, creates, and maintains Access, Oracle, and other relational databases for data extraction and tracking.
Compiles, queries, and modifies databases to support reporting and analysis needs.

EJF 4 — Data quality, validation, and governance (15%)

Monitors data quality; identifies discrepancies and coordinates remediation.
Validates data changes, especially during fiscal year-end periods, and ensures data integrity across systems.

EJF 5 — Data visualization and analytics (20%)

Analyzes visualization needs; prepares data sets and tables; uses Tableau or other tools as needed.
Supports basic dashboard creation and refinement; stays informed about visualization best practices.

EJF 6 — Documentation, training, and collaboration (15%)

Creates and maintains documentation of processes, reports, and data flows.
Collaborates with colleagues on reporting procedures, data governance, and tools used.
Collaborates with stakeholders to gather feedback and improve processes.

Knowledge, Skills and Abilities (KSAs):

Knowledge of common practices and techniques for the electronic exchange of data.
Knowledge of database management systems such as Microsoft Access, Oracle, and SQL Server/SQR query tools.
Knowledge of relational databases. Knowledge of Internet Information Server (IIS)
Knowledge of and familiarity with personal computer hardware and peripheral equipment.
Knowledge of data processing practices and theory.
Knowledge of research design, methods, principles, techniques and philosophies.

Knowledge of data visualization tools.

Skills in database management systems such as Microsoft Access, Oracle, and SQL Server/SQR query tools. Skills in utilizing Microsoft Office Suite of products, including Excel, Access, SharePoint. Skills in planning, scheduling and prioritizing work assignments.
Skills in written and verbal communications.
Skills in writing and testing code, including new and maintenance.

Skills in using data visualization tools.

Ability to prepare ad hoc reports. Ability to develop and review functional design documents, write SQL statements and interpret screen results.
Ability to analyze complex procedures and data.
Ability to evaluate technical data and develop logical conclusions.
Ability to prepare and present comprehensive reports and recommendations in written and oral form.
Ability to communicate, coordinate and gain rapport with external and internal business partners.
Ability to analyze functional/design requirements and to develop solutions to implement the requirements.
Ability to perform detailed work accurately and in accordance with standards.
Ability to meet deadlines and work on projects with changing priorities.
Ability to draft concise reports, with visual representations.
Ability to extract, organize, quality check and manage datasets.

Registrations, Licensure Requirements or Certifications:

Initial Screening Criteria:

Graduation from a four-year college or university with major coursework in data science, business analytics, computer science, computer information systems, management information systems, or a related field is generally preferred. Experience performing any of the following functions: data analysis, research, data compilation, data reporting, structured query language and query tools for developing ad hoc and recurring reports and education may be substituted for one another on a year for year basis.

Experience performing any of the following functions: data analysis, research, data compilation, data reporting , structured query language and query tools for developing ad hoc and recurring reports, is required.

Experience reviewing and developing functional design documents, writing sequel statements and interpreting screen results.

Experience using Microsoft Office products, including MS Excel and MS Access.

Experience with data visualization software. Experience using Tableau is preferred.

Experience using PeopleSoft/Oracle human capital management systems preferred.

Experience with business intelligence packages, software programs and data visualization tools generally preferred.

Additional Information:

This position has the capability to telework on a part-time basis. Selected candidate must have the ability to provide a personal home internet service. The selected candidate must also have a home office location free from distractions that will provide the ability to ensure confidentiality of work product.

Salary Note: The salary offered will follow HHSC starting salary guidelines. Any employment offer is contingent upon available budgeted funds.

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

Similar jobs