Data Analyst IV - Advanced Analytics & Reporting - 100% remote

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:

Data Analyst IV - Advanced Analytics & Reporting - 100% remote Job Title:

Data Analyst IV Agency:

Health & Human Services Comm Department:

Data Mgt and Reporting Posting Number:

20814 Closing Date:

11/01/2026 Posting Audience:

Internal and External Occupational Category:

Computer and Mathematical Salary Range:

$5,425.33- $7,155.75 Pay Frequency:

Monthly Salary Group:

TEXAS-B-24 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:

701 W 51ST 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 Job Summary

The Texas Health and Human Services Commission (HHSC) is seeking experienced candidates for a Data Analyst IV - Advanced Analytics & Reporting position within Access & Eligibility Services (AES), Data Management & Reporting team. The position supports HHSC’s mission to connect Texans to essential services by delivering advanced analytics, ensuring data quality, and providing operational decision support to internal teams. Data Analyst IV functions as a senior individual contributor and hybrid analyst/mentor. The role performs complex analytical work under minimal supervision, applies independent judgment, mentors and reviews the work of other analysts, and delivers clear, actionable insights to non‑technical stakeholders. These positions do not have formal supervisory authority. Essential Job Functions (EJFs)

Advanced Analytics & Insight Generation (30%)

Performs advanced SQL analysis to identify trends, patterns, and performance drivers. Develops predictive and trend analyses to support operational planning and proactive decision‑making. Translates complex analyses into clear findings and actionable recommendations for internal stakeholders. Creates reusable analytical methods and standardized approaches to improve efficiency and consistency. Data Quality & Validation (25%)

Designs and executes data validation, reconciliation, and quality audits across SQL Server, Oracle, and Snowflake. Establishes and documents data quality rules, business definitions, and acceptance criteria. Partners with business and technical teams to resolve data quality issues and prevent recurrence. Monitors key data quality indicators and supports continuous improvement efforts. Operational Decision Support & Reporting (20%)

Develops and maintains Power BI semantic models, dashboards, and reports tailored to business needs. Provides clear data narratives, briefings, and written summaries in plain language. Implements Power Automate workflows to streamline recurring reporting and operational processes. Supports self‑service analytics while ensuring usability, accuracy, and performance. Data Pipelines & Performance (15%)

Designs, optimizes, and troubleshoots ETL/ELT pipelines across multiple data platforms. Collaborates with peers on data modeling and performance tuning. Contributes to future‑state analytics solutions, including readiness for Databricks adoption. Mentorship & Peer Review (10%)

Mentors and reviews the work of lower‑level data analysts. Shares best practices for SQL, data modeling, validation, visualization, and documentation. Assists with onboarding and skill development for analysts within the team. Knowledge, Skills, and Abilities (KSAs)

Skill in advanced proficiency in SQL, including complex queries, window functions, and performance tuning. Skills in Power BI, including data modeling, DAX, and dashboard development. Skill in designing and supporting ETL/ELT data pipelines. Skill in using Power Automate to support operational workflows. Strong understanding of data quality, validation, reconciliation, and documentation practices. Ability to perform predictive and trend analysis aligned with business needs. Ability to communicate complex technical information clearly to non‑technical audiences. Demonstrated accuracy, attention to detail, data integrity, curiosity, and problem‑solving skills. Ability to work collaboratively with business analysts, developers, and program staff. Ability to exercise independent judgment and work effectively with minimal supervision. Ability to perform predictive or trend analysis in an operational or program environment. Knowledge of health and human services or government/public sector settings. Knowledge in working with Snowflake and cross‑platform SQL environments (SQL Server and Oracle). Skilled with R, Python, SPSS, and advanced Excel. Registrations, Licensure Requirements, or Certifications

Microsoft Power BI Data Analyst Associate (PL‑300) – Preferred Microsoft Fabric Analytics Engineer Associate (DP‑600) – Preferred Microsoft Power Platform Functional Consultant (PL‑200) – Preferred Certified Analytics Professional (CAP) – Preferred IIBA Certification in Business Data Analytics (CBDA) – Preferred DAMA Certified Data Management Professional (CDMP) – Preferred Initial Screening Criteria

Two (2) years of professional experience as a data analyst performing advanced SQL analysis, data transformation, advanced reporting (Power BI or Tableau), and data quality validation. Minimum of four (4) years of relevant professional experience. Additional Information

This position is 100% remote within the State of Texas. Candidates must reside in the State of Texas by their official start date. Visa sponsorship is not available for this position. Employees must maintain reliable internet connectivity and webcam capability during work hours. Selected applicants must pass a background check and other required due diligence. 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 View phone number on click.appcast.io. 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.