Data Analyst IV

Texas Health and Human Services; Austin (TX); On-site; USD 80,000 - 110,000; Full time

Job summary

HHSC seeks a Data Analyst IV in Austin, TX to monitor, evaluate, and improve Foster Care Litigation and Child Care Licensing data activities. You will analyze complex datasets, craft concise reports, and develop dashboards that support decision making across program areas.

Responsibilities include data analysis and visualization, data quality management, and preparing court‑ordered and internal reports. You will query data with SQL and other languages, load data, cleanse datasets, and present

Qualifications

• Graduation from an accredited four-year college with data-related major.
• Experience in data analysis, compilation, and/or reporting work.
• Experience with Oracle, SQL Developer, Toad or other database tools preferred.

Responsibilities

• Data analysis and visualization, and development of dashboards for performance reports.
• Prepare standard and ad-hoc reports, including court-ordered and internal/external audience reports.
• Coordinate with program SMEs to ensure accurate reporting tools and data quality.
• Identify data gaps, errors, and anomalies; propose systematic improvements.

Skills

SQL

SAS

ETL tools

Data visualization

Education

Bachelor's degree in data-related field

Tools

Oracle

SQL Developer

Toad

Job description

Overview

Functional Title: Data Analyst IV
Agency: Health & Human Services Commission (HHSC)
Department: DAP Aging & Disability
Location: 4601 W GUADALUPE ST, Austin, TX

Under the supervision of the Performance Monitoring and Analytics Manager, the Data Analyst IV performs complex journey‑level data collection, research, reporting, and analysis to monitor, evaluate, and increase efficiencies for Foster Care Litigation (FCL) activities and initiatives for Child Care Licensing (CCL) within HHSC. The analyst works with program areas to explore system aspects, determines why particular areas are performing well or present opportunities for improvement, and acts as a liaison between RSDA and stakeholders. The analyst crafts concise technical and non‑technical reports, makes recommendations for process improvement, and develops solutions to monitor and implement data quality.

Essential Job Functions

• Data Analysis and Visualization (35%): Conduct detailed analysis of data sets, monitor and ensure data quality, compile, query, and load data points using SQL and other query languages, cleanse and prepare data, and develop dashboards for performance dashboards and reports.
• Reporting (30%): Assist in developing analytic techniques, prepare standard and ad‑hoc reports, including court‑ordered and internal/external audience reports, ensure accuracy of data.
• Coordination (10%): Utilize strong communication skills to explain CCL business processes, negotiate resources, act as liaison, and coordinate with program subject matter experts to ensure accurate reporting tools.
• Data Quality/Integrity (10%): Establish data quality metrics, identify data gaps, errors, anomalies, and redundancies, and coordinate with stakeholders to improve quality.
• Identifies and Implements Improvements (10%): Provide suggestions for systematic changes, update status of projects and initiatives.
• Infrastructure Support (5%): Provide requirements for development and implementation of databases, data collection systems, and analytics strategies, and assist in evaluating RSDA analytic activities.

Knowledge, Skills, and Abilities (KSAs)

• Knowledge of data analysis techniques and best practices.
• Knowledge of, or aptitude to learn, CCL and Foster Care Litigation data.
• Knowledge of data quality and integrity processes.
• Knowledge of database and application design, development, and structure.
• Knowledge of record‑keeping, including security procedures for handling confidential data.
• Knowledge of reporting and visualization tools.
• Skill in complex analytic work, trend identification, recommendation of improvements.
• Skill in using SAS and other query languages.
• Skill in using ETL tools.
• Skill in communicating to technical and non‑technical audiences.
• Ability to work on a team, be flexible and creative, plan and organize analytic projects.
• Ability to develop and interpret data charts, maps, and tables.
• Ability to interpret and publish analytic findings.
• Ability to exercise independent judgment and show initiative.
• Ability to maintain detailed documentation of analytic projects.
• Ability to prepare concise reports.

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/or reporting work. Experience with Oracle, SQL Developer, Toad, or other database development tools preferred but not required. Experience and education may be substituted for one another, up to four years.

Additional Information

Hiring is dependent on passing fingerprinting and a background check.

Disclaimers

Active Duty, military, reservists, and veterans: Military occupation(s) that relate to the initial selection criteria may include, but are 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.

ADA Accommodations: HHSC will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the online application, contact the HHS Employee Service Center at 1‑888‑894‑4747.

Telework Disclaimer

This position may be eligible for telework. 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