Sr Financial Data Analyst

Baystate Health•Springfield, MA

11h•Hybrid

About The Position

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 purpose s 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. Thie role will be 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.

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 independe ntly 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 for this position.
Analytical and detail oriented, Audit-minded thought process
Advanced knowledge of Excel functions and formulas
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

Nice To Haves

Knowledge in dashboard applications such as Power BI, Tableau, etc. a plus

Responsibilities

Financial Analysis and Report Development
Leverages relationships and collaboration across finance division to build a high level of trust and collaboration in report dev elopment , analysis , and timely delivery
Interprets financial, accounting , and contractual information to ensure accuracy of data used in repor ting, 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 a nd guidance of other associates
Presents data driven financial information and succinctly communicates analytic observations to internal and external stakeholders
Evaluates and r esearches departmental data needs by engaging stake holders and identifying inefficiencies/waste, ri sks 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
Works in partnership with the finance business areas to create comprehensive documentation (SOPs) , training, and identify key dependencies
Communicates to stakeholders and leadership on project s tatus , outcomes , and improvements
Provides ad-hoc reporting and analysis for financial, governmental, pharmacy, and administrative data used in strategic decision making