Finance Analyst

Finance Analyst

Job Ref: TE0127

Category: Professional

Department: ANALYTICS AND REPORTING

Location: 50 Water Street, 7th Floor, New York, NY 10004

Job Type: Regular

Employment Type: Full-Time

Work Arrangement: Hybrid

Salary Range: $60,457.00 - $66,457.00

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 Compentencies

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

#MPH50

#LI-Hybrid