Data Analyst IV

Brief Job Description:

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 serviceutilization 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 agencys 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 andassistanceto MCDA DAP and Medicaid/CHIP staff in developing methods and strategies for more effective reporting of Medicaid related data and analyses including developing andmonitoringperformance measures and applying statistical sampling methods. The position also prepares a variety of reports studies visualizations or other deliverablescontaininganalyses of Medicaid services data methods procedures and relevant sources to the administration and understanding of Medicaid/CHIP program and issues.

Essential Job Functions (EJFs):

EJF (30%) 1. Designs develops andmaintainsMCDA dashboards and reportsutilizingdata visualization tools and Medicaid CHIP data tomonitorthe administration of Medicaid and CHIP services. Prepares and reviews a variety of written oral and graphical deliverablescontaininganalysis 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 Divisions 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 byidentifyingdata 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 andplanning forprojects. 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 initiativesincluding:solutions to automate building efficienciesmonitoringand 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.Assistswith preparing and conducting presentations of MCDA dashboards and reports. Drives theselectionof data visualization tools the development of standards usage guidelines and procedures for thosetools;andassistwith data visualization tool system administration monitoring and upgrades.

KnowledgeSkillsand Abilities (KSAs):

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 geographicalconceptsand their application to data analytics.

Skill in using SAS SPSS SQL ACCESS BusinessObjectsor other statistical and database management software.

Knowledge of database designqueryingand reporting tools.

Knowledge of data visualization tools.

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

Ability toestablishand 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 tomaintaindetailed and organized documentation of data analytic projects.

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

Ability to provide excellent customer service anddemonstratediplomacy in dealings with others.

Registrations Licensure Requirements or Certifications:

N/A

Initial Screening Criteria:

Bachelors degree or equivalent in natural sciences health sciences social sciencesor relatedfield. Masters degree in any of these areas preferred. At least two yearsof work experience with acquisition collection management analyses andvisualizationor presentationof large data sets preferably involving health or human service data.Mastersdegree inapplicablefield can substitute for two years of work experience.