Review and monitor project budgets identifying areas of over and underspend; record the daily financial activity for each project
Investigate project variances and submit variance reports to management
Prepare financials for project stage gate governance processes
Schedule period actual review meetings with Project Managers on budget and resource adjustments
Assist Project Managers in creation and completion of TCOs, Email PMs regarding actuals
Process end of period reconciliations and accruals
Utilize complex Excel template for financial analysis on supported projects.
Receive and process invoices against a project's supplier purchase orders.
Complete monthly cost analysis to include actual-vs.-budget analysis, cost-to-complete analysis and various requirements
Update and publish monthly actual FTE reports
Review capital interest calculations based on capital expenditures and purchases
Report to management regarding the remaining funding available for projects
Requirements:
5+ years in project accounting or project financial/budget analyst role
Experience managing and tracking the costs of projects, analyzing budget vs actual and performing forecasting and variance analysis while working directly with Project Managers
Experience posting accruals for projects and understanding capital vs, operating expenses, and US GAAP
Must have Advanced Excel skills with ability to use short cuts, including pivot tables, vlookups, formulas, index match, conditional formatting, filter, etc.
Must be thick-skinned and able to handle difficult conversations with PM's when needed
Must have exceptional communication skills to be able to clearly communicate with PM's and team