Data Analyst V

The Data Analyst V reports to the Manager of the Aging and Disability Reporting team 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 for Medicaid Long-term Care programs. The DA V consults with internal and external customers to identify and support Aging and Disability data reporting needs. Using standard statistical tools, methods and techniques, the DA V compiles and queries service utilization, provider and other long-term care data sets. Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data. Provides data validation and integrity checks for long-term care 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. This position will guide the data analytic work of other team members. The DA V works under limited supervision with considerable latitude for the use of initiative and independent judgment.

Essential Job Functions (EJFs): EJF 1. Data Quality/Integrity: 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. 25% EJF 2. Data Analysis: 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 Long-term Care programs. Cleans and prepares data to produce datasets required for data analysis. 20% EJF 3. Reporting: 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. 20% EJF 4. Customer Focus and Communication: The Analyst 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. 20%

EJF 5. Special projects and assignments as assigned/required: Serves on agency committees and workgroups as an SME consultant for long-term care data. Prepares and updates standard operating procedures and processes for long-term care reporting. (15%)

Knowledge of reporting and BI tools: Cognos, Crystal Reports, Business Objects, etc. Knowledge of data bases such as Oracle, Access and/or SQL Server. Knowledge of HHSC program data and reporting. Knowledge of data quality and integrity processes. Knowledge/Skill with Excel macro development a plus. Skill in creating SQL statements for creating data sets and data base modifications. Skill in Data Warehouse, Cognos, PL/SQL, Snowflake a plus. Skill in communicating with individuals at all management 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. Education and experience may be substituted for each other, up to four years. 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., Any employment offer is contingent upon available budgeted funds. The offered salary will be determined in accordance with budgetary limits and the requirements of the HHSC Human Resources Manual. Selected candidates must be legally authorized to work in the U.S. without sponsorship. Selected candidates must be willing to work from an HHS office located in Austin, designated by the hiring manager.