Robert Half Management Resources is recruiting for technical FP&A Manager or Financial Reporting and Automation Manager consultant to support our real estate client on a Contract engagement focused on modernizing a complex cash flow forecasting and reporting process. This role is ideal for a technically strong, detail-oriented finance specialist who can evaluate an existing Excel-based model, identify inefficiencies, and build practical automation solutions that improve speed, accuracy, and visibility. The selected consultant will help transform a time-intensive monthly process into a more dynamic and reliable forecasting environment while partnering closely with leadership on recommendations and knowledge transfer.
Responsibilities:
- Evaluate a business-critical cash flow workbook and identify opportunities to streamline forecasting, reporting, and recurring financial updates.
- Examine how budget inputs, reconciliations, and property-level financial activity are currently maintained, then redesign the workflow for greater efficiency and control.
- Build automated solutions using Excel and appropriate technologies such as AI-enabled tools, scripting, bots, or workflow platforms to reduce manual effort.
- Develop logic that allows updates to core assumptions, including revenue changes, budget revisions, and operating activity, to cascade through the model accurately.
- Enhance the intake and transformation of recurring profit and loss data, budgets, and related financial information used in reporting.
- Improve the reliability and timeliness of forecasting outputs by reducing repetitive data entry and manual model maintenance.
- Support consolidated reporting across multiple property-level schedules and summary views within the existing financial model.
- Prepare clear process documentation and deliver knowledge transfer to leadership so the solution can be maintained effectively after implementation.