Financial Planning Analyst at Pikemann Financial Planning Analyst at Pikemann in Mercer Island, Washington Posted in about 11 hours ago.

Type:

full-time FP&A Consultant (Budgeting & E?Commerce Operations)

Location:

Renton - Hybrid schedule

Duration:

Contract /

Consulting Engagement Department:

Finance & Analytics Role Overview We're seeking a hands?on FP&A Consultant to lead budgeting, forecasting, and financial planning for a fast?growing e?commerce business. This role is deeply operational - partnering with merchandising, marketing, supply chain, and fulfillment teams to build accurate budgets, strengthen financial models, and improve visibility into performance drivers. You'll own the budgeting process end?to?end while building scalable tools, tightening assumptions, and delivering clear insights that help leadership make smarter decisions. Key Responsibilities Budgeting & Forecasting Lead the full annual budgeting cycle, including revenue, COGS, fulfillment, marketing spend, headcount, and operating expenses. Build and maintain driver?based forecasting models aligned to e?commerce KPIs (traffic, conversion, AOV, CAC, repeat rate, return rate). Refresh monthly forecasts based on actuals, trends, and updated business assumptions. Partner with business leaders to validate assumptions, challenge inputs, and ensure alignment across departments. Financial Modeling & Scenario Analysis Develop dynamic financial models for pricing, promotions, inventory planning, and marketing ROI. Run scenario analyses to evaluate demand shifts, margin impacts, supply chain constraints, and marketing investment trade?offs. Translate model outputs into clear recommendations for leadership. Performance Reporting & Insights Build weekly and monthly reporting packages covering revenue, margin, marketing efficiency, fulfillment costs, and contribution profit. Analyze variances vs. budget/forecast and identify root?cause drivers. Surface actionable insights to improve profitability, reduce cost leakage, and optimize spend. Cross?

Functional Partnership Work closely with Marketing, Merchandising, Operations, and Supply Chain to align financial plans with operational realities. Support inventory planning, SKU profitability analysis, and vendor cost negotiations with data?driven insights. Partner with Accounting on month?end close, accruals, and reconciliation of budget vs. actuals. Process Improvement & Tooling Build scalable budgeting templates, dashboards, and SOPs for recurring FP&A processes. Improve data accuracy and streamline workflows through automation and better reporting structures. Recommend enhancements to financial systems, data pipelines, and analytics tools. Qualifications 3+ years of FP&A, corporate finance, or consulting experience; e?commerce or consumer products strongly preferred. Strong financial modeling skills (Excel, Google Sheets; bonus for SQL or BI tools). Deep understanding of e?commerce KPIs, unit economics, and digital marketing metrics. Experience running budgeting cycles and building driver?based forecasts. Ability to translate complex data into clear insights and business recommendations. Comfortable working in fast?moving, ambiguous environments with shifting priorities. Strong communication skills and ability to partner across technical and non?technical teams. Ideal Consultant Profile Hands?on, analytical, and operationally curious - someone who can dig into the numbers, challenge assumptions, build clean models, and help an e?commerce business understand exactly what drives performance and profitability.