Financial Analyst

This is a remote position.

Big Ideas is seeking a meticulous, commercially minded, and proactive remote Financial Analyst to support our US-based client, a growing company in the beauty and wellness industry. In this role, you will report directly to the FP&A Manager and serve as a core analytical resource responsible for financial planning, budgeting, forecasting, and commercial decision support. Supporting an omnichannel consumer brand footprint spanning direct-to-consumer (Shopify DTC), Amazon marketplace, and wholesale retail partner channels, you will transform transactional data into clear financial models, variance analyses, and strategic executive narratives.

This is a full-time, contractual, freelancer position for a trial period of 3 months while working  you are a highly motivated and detail-oriented individual with experience and qualified based on the criteria below, we encourage you to apply.

Upon successful completion of the evaluation period, the contractor's performance will be reviewed, potentially leading to a contract renewal that may include a benefits package.

• Weekly Cadence Database Support:
  Operate the existing Net Suite and third party file loads into Big Query. Extend them to new sources using the patterns already designed. Watch for schema changes and failed loads, and fix the cause rather than re-running. Design changes are specified by FP&A and reviewed before deployment.
• Weekly and Monthly Cadence Retailer door sales sync:
  Run the two-stage pipeline. Excel and VBA calculation engine on Dropbox feeding the Google Sheets values layer through Apps Script. Reconcile door counts and investigate breaks in the source file. Update monthly FC and maintain report backends.

• Budget versus actuals:
  Produce the pack across GL account, department and channel. Draft first-pass variance commentary. Maintain the transaction-type dispatch engine and the Description Aliases sheet as new posting patterns appear. Lock latest monthly & Quarterly FC.
• Clinic KPI reporting:
  Produce reports. Maintain the Boulevard service category mapping.
• Shipping profitability and 3PL billing:
  Run the shipping file checks and add new ones when a gap is found. Classify job tickets, flag duplicate orders and quantity convention errors, and keep the profitability model current across accounts.
• Field team bonus calculator:
  Run the Field and Corporate pool calculations. Reconcile the output and confirm caps, gating and payout rates apply correctly before anything is released.
• Sales team bonus calculator:
  Maintain and update the sales lead / customer mapping. Reconcile against the GRTs.
• Profitability:
  Maintain, update and archive Brand Pricing schedules for SKUs

• International pricing calculator:
  Maintain VAT, Tariff and FX logic. Run new markets and new SKU scenarios. Check margin outcomes against the intended landed cost build.
• Master data:
  Own the customer, vendor and employee master tables, channel and sub-channel tagging, and GL account groupings. Onboard new records ahead of each close rather than after a variance surfaces.
• Internal reporting portal:
  Keep the resource directory (HUB) and its links current as reports move or are replaced.
• Pricing:
  Maintain / update and archive Brand Pricing schedules for SKUs.

• Bachelor’s Degree with studies in Accounting, Finance, Economics, or related quantitative field. CPA, CMA, or CFA track is an advantage.
• Minimum of 4–5+ years of proven corporate experience in Financial Planning & Analysis (FP&A), commercial finance, or corporate finance.
• Demonstrable experience supporting omnichannel consumer products, retail, or fast-scaling Direct-to-Consumer (DTC/e-commerce) brand…