Senior financial analyst [h1.location_city]

Sr. Financial Data Analyst

Note : The compensation range(s) in the table below represent the base salaries for all positions at a given grade across the health system. Typically, a new hire can expect a starting salary somewhere in the lower part of the range. Actual salaries may vary by position and will be determined based on the candidate's relevant experience. No employee will be paid below the minimum of the range. Pay ranges are listed as hourly for non-exempt employees and based on assumed full time commitment for exempt employees. Minimum - Midpoint - Maximum $96,137.00 - $110,510.00 - $130,728.00

Summary :

Location : 1 Monarch Place; Springfield MA - Option for remote in approved state. Schedule : Monday-Friday; Dayshift; 40hrs per week

Job Description

This position is responsible for maintaining and adhering to internal controls, ensuring compliance with applicable laws and regulations, and following Health New England's entity level policies and procedures. The position is responsible for reporting unethical or fraudulent activity related to business operations and adhering to Health New England's Code of Conduct. The Sr. Financial Data Analyst serves as the primary contact for financial data, for purposes including but not limited to Health Service Fund reporting & reconciliation for Provider organizations, and Regulatory reporting for State and Federal Entities. This role requires a combination of both technical skills in data analysis and business acumen to understand financial concepts. This role will be required to translate contract provisions into financial models and interprets regulatory reporting requirements for accurate completion. The Sr. Financial Data Analyst is a senior level individual contributor role and reports to the Finance Manager.

Essential Functions

Financial Analysis and Report Development :

• Leverages relationships and collaboration across finance division to build a high level of trust and collaboration in report development, analysis, and timely delivery
• Interprets financial, accounting, and contractual information to ensure accuracy of data used in reporting, analysis, and forecasting
• Utilizes software including Microsoft SQL Server and / or SAS to perform queries utilizing the data warehouse, to refresh financial models and regulatory reports (monthly, quarterly, and annually)
• Performs financial reconciliations of expenses, revenue, and membership data
• Resource for other members of the department / division on data-based business processes and may be responsible for training and guidance of other associates
• Presents data driven financial information and succinctly communicates analytic observations to internal and external stakeholders
• Evaluates and researches departmental data needs by engaging stakeholders and identifying inefficiencies / waste, risks, and key person dependencies
• Identifies areas of opportunity to further enhance financial processes and data mining to better align with the corporate wide strategy of Caring, Simplification, and Affordability

Ad-hoc Analysis and Finance Support :

Minimum Requirements

Bachelor's degree in Finance or Accounting or a related field and more than 5 years of financial or analytical experience preferably in an HMO, insurance or healthcare environment. Effective at managing competing priorities and can work independently with little oversight. Ideal candidate will be self-motivated and self-starting. Strong analysis, critical thinking, and troubleshooting skills. Experience with data interpretation, analysis, and reporting. Experience with both financial and clinical data, and complexities of models for various types of provider value based risk contracts. Experience with allocations and ratios, product mix, and risk adjustment concepts. Experience with SQL and / or SAS. Ability to write and run complex requires is required for this position. Analytical and detail oriented, audit-minded thought process. Advanced knowledge of Excel functions and formulas. Knowledge in dashboard applications such as Power BI, Tableau, etc. a plus. Able to work multiple projects at one time and meet tight deadlines. Ability to work independently as well as part of a team. Excellent oral, written, and communication / presentation skills.

Education

Bachelors Degree (Required)

Certifications

Equal Employment Opportunity Employer

Baystate Health is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, marital status, national origin, ancestry, age, genetic information, disability, or protected veteran status.