Senior Financial Planning & Analysis Analyst

The Crom CorporationGainesville, FL
1d

About The Position

Senior FP&A Analyst role is critical in bridging the gap between raw data and executive decision-making. The ideal candidate will have a proven track record of consolidating financial statements and dashboard reporting across multiple entities or business units, with super-user experience with Excel, Power Point, Power Query, Power-BI and/or other dashboard reporting systems. You will be responsible for building automated reporting solutions, supporting the annual budgeting process, and providing deep-dive variance analysis to ensure the company has a clear picture of the factors driving financial results. Candidate must be located in one of CROM’s eastern time zone offices: Gainesville FL, Raleigh NC, Highpoint NC, West Palm Beach FL, or Chattanooga TN.

Requirements

  • Bachelor’s degree in Finance, Accounting, or Data Analytics.
  • 5+ years of progressive experience in FP&A, Accounting or Corporate Finance. Attention to detail is a must.
  • Proficiency with ERP systems and advanced Excel. Ability to translate complex datasets into simple, actionable visual stories for both financial and non-financial stakeholders. Expert-level Power BI skills (DAX, Power Query, Data Modeling) preferred.
  • Hands-on experience with multi-entity consolidations..

Nice To Haves

  • MBA or CPA/CFA preferred.

Responsibilities

  • Financial Consolidation & Reporting: Support the month-end, quarter-end, and year-end consolidation of financial results across a growing portfolio of divisions and entities
  • Ensure accurate mapping of General Ledger (GL) data into consolidated financial statements (P&L, Balance Sheet, Cash Flow).
  • Produce PowerPoint decks for month-end financial reporting and quarterly Board meetings
  • Prepare Management Discussion & Analysis (MD&A) that sheds light on what is going on behind the numbers.
  • Power BI Report Automation: Design, develop, and maintain advanced Power BI dashboards to track financial, commercial and operational performance
  • Automate manual reporting processes by connecting Power BI to various data sources (ERP, CRM, and Excel).
  • Write DAX measures and utilize Power Query (M) to transform data into meaningful measurements and reports
  • Prepare materials for senior management and PE investors, focusing on KPIs, identifying and interpreting trends and patterns in datasets, and recommending actions and solutions.
  • Budgeting & Forecasting:
  • Manage and enhance a 3-statement financial model to produce rolling monthly forecasts, as well as managing and enhancing a detailed 13-week cash forecast
  • Partner with department heads to develop annual budgets
  • Analyze variances between actuals and forecasts, providing "the story behind the numbers" to senior leadership.
  • Strategic Analysis:
  • Perform ad-hoc financial modeling and "what-if" scenario analysis to support decision making and strategic initiatives.
  • Supporting M&A activities and financial modeling
  • Identify trends, risks, and opportunities for margin improvement or cost-savings.
  • Other duties as assigned.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service