Finance Analyst - New York, NY

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

Job summary

MetroPlus in New York is seeking a financial analyst responsible for financial data analysis and reporting, maintaining databases in SQL Server. This role requires a Bachelor’s Degree and at least 2 years of experience in industries such as healthcare, insurance, or consulting. The candidate will prepare financial analyses, compliance reports, and dashboards while performing data mining. Preferred qualifications include SQL query experience, Excel expertise, and familiarity with MMCOR and VBA. This position is crucial for enhancing financial data integrity.

Qualifications

• Minimum 2 years of experience in a related industry or relevant coursework.
• SQL query experience preferred for data analysis.
• Experience with complex formulas and data tabulation in Excel.

Responsibilities

• Provide financial analyses for the Plan's operations including revenues and expenses.
• Develop data tables and participate in analyses supporting the Finance Department.
• Prepare presentations and reports for regulatory requirements.

Skills

Financial analysis

SQL query

Excel

Data mining

Dashboard creation

Education

Bachelor’s Degree in relevant field

Tools

SQL Server

VBA

MMCOR

MLR

Job description

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