Revenue Analytics Analyst I

Hawaii Medical Service Association; Honolulu (HI); Hybrid; USD 65,000 - 90,000; Full time

Job summary

Hawaii Medical Service Association in Honolulu is seeking a Data Analyst to support revenue analysis, enrollment data flow, and risk adjustment payments across lines of business. The role emphasizes data collection, validation, and model testing to understand revenue implications of regulatory changes and market trends.

The position requires strong communication, Excel proficiency, and the ability to document procedures for audits in a hybrid work setting.

Qualifications

• Effective verbal and written communication skills.
• Intermediate working knowledge of Microsoft Office applications, including Word, Excel, Outlook, and PowerPoint.

Responsibilities

• Runs reports assisting analysis of premium revenue, risk adjustment payments, and other revenue streams related to lines of business.
• Gathers and validates financial and enrollment data from internal and external sources.
• Supports RAF and financial data needs of program through data collection and organization.
• Runs data for models to assess the impact of regulatory changes, enrollment trends, and market dynamics on revenue.
• Variance analysis: identify variances between actual and projected revenue, providing follow up opportunities for further research.
• Reconciles that reporting adheres to internal policies and regulatory guidelines.
• Builds and maintains conceptual level knowledge of revenue structures and regulations.
• Follows appropriate documentation of desktop procedures for reconciliation and audit needs.
• Performs all other miscellaneous responsibilities and duties as assigned or directed.

Education

Bachelor's degree and three years of related experience; or an equivalent combination of education and related work experience.

Tools

Microsoft Office (Word, Excel, Outlook, PowerPoint)

Job description

Hawaii Medical Service Association in Honolulu is seeking a Data Analyst to support revenue analysis, enrollment data flow, and risk adjustment payments across lines of business. The role emphasizes data collection, validation, and model testing to understand revenue implications of regulatory changes and market trends.

The position requires strong communication, Excel proficiency, and the ability to document procedures for audits in a hybrid work setting.