Health Services Data Analyst

Texas Health & Human Services Commission•Austin, TX

1d•$6,378 - $8,582•Hybrid

About The Position

The Data Analyst V reports to the Manager of the Medicaid CHIP Reporting unit in the Data Dissemination and Reporting section of the Office of Data, Analytics and Performance (DAP). The DA V performs highly complex (senior level) data analysis to inform policy and program decisions related to Medicaid acute care. The DA V consults with internal and external customers to identify and support Medicaid data reporting needs. Using standard statistical tools, methods and techniques, the DA V compiles and queries service utilization, provider and other Medicaid acute care data sets; creates original programming logic and evaluates and/or modifies existing programs to take into account changes in requirements; and reviews work products developed by other analysts. Interacts with agency Program staff, division managers, and/or other analysts to ensure requirements are met and that all work products are appropriately reviewed and validated. Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data. Provides data validation and integrity checks for program data. The DA V prepares concise, comprehensive technical reports to present and interpret the data for program staff, leadership, advisory committees and other stakeholders. Reviews project deliverables to ensure compliance with customer needs and agency/department policies. The DA V serves as a resource for colleagues and is a key contributor in a complex and crucial data analytic environment. The DA V works under limited supervision with considerable latitude for the use of initiative and independent judgment.

Requirements

Knowledge of reporting and analytic tools such as Business Objects, SAS, SPSS, Snowflake, and SQL.
Knowledge of HHSC program data and reporting.
Knowledge of data quality and integrity processes.
Skill in communicating with individuals at all levels on technical issues.
Ability to work and communicate effectively with others.
Ability to gather, assemble, correlate, and analyze facts; to devise solutions to problems; to prepare concise reports; develop and evaluate policies and procedures.
Ability to perform detailed work accurately and in accordance with standards.
Ability to meet deadlines and work on projects with changing priorities.
Ability to read and understand requirements/design specifications and propose logical solutions to meet requirements/specifications.
Ability to operate effectively as a member of a team managing multiple projects.
Ability to read, interpret, and analyze existing documentation and reports.
Ability to create/maintain technical documentation of work/project assignments.
Ability to interpret and report on data analytic findings.
Ability to exercise independent judgment and show initiative.
Graduation from an accredited 4-year college or university with major coursework in a social science, business, statistical or related field.
Three or more years of experience with acquisition, collection, management, analyses and dissemination of health and human services-related data and/or other large datasets preferred.
Education and experience may be substituted for each other, up to four years.

Responsibilities

Provides suggestions regarding systematic changes that will improve the efficiency and quality of data analysis processes.
Assesses data quality by identifying any missing, erroneous, incongruent, or duplicate data in data sets used by the unit.
Coordinates with other internal groups within DAP or other areas to improve data quality.
Consults and provides requirements for the improvement of data collection systems and the methods used to perform data analytics.
Determines the most effective method to address a given data request, construct a performance measure, or monitor various service trends.
Compiles and manipulates data points using SQL, SAS, or other languages from a variety of source formats, to support complex analyses related to monitoring Medicaid programs.
Cleans and prepares data to produce datasets required for data analysis.
Oversees the interpretation of analysis results to inform the team’s presentations and reports of the results.
Prepares comprehensive standard and ad-hoc reports, in written, graphical and oral format, for internal and external audiences.
Ensures accuracy of data included in reports.
Engages with a variety of people across the agency to build strong relationships and to find creative solutions to analytic projects.
Utilizes communication skills to gather the information necessary from customers to assess and address their needs.
Explains analysis results in clear and non-scientific language as necessary to ensure that customers can leverage the information in decision-making.
Coordinates with program subject matter experts and leadership to both ensure accuracy in approach for the analysis and to inform staff of findings in a timely manner.
Serves on agency committees and workgroups as an SME consultant for Medicaid data.
Prepares and updates standard operating procedures and processes for reporting.