Finance Analyst

Scope of Role & Responsibilities

• Develops data tables and participates in analyses of project requests in support of the Finance Department.
• Recommends programs, practices, and standards to facilitate uniform application of electronic data.
• Prepare financial analyses on various aspects of the financial operations of the Plan including revenues, expenses, utilization, and membership.
• Supports the Department Analytical Staff
• Prepare schedules and worksheets for the Plan's regulatory financial reporting requirements (MMCOR, MLR, VBPTR).
• Prepare profit and Loss Statements
• Prepare revenue analysis
• Monthly, quarterly, yearly medical expense reconciliation
• Prepare quarterly review presentations
• Prepare projection analyses on claims and utilization, including underlying trends and risk analysis
• Create detailed analysis outlining findings, opportunities, and solutions for the end user
• Gather, interpret, and use complex data to develop actionable items
• Research, analyze, and report different trends
• Dashboard creation and maintenance
• Complex data mining
• Special projects and other related duties as assigned

Required Education, Training & Professional Experience

• Bachelor’s Degree with a minimum of 2 years of experience Industry related (business, health care, consulting, insurance, government) or relevant coursework
• SQL query experience preferred
• Complex formula and data tabulation Excel experience preferred
• MICROSOFT HEALTHCARE FINANCIAL MANAGEMENT (MMCOR) experience strongly preferred
• VBA experience strongly preferred
• Medical Management Cost Reporting (MLR) experience strongly preferred

Professional Compentencies

• Integrity and Trust
• Customer Focus
• Functional/Technical skills
• Written/Oral Communication