Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Consolidation specialists in Financial Planning & Analysis are responsible for consolidating, analyzing, reviewing, and preparing financial data Mercer Operations & Technology. They ensure compliance with internal controls and close processes, prepare month-end accounting and internal management reporting, and help to produce consolidated financial statements. A FP&A Consolidations Specialist is an established, independent individual contributor, whose work has a direct impact on the team's outcomes.


Job Profile Description :


Monthly reporting:
Runs monthly reports (adjusted P&L summary and detail) from HFM. Compares the revenue, expense, and NOI with the Flash report to determine that the two systems agree. Reconcile general ledger and month end reports and be able to reconcile and resolve issues.


Analytical/reporting responsibilities:
supports the consolidation team with variance analysis immediately following month-end as part of the control environment; provides Functional Leadership with monthly and YTD analysis of key cost drivers supporting actual vs budget expense variances; includes providing an understanding of run rate expenses, internal/operating company business initiatives as well as cost efficiency initiatives and their impact on the results; reviews expense allocations and allocation methodologies as appropriate.


Budgeting/Forecasting:
supports consolidation team on budgeting/forecasting input, processing, reporting and analytical requirements (both capital and P&L); performs Excel and query-based analyses of financial data; initiates, develops and implements improvements to financial reporting processes.


Controllership coordination:
coordinates with Controllership on the monthly financial close; includes coordinating preparation of journal entries (which are processed by Controllership), coordinating on account reconciliations and account analysis; reviews all general ledger activity related to the function(s) and coordinates and/or provides month end accruals as appropriate.