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

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

Benefits offered by this job

100% paid employee health insurance

Defined benefit pension plan

Generous time off

Career advancement opportunities

Job summary

The Texas Health and Human Services Commission seeks a Data Analyst IV to advance analytics, data quality, and reporting for AES, Data Management & Reporting. The role develops predictive insights, validates data quality across Snowflake/SQL Server/Oracle, and delivers decision-support dashboards.

You will mentor analysts, design ETL/ELT pipelines, and promote self-service analytics with clear data narratives. This is a 100% remote position within Texas.

Qualifications

• 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.

Responsibilities

• 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.
• Mentors and reviews the work of lower‑level data analysts.

Skills

Advanced SQL

Power BI

ETL/ELT pipelines

Power Automate

Data quality

Data storytelling

Collaboration

Tools

Snowflake

SQL Server

Oracle

Power BI

Job description

Date: Sep 2, 2026
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: Data Analyst IV - Advanced Analytics & Reporting - 100% remoteJob Title: Data Analyst IVAgency: Health & Human Services CommDepartment: Data Mgt and ReportingPosting Number: 20814Closing Date: 11/01/2026Posting Audience: Internal and ExternalOccupational Category: Computer and MathematicalSalary Range: $5,425.33 - $7,155.75Pay Frequency: Monthly
Salary Group: TEXAS-B-24Shift: Day
Telework: Eligible for TeleworkTravel: Up to 5%Regular/Temporary: RegularFull Time/Part Time: Full timeFLSA Exempt/Non-Exempt: Exempt
Job Location City: AUSTIN
Job Location Address: 701 W 51ST ST
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.

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.

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