Financial Data Integrity Analyst-Int

Job Number 64831
Posted 1/15/2020
Account Northern Light Health Home Office
Department Financial Planning
Location |ME| Northern Light Health Home Office-43 Whiting Hill Rd., ME 04412
Schedule Regular Full-time
Shift Day
Hours 8-430

The Intermediate Financial Planning Analyst provides a range of services in the Financial Planning & Analysis department of the Home Office. This professional works as part of a team and is responsible for completing system maintenance and data integrity services for the Business Finance and Analytics division. Collaborates with Home Office and Member staff to achieve superior financial analysis and reporting. The Intermediate Financial Planning Analyst may be requested to support various committees or task forces to advance the interests of Northern Light Health.

The Intermediate Financial Planning Analyst will work closely with the Director to support the needs of the Associate Vice President Finance & Analytics, Vice President of Finance, Chief Financial Officer and internal and external clients related to Northern Light Health.

In this role, the Intermediate Financial Planning Analyst must demonstrate and promote excellent customer service, responsiveness, oral and written communication, accurate and supported analysis, and project management skills. To be successful, the individual in this position must be:

· an effective communicator and trainer providing support to all Northern Light Health Members to optimize utilization of the NLH budgeting, forecasting, decision support & other EPSi modules.

· provide timely input and analysis into the decision-making process during the development of the various financial plans.

· able to continually demonstrate a thorough understanding of financial operations and proficiency with the budgeting, forecasting, and capital planning tools.

· a role model in the delivery of services that are deemed to be superior in the eyes of the customers.


EPSi System Administrator

The Intermediate Financial Planning Analyst will ensure integrity of the EPSi system across all modules. The Intermediate Financial Planning Analyst may be directed to perform the following duties:

· Assist with daily system data loads and required maintenance.

· Reconcile data to core systems and to other EPSI modules.

· Develop and document daily and monthly system audits and update as needed.

· Prepare and distribute audit reports.

· Provide technical and analytical support to the system teams responsible for data and transaction mapping.

· Coordinate with partner departments to schedule system updates.

· Perform system testing before and after system updates.

· Support Business Finance and Analytics team with internal and third-party vendor help desk tickets.

· Support Business Finance and Analytics team with the maintenance of a strong well-managed security program for access to EPSi.

· Assist as needed with the development and updating of training manuals and procedures documentation.

Operating Budget

The Intermediate Financial Planning Analyst will support the development of the operating budget with ongoing system maintenance and variance reporting. The Intermediate Financial Planning Analyst may be directed to perform the following duties:

· Serve as in-house expert, super-user and trainer on the operating budget system, understanding data links with Lawson/Infor and other systems, validation, budget development and variance reporting.

· Stay up to date with Financial Planning software structure and detailed data elements. Participates in software upgrade testing and document results. Recommends options if issues arise. Assists with implementation and deployment of new software functionality.

· Complete the monthly processing tasks in a timely manner to ensure that the standard reports and dashboards from the financial decision support system are published within the expected timeframe.

· Monitor data feeds into the system to ensure integrity.

· Proactively monitor system performance to identify risks and opportunities.

· Collaborate with cross-functional teams in conjunction with budgeting and forecasting process.

· Review tables daily to validate completeness of data.

· Review current data fields coming into the system and determine areas where additional data fields can be added.

· Validate data is clean and create workflow when issues identified with data.

· Perform other operating budget duties as assigned.

· Create database management procedures

Capital Budget

The Intermediate Financial Planning Analyst will support the development of the capital budget, ongoing system maintenance, and materials needed for the decision-making process. The Intermediate Financial Planning Analyst may be directed to perform the following duties:

· Provide analytical support to the Capital Review Committee which oversees capital allocations and approvals and post-implementation reviews. Prepare cost benefit analysis of capital projects.

· Assist with Capital Budget reports for Finance Committee and Board review.

· Compile and analyze capital budget expenditures.

· Suggest capital budget limits and targets.

· Perform other capital budget duties as assigned.

Financial Planning Services

The Intermediate Financial Planning Analyst will support the development of the long-range financial forecast, ongoing system maintenance and related analyses. The Intermediate Financial Planning Analyst may be directed to perform the following duties:

· Assist in the preparation of the long-range financial forecast.

· Monitor data for positive and negative business and financial trends and proactively alert Director to potential problems and/or opportunities.

· Integrate new acquisitions, business ventures, and programs into the financial planning processes.

· Support operational performance improvement projects through validation of baseline measurements and targeted goals, measurement of actual results, and performance reporting.

· Develop and present analytical summaries, educational topics, etc., in a professional manner.

· Maintain system-wide policies and procedures related to financial planning.

· Stay current on upgrades and functionality enhancements and ensures that systems are compliant with Information Technology and Information Security Office policies and procedures.

· Provide information and assistance to other departments or leaders as needed.

· Perform other financial planning special projects and job duties as assigned.

Department Participation

· Acts as an effective team member with Business Finance & Analytics staff.

· Establish professional development goals with Director.

· Completes accurate time tracking information.


Possess excellent customer service, time management, and analytical skills. Written communication skills required as well as project organization. Must maintain institutional, customer and Financial Projects, Planning & Analysis department confidentiality. Ability to excel in teams and succeed in a matrix organization. Oral presentation skills a plus. Demonstrates initiative, a professional attitude and a desire toward self-improvement.

Bachelor's degree in Accounting or related field and a minimum of five years accounting or financial experience required. Health care experience a plus. Knowledge of SQL, SQL Report Writer, Queries, etc. preferred.

A working knowledge of financial statement preparation and analysis required. Demonstrates knowledge of projection methodologies and relationships between goals and finances. Must possess analytical and problem-solving skills as well as the ability to coordinate the work of others and communicate effectively (both in writing and verbally) with all levels of management in a multi-corporate structure.

Demonstrates proficiency in Microsoft Excel, Microsoft Word, Microsoft PowerPoint and Microsoft Access and willingness to keep current with new computer software/technology for the continuous improvement of financial planning processes. Experience with Allscripts EPSi and Infor (Lawson) systems preferred.

Demonstrates the ability to work in a fast-paced environment, prioritize multiple tasks, and meet deadlines with accuracy and attention to detail. Shows capacity to be flexible and competent as priorities change. Demonstrated effectiveness in succeeding in a team-oriented culture required.


Passion: We demonstrate a passion for caring for others and the pursuit of service excellence in all that we do.

Integrity: We commit to the highest standards of behavior and doing the correct thing for the right reasons.

Partnership: Working together in collaboration and teamwork is more powerful than working alone.

Accountability: We take a responsible and disciplined approach to achieving our priorities and responding to an ever-changing environment.

Innovation: We are capable of extraordinary creativity and are willing to explore new ideas to achieve our healthcare mission.

Respect: We respect the dignity, worth and rights of others.


· Sedentary: Exerting up to 10 lbs. occasionally, sitting most of the time, and only brief periods of standing and walking.

· Requires the ability to travel to member organizations as needed.

Note: the duties listed above reflect many of the essential duties of this job and does not, nor is it intended to, reflect all essential duties that may be required for an incumbent in this job to perform.

Equal Opportunity Employment
We are an equal opportunity, affirmative action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, age, disability status, gender, sexual orientation, ancestry, protected veteran status, national origin, genetic information or any other legally protected status.

Please Rate Your Digital Experience