Job Information
Lawrence General Hospital Financial Analyst in Lawrence, Massachusetts
As the Financial Analyst, you will research, compiles and analyzes financial information. Creates reports and ensures accurate data integrity. Responsible for statistical, expense and productivity reporting. Provides assistance to both budget and cost accounting functions including the creation of dashboards, the publication and distribution of volume and expense reports and performs various data analyzes to help both the hospital and medical group departments with identifying best practices and improve financial and quality performance.
DUTIES AND RESPONSIBILITIES:
Produce and distribute Statistical Reports on Inpatient and Outpatient activity. Compile and distribute a daily report to key hospital leaders and directors, prepare a weekly Dashboard of Inpatient and Outpatient activity for the Senior Management team as well as compiling the Monthly Executive Summary for Senior Management.
Assist with tracking cost, charge, and reimbursement key performance indicators (KPIs).
Produce ad hoc Statistical Reports as needed.
Responsible for maintaining the Bi-Weekly Productivity reporting function in IDEA Budget Solutions. Including: audit files for accuracy, upload bi-weekly payroll files and statistical files from Meditech into the IDEA Budget Solutions software, maintain the associated job and department dataset files within the software. Generate the Bi-Weekly Productivity Reports for distribution to all department directors and run the VP summaries for distribution.
Assist with statistical reporting and other standard reporting as it relates to Decision Support and Budgeting functions.
Help to manage and support the publication of ongoing Decision Support deliverables and reports, including the development of dashboards.
Provide assistance and support for the budget planning function as needed including distribution of reports, compiling data from multiple systems on volume, expenses and statistics.
Produce ad hoc reports from IDEA Budget Solutions as needed.
Assist with monthly cost accounting process for the Hospital and medical group.
Responsible for maintaining the Position Control Database on a weekly basis. Including; auditing job codes and titles for accuracy, upload a current listing of employees and hours from Meditech into the Access database, verify all positions are included, print and distribute reports to department directors.
Work with Human Resources and department managers to maintain the accuracy of the Position Control database.
Identify monthly expense variances and work with department directors to prepare the expense variance report for Finance Committee.
Ensure data integrity in any reports, projects and activities.
Provide support to Finance department and assist as needed in any relevant projects.
EDUCATION AND RELATED EXPERIENCE:
Required:
Bachelor’s Degree in Business Administration, Accounting, Finance or Healthcare Administration.
Minimum of 2 years of healthcare experience.
Excellent MS Excel skills and working knowledge of MS Outlook, Office, PowerPoint, Word, Project and relational databases.
High aptitude for analytical reasoning.
Excellent verbal and written communication skills.
Preferred:
Experience with business intelligence software, such as MicroStrategy, TIBCO Spotfire, Tableau, DOMO, Power BI, etc.
Experience with MS Access databases and/or Structured Query Language (SQL).