Senior FP&A Analyst - Charlottesville, United States - ProspectBlue

Description

ProspectBlue is partnered with a leading retail and athleisure company based in Charlottesville who is looking for a Senior FP&A Analyst to join its team

The Senior FP&A Analyst should have excellent quantitative and analytical skills and be an expert in Microsoft Excel. The best candidate has substantial experience in FP&A and/or corporate finance and inventory management, ideally in retail or consumer goods, as well as experience with Oracle enterprise reporting tools. Candidate should have exceptional organization skills and attention to detail to own our client's inventory forecast and related review processes effectively. This candidate should also be comfortable pulling raw data, organizing it into a digestible format, and communicating it to inform tactical and strategic decisions. Finally, the candidate should be comfortable creating and managing KPIs for crucial balance sheet / profit and loss accounts and developing, implementing, and managing review processes for each of them.

This role will be based in Charlottesville, VA and will start as soon as possible. This individual will report to our client's Finance Director and work closely with our client's founders, merchandising, design, marketing, and product development teams.

Ideal Requirements:

• College degree required.
• 2+ years of FP&A or corporate finance experience.
• Analytical and quantitative with acute attention to detail.
• Expert at Microsoft Excel and building forecast models from scratch.
• Comfortable owning and improving existing financial models and Excel files.
• Ability to work independently and switch rapidly between projects.
• Self-starter work ethic with a desire to make a positive impact.
• Strong internal and external communication skills.
• Ability to think strategically, advise and impact our client's direction with data-driven analysis.
• Propensity to go above and beyond and think outside the box.
• Openness to change and new ways of solving problems.
• No-task-too-small attitude.
• Trustworthy and full of integrity.

Responsibilities include, but not limited to:

Sales and Inventory:

• Determine quarterly inventory production run quantities by product type based on cash flow projections and strategic goals.
• Calculate monthly inventory balances and forecasted inventory receipts at the item level and partner with merchandising to determine items at risk of stocking out.
• Maintain, update, and improve inventory forecasting tool to aid the merchandising team on in-stock styles for production runs.
• Triangulate inventory shipments with sales projections to determine inventory stock-out dates and flag potential emergency purchase order needs at a product type level.
• Develop process for periodic updates to cost and pricing assumptions across all product types.
• Build and manage weekly and monthly rhythms for inventory reviews by defining KPIs and developing a process to provide periodic updates and strategic recommendations.

Planning and Budgeting:

• Create, own and distribute daily business performance metrics to leadership.
• Build, track, and forecast budgets for all profit and loss accounts.
• Update and maintain cash flow file with new accounts, product types, and key calculations.
• Assist in month close activities by updating income statement actuals and tying out variances to general ledger and enterprise resource planning tool.
• Prepare and analyze cost variances to budgets to inform strategic decision-making.
• Build and manage daily, weekly, and monthly budget review rhythms; define KPIs by budget category and own the consolidation of all financial information to inform these reviews.
• Assist in ERP implementation and develop rhythms for ERP management, including data and budget entry, journal entry preparation and review, and other system needs.
• Take on any ad-hoc analysis from FP&A Manager and cofounders to support strategic decision making.
• (long-term forecasting and modeling of strategic plans).