Senior Data Analyst, Finance

Overview

This role is for a Senior Data Analyst who will build and own forecasting and predictive models that drive financial planning for an e-commerce business. The position focuses on financial data integrity, scenario planning, unit economics, and reconciling transaction data across payment processors, internal systems, and accounting.

The organization is fully remote.

Responsibilities

Forecasting

• Build and own forecasts for revenue, orders, subscription renewals, and cash by brand and channel
• Develop scenario and sensitivity models to support budget planning
• Track forecast accuracy over time and refine models as the business changes

Predictive modeling

• Build, validate, and maintain predictive models (e.g., subscription renewal and cancellation likelihood, refund and chargeback risk, SKU-level demand) using statistical and machine learning methods such as logistic regression, survival analysis, and gradient boosting
• Integrate model outputs into revenue and cash forecasts to reflect expected renewals, cancellations, and refunds
• Monitor model performance over time and retrain as customer behavior shifts

Financial reporting & unit economics

• Own P&L reporting across revenue, gross vs. net sales, discounts, refunds, COGS, and contribution margin by brand, channel, and product
• Own contribution margin, payback, and profitability reporting by brand, channel, and product
• Perform budget-vs-actual variance analysis to explain what moved and why

Financial data integrity & reconciliation

• Own reconciliation across payment processors (Stripe, Shopify Payments, Amazon), bank deposits, internal databases, and accounting (QuickBooks) to ensure every dollar is accounted for
• Lead investigations of revenue discrepancies and drive fixes at the source with the Data Engineer
• Define and document the business logic behind financial metrics for the broader organization

Data transformation & visualization

• Use dbt and/or Python to build financial datasets and models behind forecasting and reporting
• Write efficient SQL in Snowflake that implements financial business rules
• Design, build, and maintain high-impact dashboards in Sigma for Finance and executive leadership

Leadership & collaboration

• Present forecasts and model findings to Finance and executive leadership, including assumptions and risks
• Review other analysts’ work and mentor them on financial data quality and modeling

Requirements

• 5+ years of data or financial analytics experience, with meaningful time in DTC, subscription, or consumer businesses
• Senior, hands-on individual contributor (not a people manager)
• Hands-on experience with both:
  • Building financial forecasts (e.g., time-series, regression)
  • Building predictive models used for decision-making (e.g., logistic regression, survival analysis, gradient boosting)
• Strong accounting fundamentals, including experience compiling financial statements and cash flows
• Proven DTC e-commerce experience required, including comfort working with Shopify, Amazon Seller Central, and Stripe data
• Expert SQL in Snowflake
• Strong Python skills (e.g., pandas, scikit-learn, statsmodels, Prophet, or similar)
• Proficiency with Sigma (or equivalent BI tooling such as Tableau, Looker, or Power BI with ability to adapt quickly)
• Advanced Excel or Google Sheets skills
• Fluency with Claude Code (or comparable AI coding tools) for data manipulation and analytics
• Awareness of ELT tools (e.g., Hevo, Fivetran, Airbyte, Azure, etc.) and ability to communicate effectively with the Data Engineer

Preferred Qualifications

• Familiarity with QuickBooks report structures and month-end close
• Experience with Tableau, Looker, or Power BI

Compensation & Benefits

• Salary: $100,000 - $125,000 depending on experience
• Excellent Medical, Dental, Vision and Life insurance
• Fully remote, full-time position
• Monthly WFH stipend
• Generous Paid Time Off program
• Discounted Products

Location

Fully remote