Data Analyst IV - Advanced Analytics & Reporting - 100% remote (20814)

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.

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.

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.

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.

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.

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