- Analyze financial data and provide - planning - budgeting and forecasting support
- Prepare reports and projections based on analysis
- Prepare waterfall analysis , profitability analysis
- Handle small markets P&L ( planning , budgeting , forecasting and actual review )
- Building financial models
- Own, maintain, and run monthly consolidation management reporting, a macro-automated spreadsheet process with over 10 entities and granular P&L
- Roll forward and setup of monthly reporting outputs in Google Sheets: close reporting, business review content, trend reporting, and charting
- Creation and maintenance of spreadsheet templates and tools to support forecast, budget, and multi-year planning
- Build interfaces to automate the inclusion of data from multiple source systems (eg, Salesforce, Workday, activity reporting, Capex)
- Extract financial data from the Onestream system and format it into presentable data points as required by leadership
- Become an authority on the financial system hierarchy and alignment of data from other reporting systems
- Support future state reporting projects
5+ years experience working within an FP&A environment; familiarity understand and worked on Budgeting , forecasting , Actual closing , P&L analysisWorked on financial modelingSignificant working experience in applied advanced Excel (must-know functions: SUMIFS, INDEX, MATCH & INDIRECT)Intermediate to advanced Visual Basic for Applications (VBA): variables, loops, arrays, user inputs; methods and properties of the range, worksheet, and workbook Excel Application objectsAbility to extract, cleanse, manipulate, and map large volumes of data from a multi-dimensional financial reporting system; navigate a product/function/cost center/account hierarchy.Experience rolling up large consolidations, devising checks and tools to systematically isolate and resolve discrepanciesA desire to learn and work primarily within a Google Sheets environmentAbility to business partner with local teams to educate, embed processes, promote alignment, and provide supportA keen focus on automation and centralization of data collection and reporting output processesEfficiency mindset, systematic and organized approach, process documenterDesirable:Experience working within a Google Sheets environmentKnowledge of GoogleScript / JavaScript codingOnestream experienceExperience producing dashboards, charting and other visualizations