Data Analyst IV

Job/Position DescriptionData Analyst IVThe Data Analyst IV is selected by and reports to the Manager of the Medicaid CHIP Data Analytics (MCDA) Performance, Monitoring, and Analytics (PMA) Team within the Office of Data, Analytics, and Performance (DAP). The position provides key research and analytical and reporting functions for the MCDA PMA 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 agencyand#146;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, data sets, 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 FunctionsAttends 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 reports and responds to ad hoc requests using 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 routine and ad hoc 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 reports. Trains others and serves as subject matter expert on data integ https://jobshrportal.hhsc.state.tx.us/ENG/CareerPortal/job_profile.cfm?szOrderID=619859 Copy the URL in the preceding sentence to an Internet Explorer browser to apply to the job directly through the Texas Health and Human Services Career Portal.