*Please submit your CV in English.
PURPOSE OF THE POSITION:
This position provides key financial planning and analysis to Financial Planning, Reporting, and Analysis – Global Centre (FPRA-GC) team and various ExL groups/GC departments. This position will create and analyse complex reports, dashboards, and analysis along with engaging in the planning, budgeting, and forecasting processes. This position requires the use of analysis tools like advanced Excel knowledge, Power Pivot, Power Query and Power BI. This person will liaise with designated FPRA-GC management within the organization.
Provide timely financial analyses and reports for specific ExL groups/GC departments as assigned by FPRA-GC Manager/Director. This also includes creating and designing ad-hoc analysis and reports. Collaborate with Datawarehouse team to ensure data models used in the analyses and reports are accurate and meets the needs of the users. The focus is on continuous improvement of existing reports, creating and providing new/emerging analysis.
This requires the use and understanding of tools like OLAP, Excel, Power Query, Power BI, and Smartsheets. This also requires an understanding of different partnership data sources (PBAS, SunSystems, Horizon, Our People, Adaptive, etc) and how these relate to each other.
Review and validate monthly GC GL information that is loaded into Adaptive Insights for use in FPRA-GC reports and provide GC leadership with a view of the financial status. Coordinate with Corporate Accounting and/or other GC departments to resolve discrepancies and other issues.
Assist with monitoring and review of budgets, forecasts, and actuals of GC departments through development and use of tools and reports/dashboards. This includes bilateral projects, PBAS commitments, and chargebacks. Provide variance explanations to FPRA-GC BPs and senior leadership.
Coordinate with FPRA-GC BPs in developing and executing the annual planning and budgeting processes including chargebacks. Develop and maintain financial models, forecasting tools, and other analytical tools for business segments.
Other duties as assigned by the FPRA-GC Manager/Director.
KNOWLEDGE, SKILLS AND ABILITIES:
3 - 5 years of experience in Finance or Accounting, preferably in a non-profit environment.
Can thrive in a multi-cultural, geographically dispersed work environment.
Able to work with several functional managers or stakeholders.
Advanced skills in Microsoft Applications especially Excel and PowerBI.
Proven ability to analyse data in order to provide clear summaries and insights, and the ability to recommend solutions and correction to errors and data integrity issues.
Bachelor’s degree in Accounting / Finance.
Preferred Skills, Knowledge and Experience:
Preferably 2 years of minimum experience in Financial Reporting and Analysis.
Certification in Advanced Excel, PowerBI and PowerPoint Presentation is preferred.
Proficiency in using Smartsheets, Microsoft Forms, and Sharepoint is preferred.
The position requires ability and willingness to travel domestically and internationally up to 5% of the time.