World Vision International

This job is no longer available.

You can view related vacancies or set-up an email alert notification when similar jobs are added to the website using the buttons below.

FP&A System Specialist

Job Description

PURPOSE OF POSITION:

This position maintains the Global Center’s budget system for multi-year planning, forecasting, annual budgets and monthly reports (i.e. Adaptive Insights) and also provides financial systems needs for Financial Planning, Reporting & Analysis (FP&A) to prepare WVI Board reports, Partnership Flash reports, Global Center Financial reports and other ad hoc reports to the FP&A Director using accurate data. The position will also provide consistent actual, target, budget and forecast data for the budgeting and forecasting process to FP&A business partners. The Datewarehouse Systems Lead (at FRSC, Manila) will provide oversight for this position and this person will liaise with designated FP&A management within the organization.

KEY RESPONSIBILITIES:

Adaptive System Administration:

  • Manage and administer the budget systems (Adaptive Insights) by implementing and monitoring the application, designing database hierarchy view, attributes and dimensions.

  • Maintain the system by coping and cloning the necessary background formulas and data for future use.

  • Manage access controls for users.

  • Open and close the system for data entry during planning, budgeting and forecasting.

  • Ensure Adaptive Connectors imports monthly Actual Expenditure data correctly in to the system from OLAP Cube and validated for accuracy and in sync with GL, GFR, FFRs. Etc.,

  • Coordinate and work with Adaptive (Vendor) as it relates to the integrity of the system and provide them with the necessary assumptions and changes as needed to address any maintenance issues and administration of the application.

  • Design, create and maintain Adaptive Dashboard reports as directed by FP&A Director.

  • Design and develop the necessary prototype models (in Adaptive systems) according to approved annual budgeting and quarterly forecasting processes and guidelines.

  • Upload budget and forecast data into the system. Review and ascertain that uploaded numbers are reconciled with the approved target and forecasts. Resolve discrepancies and other issues with FP&A business partners.

  • Consolidate data, design and prepare standard and various ad hoc reports, briefings and presentations for the FP&A Director including (but not limited to), GC Business Unit Leaders, WVI Board, CFO, GCFR, Flash Report, WVI account analysis reports, etc.

  • Master User & Trainer - Prepare and provide system related training for all end users.

KNOWLEDGE, SKILLS & ABILITIES:

  • Bachelor’s degree in Accounting / Finance and at least 4 years experience.

  • Experience and skills in systems with Microsoft analysis tools such as Power Pivot and Power Query.

  • Good understanding of relational database and able to translate organizational structure into the system.

  • 2 - 3 years of experience in managing Finance/Accounting systems.

  • Preferred minimum of 2 years of experience in Financial Planning and Analytical Models.

  • Demonstrated ability to think independently and recommend best practices.

  • Systems and Database Administration.

Preferred:

  • Good understanding of relational database and able to translate organizational structure into the system.

  • Excellent communication skills, both verbal and written.

  • Superior organization, prioritization, and self-motivation skills.

  • Strong computer skills. MS Office Suite.

Work Environment/Travel:

  • The position requires ability and willingness to travel domestically and internationally up to 5% of the time.