Finance Analyst

MetroPlusHealth; New York (NY); On-site; USD 70,000 - 90,000; Full time

Job summary

MetroPlusHealth in New York seeks a Financial Analyst to provide financial analysis and maintain SQL databases. The role involves preparing financial reports, developing data tables, and performing healthcare financial data analysis in accordance with regulatory requirements. Candidates should have a Bachelor's Degree and at least 2 years of experience or relevant coursework in business, healthcare, or consulting. Skills in SQL, Excel, and VBA are preferred.

Qualifications

• Bachelor’s Degree with a minimum of 2 years of experience in relevant fields.
• Experience with SQL Queries and Excel for complex data tabulations.
• Strong background in healthcare financial analysis preferred.

Responsibilities

• Conduct financial analysis and maintain databases in a SQL environment.
• Prepare financial reports and projection analyses.
• Dashboard creation and maintenance for financial data.

Skills

Financial analysis

SQL query

Communication skills

Data analysis

Excel

Data mining

Education

Bachelor’s Degree

Tools

SQL Server

Excel

VBA

Job description

Overview

Responsible for providing financial analysis and maintaining key databases in a SQL Server environment utilizing SQL Query. Perform health care financial data analysis and reporting in accordance with regulatory requirements. This individual will be responsible for research, collection and analysis of the Plan's utilization and other health care data to coordinate data analysis which will enhance financial data.

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
• Creating detailed analysis outlining findings, opportunities, and solutions for the end user
• Gathering, interpreting, and using 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
• MMCOR experience strongly preferred
• VBA experience strongly preferred
• MLR experience strongly preferred

Professional Competencies

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

#MPH50