The Texas Health and Human Services Commission (HHSC) is seeking a Data Analyst IV for the Medicaid/CHIP Data Analytics team in Austin, Texas. In this hybrid role, you will provide advanced research, analytics, and reporting that support performance monitoring, anomaly identification, and program evaluation for Medicaid and CHIP administration.
Working with the Medicaid/CHIP Data Analytics organization, you will design and maintain reporting solutions, perform data integrity checks, and help stakeholders interpret data trends and results. The position also supports the ongoing improvement of department processes through automation and consistent reporting practices.
What you’ll do
- Design, develop, and maintain MCDA reports and respond to ad hoc requests using tools and Medicaid/CHIP data to monitor Medicaid and CHIP service administration.
- Prepare and review written, oral, and graphical deliverables that communicate Medicaid/CHIP data analysis, methods, procedures, and relevant sources for administration and policy analysis, including data trends and improvements that support contract management.
- Compile, query, and load data using SQL and other query languages into databases from a variety of source formats.
- Write advanced scripts for statistical applications and apply statistical sampling methods.
- Support data integrity by identifying data gaps, errors, anomalies, inconsistencies, and redundancies across content, structure, and relationships; clean and prepare data as needed.
- Consult with data analysts, program staff, and executives to understand business requirements that shape routine and ad hoc reporting solutions.
- Coordinate project design and planning for reporting and analytics initiatives.
- Collaborate to analyze and interpret data patterns, identify trends and anomalies, assess correlations between data sets, evaluate progress toward targets, review contract compliance and performance measures, and support program evaluation using Medicaid/CHIP data.
- Contribute to continuous process improvement through initiatives such as automating solutions, building efficiencies, and maintaining consistency across multiple reports.
- Train others and serve as a subject matter expert on data integrity processes, interpreting visual data, new 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, development of standards and usage guidelines, and procedures for those tools; assist with monitoring and upgrades for analytical tool systems.
Requirements
- Knowledge of local, state, and federal laws and regulations.
- Knowledge of programs and services provided by HHS agencies.
- Knowledge of patient level health and demographic data (for example: Census, Vital, Medicaid, and CHIP data).
- Knowledge of data systems and applications used by HHS agencies.
- Knowledge of data analysis techniques.
- Knowledge of scientific research methods, statistical techniques, mathematics, and geographical concepts as applied to data analytics.
- Skill using SAS, SPSS, SQL, ACCESS, Business Objects, or other statistical and database management software.
- Knowledge of database design, querying, and reporting tools.
- Skill interpreting and explaining visual data.
- Ability to communicate with all levels of staff with varying technical knowledge and maintain effective working relationships.
- Ability to prepare concise reports and plan, organize, and conduct data analytic projects.
- Ability to work in a team and communicate effectively.
- Ability to develop and interpret statistical charts, maps, and tables.
- Ability to interpret and publish data analytic findings.
- Ability to exercise independent judgment, show initiative, and maintain detailed documentation of data analytic projects.
- Ability to communicate professionally both orally and in writing and demonstrate excellent customer service.
- Bachelor’s degree, equivalent, or higher degree in epidemiology, statistics, public health, data science, social or natural sciences, or another discipline requiring data management and analysis skills.
- At least two years full-time (or equivalent) experience with acquisition, collection, management, analysis, and presentation of large data sets.
- 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.
Technologies
- SQL
- SAS
- SPSS
- ACCESS
- Business Objects
- tableau
- Microsoft I-9 Form
Compensation and work details
- Location: Austin, TX (hybrid)
- Salary: USD 5,425.33 - 8,886.16 per monthly
- Pay frequency: Monthly
- Travel: Up to 5%
- Telework: Eligible for Telework (telework depends on performance, agency business needs, and policy)
- Regular/Temporary: Regular
- Full time/Part time: Full time
- FLSA status: Exempt
- Shift: Day
Benefits
- 100% paid employee health insurance for full-time eligible employees
- Defined benefit pension plan
- Generous time off benefits
- Numerous opportunities for career advancement
Equal opportunity and compliance notes
- All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified.
- HHSC and DSHS agencies will provide reasonable accommodations during the hiring and selection process for qualified individuals with a disability.
- Depending on the program area and position requirements, selected applicants may be required to pass background and other due diligence checks.
- HHSC uses E-Verify. You must bring I-9 documentation on your first day of work (I-9 form required).
- Outside employment and long-term volunteer work may be subject to review for potential conflict of interest.