Financial Planning & Analysis Manager

Description

Summary:

Financial Planning & Analysis (FP&A) Manager reports directly to the Chief Financial Officer (CFO). The FP&A Manager will assist the CFO with the annual budget, monthly forecasts, as well as all aspects of active / prospective markets, operational, commercial, treasury, and financial reporting, planning, analysis, and modeling, over short-term and long-term.

Essential Duties and Responsibilities:

• Lead annual budget process, and ongoing monthly forecasting, including monthly sales, financial forecasts, and capital planning in Vena Corporate Performance Management (CPM) System
• Issue monthly FP&A reporting book, including financial trend analysis, P&L and CapEx budget-to-actual variances, working capital trends, and EBITDA adjustments, leveraging technology including Sage, Vena, PowerBI, and other systems
• Actively manage 13-week cash flow forecast to support operating, investing, and financing activities, coordinating with CFO on annual forecast by month, leveraging Sage, Vena, PowerBI, and other systems
• Assist CFO with the development of Sales & Operational Planning (S&OP) processing, including 16-week sales forecast in Vena, monthly sales forecasting annually, inventory allocation and gross margin forecasting, and supply/demand planning by channel
• Assist CFO with the development of company weekly/monthly Key Performance Indicators (KPIs) across Commercial, Operations, and Corporate divisions to be reported consistently, completely, and accurately via technology and systematic reporting
• Assist CFO with Merger & Acquisition (M&A) Buy-Side Due Diligence processes, as applicable, including Virtual Data Room (VDR), M&A modeling, and scenario analysis
• Assist CFO and HR Director with incentive compensation, including monthly incentives for retail staff via Sparkplug application and monthly wholesale sales commissions
• Assist CFO with quarterly reporting to Bank (covenants), Board of Managers (deck preparation), and other investor relations
• Develop and maintain financial models and related financial templates, supporting current and future operations, including 5-year market based and supply-side models
• Ensure timely ROI / IRR / MOIC on Capital Expenditures (CapEx) & Operating Expenses (OpEx), with assistance from accounting & finance staff
• Coordinate with CFO, Controller, and IT on the design and maintenance of ongoing PowerBI subscriptions, dashboards, and systematic reporting
• Proactive focus on implementing automation and efficiencies into finance processes, reducing manual workflows and driving economies of scale leveraging technology.

Business Partnership:

• Partner with Commercial leadership for commercial reporting and analysis, including monthly Retail Procurement planning, weekly Retail 4-Wall reporting, and other analytics
• Partner Operations leadership for operations reporting and analysis, including supply/demand modeling, purchasing budgets, inventory management, SKU-level margin analysis, and produce volume mix analysis
• Partner with Operations, Commercial and IT on integration of data sets into "one source of truth" for ongoing reporting and analysis, leveraging native/custom APIs
• Coordinate with Controller, Retail / Wholesale Purchasing Manager(s) on working capital planning for both retail and wholesale.
• Coordinate with CFO, Controller, and IT to drive Business Intelligence (BI) tools, including PowerBI, from "one source of truth" in SQL/Azure, with API system integrations
• Assists Controller and CFO in preparation of annual financial audit and quarterly cost accounting audits
• Assists Controller and CFO in preparation of quarterly income tax estimates, annual income tax returns, investor K-1s and other tax reporting under 280E/471C
• Support pricing and product profitability analysis at wholesale and retail levels, coordinating with Commercial & Operational teams in partnership with CFO & Controller
• Partners with CFO, IT, and external BI consultants/developers as needed on the design of PowerBI dashboards with underlying Sage data.
• Partners with Controller, CFO and IT on automating the reporting of data using technology, including Sage, Concur, Ramp, Vena, SQL / PowerBI, and other technologies.
• Partner with CFO, Controller, and IT to streamline and automate accounting & finance processes through Robotic Process Automation (RPA), Generative Artificial Intelligence (Gen AI), PowerAutomate, CoPilot, or other Financial Technology (FinTech) systems
• Assist CFO, Controller, and leadership team with project-based initiatives as applicable, including value-added ad hoc strategic analysis, as applicable

Requirements

Relevant Knowledge, Skills, and Abilities:

• Bachelor's degree from an accredited university in Accounting and/or Finance
• Master's degree / MBA preferred, not required.
• CPA and/or CFA required
• Expert level Excel User required, with data-driven system approach preferred (SQL, Open DB Connectivity (ODBC)) and modeling best practices
• Expert level User of Other Microsoft Office Products preferred, including PowerBI, Visio, PowerPoint, SharePoint, PowerApps, PowerAutomate, CoPilot and Teams
• Experience with Corporate Performance Management (CPM) solutions preferred, such as Vena, Anaplan, Adaptive Insights, Planful or similar
• Data-driven systematic approach to reporting, analysis, and forecasting leveraging technology and automation
• Additional relevant software experience valued, including Tableau, Alteryx, or similar
• Experience with SaaS-based ERP systems preferred, such as Sage Intacct, Process Pro, Oracle NetSuite, Microsoft Dynamics AX 365 or similar
• 5+ years of experience working in accounting or finance preferred, including in corporate environment, external/internal audit, or related professional services field
• Experience required with financial forecasting, financial modeling, and budgeting
• Ability to develop financial models, including research into new market activities utilizing data subscriptions and strategy development as provided by leadership team
• Vested interest in learning new skills, including PowerBI, RPA, GenAI, or other FinTech
• Excellent communication skills, written and verbal
• Growth mindset and positive attitude
• Ability to work independently or with a group, including reporting to the executive leadership team.
• Experience working in a licensed medical marijuana business, Consumer Packaged Goods (CPG), Healthcare, or highly regulated industry preferred (FDA, other)
• At least 21 years of age with the ability to pass a background check

Physical Requirements:

• Standing and moving for 2-3 hours at a time
• Long periods of prolonged sitting and standing
• Long periods of prolonged use of office equipment including computers and phones
• Requires normal range of hearing & manual dexterity to operate a computer
• May require lifting up to 25 pounds occasionally

Work Environment:

• Similar to a busy office environment
• Constant interaction with internal and external stakeholders
• Optional part-time remote work, based on candidate

Firelands Scientific is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.