Excel Data Analyst Jobs (NOW HIRING)

Job Description
Description:
SCOPE:
The client 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 client 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.
Objectives to Be Fulfilled by Candidate:
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 client leadership. Continuously engages in process improvement to support client, and Office-wide strategies, objectives, and initiatives. Collaborate with other client 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 (RANK IN ORDER OF IMPORTANCE):
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 (RANK IN ORDER OF IMPORTANCE):
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.
REQUIRED EDUCATION: MASTER'S DEGREE IN DATA SCIENCE, PUBLIC HEALTH, STATISTICS, HEALTH INFORMATICS, OR RELATED FIELD.
ADDITIONAL SKILLS:
SUPERB WRITTEN AND ORAL COMMUNICATIONS SKILLS, INCLUDING THE ABILITY TO RELAY MODERATELY COMPLEX TECHNICAL INSTRUCTIONS AND REQUESTS.
EXPERIENCE WORKING IN A CROSS- FUNCTIONAL TEAM ENVIRONMENT.
ABILITY TO EFFECTIVELY COMMUNICATE WITH TEAM MEMBERS, TECHNICAL TEAM,
KEY STAKEHOLDERS, AND VENDORS.
Notes:
Onsite
VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status