Data Analyst V

Functional Title: Data Analyst V Job Title: Data Analyst V Agency: Health & Human Services Comm Department: DAP Analytics & Decision Sup Posting Number: 20755 Closing Date: 02/26/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: Austin 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

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 Family Support Services Data Analytics (FSSDA) Manager, the Data Analyst V performs highly complex (senior level) data collection, research, reporting, and analysis to monitor, evaluate, and increase efficiencies for Family Support Services (FSS). Work involves gathering and analyzing requirements, report design and implementation, and ongoing maintenance of existing reports and processes. The analyst will work with other FSSDA 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):

EJF 1 Extracting data from IMPACT, CLASS, PEIRS, IMARC, CAPPS(HR), or other agency databases. Designing, validating, and implementing report methodologies for FSS while documenting processes and procedures for technical and non-technical users. Developing programming code and report design to ensure user requests are properly translated into useful reports. 40%

EJF 2 Preparing data, as necessary, to produce data required for data visualization software products and developing associated dashboards. Participating in data system design meetings for new agency initiatives to provide strategic guidance and ensure the agency's ability to report relevant data. Interacting routinely with agency program staff, division managers, and other analysts to provide strategic guidance so requirements are met, and work products are appropriately reviewed and validated. 40%

EJF 3 Performing quality assurance tasks to ensure the accuracy of reports created by colleagues within the division for distribution to the agency or the public. Providing suggestions regarding systematic changes that will improve the collection of data and align data infrastructure with business needs. Providing routine updates on the status of projects and initiatives. 20%

Knowledge, Skills and Abilities (KSAs):

Knowledge of:

• 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 FSS 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, Snowflake, Business Intelligence tools, and/or Python.

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, Snowflake, or other database development tools. Experience with Tableau or other data visualization tools. Experience and education may be substituted for one another, up to four years. Experience with data and applications related to development of Family Support Services program reports and visualizations is preferred.

Additional Information:

Candidate must also pass fingerprint and criminal background check.

Nearest Major Market: Austin

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.

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.