Senior Data Analyst, Finance

Overview

The organization is seeking a Senior Data Analyst to own forecasting, predictive modeling, and financial data integrity for an e-commerce business. This is a senior, hands-on individual contributor role focused on building reliable financial forecasts and the predictive models that improve them—grounded in reconciled, trustworthy data.

Responsibilities

Forecasting

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

Predictive Modeling

• Build, validate, and maintain predictive models such as:
  • Subscription renewal and cancellation likelihood
  • Refund and chargeback risk
  • SKU-level demand
• Use statistical and machine learning methods including logistic regression, survival analysis, and gradient boosting
• Feed model outputs into revenue and cash forecasts so projections reflect likely renewal/cancellation/refund behavior (not only historical trends)
• Monitor model health over time and retrain as customer behavior shifts

Financial Reporting & Unit Economics

• Own reporting on 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
• Produce budget-vs-actual variance analysis that explains 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 into revenue discrepancies and drive fixes at the source with the Data Engineer
• Define and document the business logic behind financial metrics for the whole organization

Data Transformation & Visualization

• Use dbt or Python to build the financial datasets and models behind forecasting and reporting
• Write efficient SQL in Snowflake that reflects financial business rules
• Design, build, and maintain 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, including meaningful time in DTC, subscription, or consumer businesses
• Hands-on experience building both:
  • Financial forecasts (e.g., time-series, regression)
  • Predictive models used for decision-making (e.g., logistic regression, survival analysis, gradient boosting)
• Strong understanding of accounting principles and experience compiling financial statements and cash flows
• Proven DTC e-commerce experience required
• Must be comfortable working with Shopify, Amazon Seller Central, and Stripe data
• Expert SQL in Snowflake
• Strong Python (pandas, scikit-learn, statsmodels, Prophet, or similar)
• Proficiency with Sigma (experience with Tableau, Looker, or Power BI is acceptable if you can adapt quickly)
• Advanced Excel or Google Sheets skills
• Fluency with Claude Code (or comparable AI coding tools) for data manipulation and analytics
• Familiarity with ELT tools (e.g., Hevo, Fivetran, Airbyte, Azure) and ability to communicate effectively with the Data Engineer

Preferred Qualifications

• Familiarity with QuickBooks report structures and month-end close processes

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 position.