Finance Analyst

With 75 years of experience, our focus is on helping the most vulnerable children overcome poverty and experience fullness of life. We help children of all backgrounds, even in the most dangerous places, inspired by our Christian faith.

Come join our 33,000+ staff working in nearly 100 countries and share the joy of transforming vulnerable children’s life stories!

Key Responsibilities

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.

Major Responsibilities

• 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 Smartsheet. 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.
  
  

• 3 - 5 years of experience in Finance or Accounting, preferably in a non-profit environment.
• Preferably 2 years of minimum experience in Financial Reporting and Analysis.
• 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.
• Certification in Advanced Excel, PowerBI and PowerPoint Presentation is preferred.
• Proficiency in using Smartsheets, Microsoft Forms, and Sharepoint is preferred.