Finance Analyst

MetroPlusHealth provides the highest quality healthcare services to residents of Bronx, Brooklyn, Manhattan, Queens and Staten Island through a comprehensive list of products, including, but not limited to, New York State Medicaid Managed Care, Medicare, Child Health Plus, Exchange, Partnership in Care, MetroPlus Gold, Essential Plan, etc. As a wholly owned subsidiary of NYC Health Hospitals, the largest public health system in the United States, MetroPlusHealth's network includes over 27,000 primary care providers, specialists and participating clinics. For more than 30 years, MetroPlusHealth has been committed to building strong relationships with its members and providers to enable New Yorkers to live their healthiest life.

Position 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 to regulatory requirements. Also 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.

• 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
• Develops data tables and participates in analyses of project requests in support of the Finance Department.

• 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

• Functional/Technical Skills
• Written/Oral Communications
• Customer Focus
• Integrity and Trust

#LI-Hybrid