Job Description:
***Only W2 resumes are accepted
Work Location: Fully Onsite
Candidate Location: Candidate MUST be a SC resident - no relocation allowed.
SCDHHS is seeking a Business Analyst-Intermediate who is responsible for gathering program requirements to generate monitoring and tracking templates, developing policies and procedures, creating and maintaining recurring reports, and performing data analysis and visualization to inform decision making and investigations related to Managed Care oversight. This position translates, summarizes, and communicates data findings to Bureau and Agency leadership and works collaboratively with other Managed Care staff and internal stakeholders (e.g., IT and systems) as appropriate. The work also includes learning and remaining familiar with the MCO Contract, Report Companion Guide, provider manuals, and policies to ensure appropriate data exploration. The Data Analyst reports to the Director of Targeted Oversight in the Bureau of Managed Care.
DAILY DUTIES / RESPONSIBILITIES:
· Conducts data analysis on program-specified projects using standard data exploration techniques including trend analysis and outlier identification. Ensures data quality through verification of outlying data points. Communicates logic model, data analysis steps, and results from data analysis to program staff and Bureau leadership to ensure understanding.
· Conducts data analysis on grievance and appeals data (for both members and providers), service authorization data, and disputes data sets using standard data exploration techniques including trend analysis and outlier identification. Ensures data quality through verification of outlying data points. Communicates logic model, data analysis steps, and results from data analysis to program staff and Bureau leadership to ensure understanding. Conducts analyses and produces reports for quarterly and annual data within two weeks of plan submission of data. Disseminates analyses to Bureau leadership within one month of plan submission of quarterly and annually submitted data.
· Develops and maintains policies and procedures for the management, verification, and maintenance of data associated with the performance of the Bureau of Managed Care and Managed Care contract.
· Conducts data analysis on contract monitoring data sets using standard data exploration techniques including trend analysis and outlier identification. Ensures data quality through verification of outlying data points. Communicates logic model, data analysis steps, and results from data analysis to program staff and Bureau leadership to ensure understanding.
· Leads or supports other projects proactively or as assigned by Office of agency leadership. Continuously engages in process improvement to support Agency, Division, and Office-wide strategies, objectives, and initiatives. Collaborate with other agency team members in research, development, implementation, and evaluation activities for services, projects, and agency initiatives as assigned. Performs other related duties as required.
· Attends and participates in relevant opportunities for professional development and training. Demonstrates utilization and application of new skills learned to improve effectiveness and efficiency within assigned responsibilities.
· Interacting with internal and external organizations (i.e. vendors, State and Federal government agencies, State providers, and other stakeholders).
· Other project-related duties.
Required Skills
· Knowledge of methods of research design, data collection, data manipulation, data analysis and presentation of information.
· Knowledge of applicable computer software products such as SAS, Excel, and Python.
· Ability to analyze and interpret data using various statistical and mathematical techniques.
· Ability to predict trends and future action based on the analysis of collected information.
· Ability to prepare and present reports communicating the results of data analysis.
· Ability to maintain effective working relationships with others.
· Ability to communicate effectively.
· Ability to learn new content and skills.
Preferred Skills
· Experience with federal or state health data systems (e.g., Medicaid, HRSA, HHS, Census) strongly preferred
· Proficient in data analysis tools and techniques, such as SAS, Excel, data visualization tools, and statistical analysis software