Data Analyst IV

The Data Analyst IV is selected by and reports to the Manager of the Medicaid CHIP Data Analytics (MCDA) Visualization Team within the Office of Data, Analytics, and Performance (DAP). The position provides key research and analytical and reporting functions for the MCDA Visualization Team to support the identification of anomalies relating to clients, providers, service utilization, payment methodologies, and compliance with Medicaid/CHIP contract requirements. The position performs highly advanced Medicaid/CHIP program research activities under minimal direction with extensive latitude for the use of initiative and independent judgment.

The position plans and/or conducts highly advanced program evaluation on the agency's Medicaid/CHIP programs; coordinates project design, planning, statistical analysis, visualizations, and/or reporting; and writes advanced scripts and code for computer-based statistics applications. The position provides consultation and assistance to MCDA, DAP, and Medicaid/CHIP staff in developing methods and strategies for more effective reporting of Medicaid related data and analyses, including developing and monitoring performance measures and applying statistical sampling methods. The position also prepares a variety of reports, studies, visualizations, or other deliverables containing analyses of Medicaid services data, methods, procedures, and relevant sources to the administration and understanding of Medicaid/CHIP program and issues. Essential Job Functions:

Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned.

EJF (30%) 1. Designs, develops, and maintains MCDA dashboards and reports utilizing data visualization tools and Medicaid CHIP data to monitor the administration of Medicaid and CHIP services. Prepares and reviews a variety of written, oral, and graphical deliverables containing analysis of Medicaid/CHIP data, methods, procedures, and relevant sources to the Medicaid/CHIP administration and policy analysis to provide data analytics, data trends, and improve the Division's contract management.

EJF (30%) 2. Compiles, queries, and loads data using SQL and other query languages, into databases from a variety of source formats.

Writes advanced scripts for statistical applications and applies statistical sampling methods. Provides data integrity by identifying data gaps, errors, anomalies, inconsistencies, and redundancies in the content, structure, and relationships within data; cleans and prepares data, as necessary.

EJF (20%) 3. Consults with data analysts, program staff, and executives to understand the business requirements that drive the analysis and design of the dashboards and reporting solutions.

Coordinates project design and planning for projects. Collaborates with data analysts, program staff, and executives to analyze and interpret data patterns, analyze data trends and anomalies, understand correlations between data sets, gauge progress toward targets, review contract compliance and performance measures, provide recommendations for key research findings, and conduct program evaluation using Medicaid CHIP data.

EJF (10%) 4. Actively contributes to the continuous improvement of department processes through ongoing initiatives including: solutions to automate, building efficiencies, monitoring and maintaining consistency across multiple dashboards. Trains others and serves as subject matter expert on data integrity processes, data visualization tool usage, new techniques in data processing and analytics, and best practices; provides support for data visualization tool related questions, requests, and issues.

EJF (10%) 5. Assists with preparing and conducting presentations of MCDA dashboards and reports. Drives the selection of data visualization tools, the development of standards, usage guidelines, and procedures for those tools; and assist with data visualization tool system administration monitoring and upgrades.

Knowledge Skills Abilities:

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 (e.g., 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, geographical concepts and their application to data analytics.

Skill in using SAS, SPSS, SQL, ACCESS, Business Objects or other statistical and database management software.

Knowledge of database design, querying and reporting tools.

Knowledge of data visualization tools.

Skill in communicating with all levels of staff with varying degrees of technical knowledge.

Ability to establish and maintain effective working relationships with all levels of staff.

Ability to prepare concise reports.

Ability to plan, organize, and conduct data analytic projects.

Ability to work in a team and to communicate effectively.

Ability to develop and interpret statistical data charts, maps, and tables.

Ability to interpret and publish data analytic findings.

Ability to exercise independent judgment and show initiative.

Ability to maintain detailed and organized documentation of data analytic projects.

Ability to communicate effectively and professionally both orally and in writing.

Ability to provide excellent customer service and demonstrate diplomacy in dealings with others.

Registration or Licensure Requirements:

N/A Initial Selection Criteria:

Bachelor's degree or equivalent in natural sciences, health sciences, social sciences, or related field. Master's degree in any of these areas preferred.

At least two years of work experience with acquisition, collection, management, analyses, and visualization of large data sets, preferably involving health or human service data. Master's degree in applicable field can substitute for two years of work experience. Additional Information:

Texas residents may be eligible for telework. MOS Code:

There are no direct military occupation(s) that relate to the responsibilities, and registration or licensure requirements for this position. All active duty, reservists, guardsmen, and veterans are encouraged to apply if they meet the qualifications for this position.

HHS agencies use E-Verify. You must bring your I-9 documentation with you on your first day of work.

I-9 Form - Click here to download the I-9 form.

In compliance with the Americans with Disabilities Act (ADA), HHS 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.

Top 10 Tips for Success when Applying to Jobs at HHSC and DSHS