Health Data Analyst - OSU Health Plan

Position Description

• Conducts in depth analysis and reporting to inform executive leadership of the Ohio State University Health Plan, Inc (OSU HP) to guide the advancement of key business functions and initiatives of the organization;
• key business areas include, but are not limited to, medical management, behavioral health, finance, provider relations and health and wellness;
• serves as a content expert for at least one functional area and maintains general knowledge of all areas; utilizing industry and functional knowledge and a specific medical management support data warehouse system tool, executes queries of medical and pharmaceutical billing information using predefined report templates and the creation of extensive ad hoc queries to support business needs;
• analyzes data, researches and resolved discrepancies in reporting and presents findings; maintains documents of query findings for future reference;
• participates in decision making regarding system changes and upgrades and new data system or business technology purchases to ensure compatibility with existing data warehouse tool;

contributes to organizational success through membership in a Center of Competency leveraging lessons learned and best practices.

Job Responsibilities

• Provides research and analytical support, serves as content expert for at least one functional area, maintains general knowledge of all functional areas;
• responds to information request from executive leadership and internal and external customers; queries data using data warehouse tool and other information resources utilizing industry knowledge of medical and pharmaceutical billing and reporting;

prepares reports and analyzes data to determine if final desired product is achieved; documents query results for historical purposes.

Resolves discrepancies in reporting; identifies discrepancies in analysis and reporting; researches discrepancies and regenerates queries as necessary, resolves discrepancies and presents final report to executive leadership.

Provides problem resolution for facility claims issues.

Performs other OSU HP duties, acts as backup for other OSU HP analysts as needed; creates and maintains Provider Relations databases;

acts as a liaison for provider contract issues; maintains HRA aggregate data bases; collaborates with the Ohio State University Employee Assistance Program (EAP) to create, implement wellness programs.

Participates in decision-making regarding changes to existing systems; evaluates potential upgrades and new systems to determine compatibility and success of mapping to systems already in use.

Minimum Requirements

Bachelor's degree, or equivalent combination of education and experience required

2 years experience working with health plan administration and / or systems preferred

Analytical experience, including working with medical claims information preferred

Experience working with OSU medical plans and associated business rules preferred

Our Comprehensive Employee Benefits Include

An array of retirement plan options, each with a generous employer contribution.

Affordable health insurance options, including dental, vision and prescription coverage that begin on day one.

Paid vacation and sick leave, including short and long-term disability and paid parental leave.

Get the most out of the Public Service Loan Forgiveness program.

And much more!