Department of Civil Service

Description:

1. Develop a reporting template and specification document for Utilization Review (UR) Denials.
2. Assist in Webinar and all forms of communication with MCOs to submit reports.
3. Follow-up with MCOs with deficient reports.
4. Coordinate with OMH IT in reviewing submissions, manage the workflow from collection, development, QA, to production of the database.
5. Frame up a summary report for OMH leadership/OMH Medical Director/stakeholders for distribution.
6. Prepare SAS codes and tableau visuals for report processing.
7. Run data analysis and visualization in SAS and tableau.
8. Run quality assurance tests prior to distribution.
9. Run Adhoc reports/data analyses to respond to specific questions from stakeholders/leadership.
10. Assist in other routine and adhoc data processing related to networks, First Episode Psychosis, and costs and utilization of MH services.
11. Assist in the production of a qualitative research paper derived from the project.

Skills:

1. Ability to code in SAS, SAS SQL

2. Use of Tableau, Excel, Microsoft Word

3. Knowledge of Medicaid, Beh Health

4. Managed Care, Value-Based Payment

5.Written and verbal English proficiency

Internship Areas: Health Services, Human Services, Information Technology, Planning/Analysis/Research