Financial Analyst

This position will report to the Manager of Global Financial Analysis and assist the Director of Finance in global reporting & analysis. This person will be focused on financial and management reporting, budgeting and special projects. The position is located in Arlington, Virginia and allows for a hybrid work schedule in coordination with supervisor.

 

The person will have the following job responsibilities:

·        Assist in monthly financial close by preparing reports for REH directors, including P&Ls and key metrics using in-house reporting tools

·        Preparing monthly PowerPoint presentations for the REH senior leadership and the Executive Board using ThinkCell

·        Consolidating and validating data from various reporting tools and creating interactive dashboards in Excel using slicers and pivot charts

·        Manipulating large dataset (50k+ rows) in Excel and then extracting analysis and key information

·        Looking at operational data on clients and projects to identify revenue drivers

·        Assisting in the yearly budget and quarterly forecasting process and corporate strategy initiatives

·        Preparing ad hoc reports as requested

·        Working with business partners across Global Environmental Consulting Firm Environment & Health   and providing financial analysis as needed

 

Opportunities associated with this position:

·        Work in a global organization with reporting done in various currencies

·        High visibility to leadership, including Finance Director, Executive & Managing Directors

·        Own projects and drive the change needed to improve and streamline processes

 

Qualifications include:

·        1-2 years of experience in financial planning & analysis or corporate finance role

·        Bachelor’s in Business or Accounting/Finance

·        Advanced Microsoft Excel skills required, including v/h/x-lookups, nested if formulas, pivot tables, manipulation of large data set, slicers, pivot charts etc.

·        Experience with reporting, and PowerPoint presentation

·        Experience with Power BI, ThinkCell, Microsoft PowerBI, Deltek Maconomy, IBM Cognos, Jedox a plus

 

The successful candidate will have the following attributes:

·        Recent grad or 1-2 years of  professional work experience  

·        Bachelor’s in Business or Accounting/Finance

·        Advanced Microsoft Excel skills required, including v/h/x-lookups, nested if formulas, pivot tables, manipulation

·        Ability to communicate findings of complex analyses

·        You are self-driven, proactive and take responsibility for controlling the agenda in your area

·        You have a business focused approach and structure information to meet the needs and understanding for the intended audience, be it top management, colleagues or project managers

·        You produce workable solutions to a range of problems and demonstrate an understanding of how one issue can be part of a bigger picture

·        You establish timely assessment of risk and opportunities and transform these into high quality recommendations or solutions

 

Typical assignments are to drive development of the reporting in dialogue with leadership teams and local and global business finance colleagues, ensure deadlines for reporting are kept, providing input for different reports and presentations, working with developing reporting tools (e.g., Power BI) for automated and integrated reporting solutions with the reporting systems team.