Data Analyst IV

Texas Health & Human Services Commission•Austin, TX

1d•$5,425 - $8,886•Hybrid

About The Position

The Data Analyst IV supports the Medicaid/CHIP Data Analytics (MCDA) Performance, Monitoring, and Analytics Team within the Office of Data, Analytics, and Performance. Reporting to the MCDA PMA Team Manager, the position performs advanced research, analytics, evaluation, and reporting to identify anomalies involving clients, providers, service utilization, payment methodologies, and compliance with Medicaid/CHIP contract requirements. The work is performed under minimal direction, with considerable latitude for initiative and independent judgment. The role plans and conducts program evaluations; coordinates project design and planning; performs statistical analysis; develops visualizations and reports; and writes advanced scripts and code for statistical applications. It advises MCDA, DAP, and Medicaid/CHIP staff on reporting methods and strategies, performance measures, and statistical sampling. Deliverables include analyses of Medicaid services data, methods, procedures, and relevant sources to support the administration and understanding of Medicaid/CHIP programs and issues.

Requirements

Bachelor’s degree, equivalent, or higher in epidemiology, statistics, public health, data science, social or natural sciences, or another discipline requiring data management and analysis skills; additional qualifying work experience may substitute year for year.
At least two years of full-time or equivalent experience acquiring, collecting, managing, analyzing, and presenting large data sets.
Knowledge of local, state, and federal laws and regulations; HHS programs and services; patient-level health and demographic data; and data systems and applications used by HHS agencies.
Knowledge of data analysis techniques, scientific research methods, statistical techniques, mathematics, geographical concepts, database design, querying, and reporting tools.
Skill using SAS, SPSS, SQL, Access, Business Objects, or other statistical and database management software.
Skills in interpreting and explaining visual data and communicating with staff at varying levels of technical knowledge.
Ability to establish and maintain effective working relationships; prepare concise reports; plan, organize, and conduct data analytics projects; work in a team; and communicate effectively.
Ability to develop and interpret statistical charts, maps, and tables; interpret and publish analytical findings; exercise independent judgment and initiative; and maintain detailed, organized project documentation.
Ability to communicate professionally, orally and in writing, and provide excellent customer service with diplomacy.
Up to one year of full-time or equivalent subject matter expert experience in Texas Medicaid or CHIP eligibility, enrollment, benefits, programs, or policy may substitute for data experience.

Nice To Haves

More than the minimum education or work experience in a listed field.
Certification in data analysis tools, including SAS, SQL, or Tableau.
Experience with health or human service data.

Responsibilities

Design, develop, and maintain MCDA reports and respond to ad hoc requests using tools and Medicaid/CHIP data to monitor administration of Medicaid and CHIP services.
Prepare and review written, oral, and graphical deliverables analyzing Medicaid/CHIP data, methods, procedures, and relevant sources to support administration and policy analysis, provide data analytics and trends, and improve contract management.
Compile, query, and load data from varied source formats into databases using SQL and other query languages.
Write advanced scripts for statistical applications and apply statistical sampling methods.
Maintain data integrity by identifying data gaps, errors, anomalies, inconsistencies, and redundancies; clean and prepare data as needed.
Consult with analysts, program staff, and executives to understand business requirements for routine and ad hoc reporting solutions.
Coordinate project design and planning; analyze and interpret data patterns, trends, anomalies, and correlations; assess progress toward targets, contract compliance, and performance measures; provide recommendations; and conduct program evaluations using Medicaid/CHIP data.
Contribute to continuous process improvement, including automation, efficiency improvements, and consistency across reports.
Train others and serve as a subject matter expert on data integrity, interpreting visual data, data processing and analytics techniques, and best practices; support analytical questions, requests, and issues.
Assist with preparing and conducting presentations of MCDA dashboards and reports.
Drive selection of analytical tools and development of standards, usage guidelines, and procedures; assist with tool system administration, monitoring, and upgrades.