Department of Civil Service

Description:

OMH Strategic Finance and Managed Care group is seeking a qualified candidate to fill a graduate research analyst position within the Bureau of Managed Care Finance and Data Analytics. The position requires 100% onsite work. No telecommuting option is available.

Skills Needed:
1. Ability to build code in SAS, and SQL; knowledge of Microsoft Excel, Word
2. Skills of doing data report visualization using Tableau.
3. Ability to extract, clean and building relational tables by using health care data
4. Ability to communicate in written and spoken English
5. Ability to work in a team environment
6. Ability to run health care data model to replicate and evaluate the operational process of MH program.
Job Duties:
1. Assist in the data collection and processing of Plans' submissions of reports requested by OMH.
2. Assist in the workflow of data collection, management and uploading into databases of Adult and Children provider universe.
3. Formulate summary templates for management reports.
4. Write SAS codes and create Tableau visualization workbooks of management reports.
5. Run quality assurance tests prior to distribution.
6. Assist in various report production, SAS coding, and data modeling of ad-hoc requests pertaining to MH service utilization and costs.
7. Run routine and ad-hoc reports/data analyses to respond to specific questions from stakeholders pertaining to Adult and Children' networks.
8. Assist in creating market data and ancillary files necessary to migrate network analyses to the Provider Network Data Systems (PNDS) using SAS, SQL or other statistical software.

Internship Areas:

Managed Behavioral Health, Medicaid, Information Technology, Planning/Analysis/Research, Geographic mapping systems, Data Analysis and Modelling, Quantitative Research Projects

Skills:

Ability to build code in SAS, and SQL

Communication

Independent worker

Research

Critical Thinking

Internship Areas: Planning/Analysis/Research, Public Policy, Scientific Research