[Hiring] Data Analyst, Finance @Scale Media

Role Description

We are looking for a mid-level Data Analyst who is far more than a report builder. You are a "Data Detective" who understands the heartbeat of an e-commerce P&L. You will not just analyze data; you will own the truth behind our revenue numbers and help Finance see what's coming next. We need a Financial Data Master who understands payment processors, core financial concepts, and forecasting, and who knows how raw transaction data becomes a P&L the business can trust. Additionally, you will act as a critical partner to our Finance team, bridging the gap between raw data, payment processors, our financial reporting, and the forecast.

What You'll Do

• Forecasting
  • Build and maintain forecasts for revenue, orders, subscription renewals, and expenses by brand and channel, and keep them current as actuals come in.
  • Track how forecasts compare to actuals, explain the gaps, and flag meaningful misses to the Finance team.
  • Update the scenarios and assumptions Finance uses for budget planning.
• Financial Reporting & Unit Economics
  • Build and maintain reporting on revenue, gross vs. net sales, discounts, refunds, COGS, and contribution margin by brand, channel, and product.
  • Report on contribution margin, payback, and profitability by brand, channel, and product.
  • Support month-end close with timely, tied-out data.
  • Produce variance reporting that explains what moved and why.
• Financial Data Integrity & Reconciliation
  • Act as the lead investigator for revenue discrepancies. You will reconcile data between payment processors (Stripe, Shopify Payments, Amazon), bank deposits, our internal database, and accounting (QuickBooks) to ensure every dollar is accounted for.
  • Reconcile marketing spend across ad platforms and invoices against finance records.
  • Work with Finance and our Data Engineer to fix discrepancies at the source.
  • Document the business logic behind financial metrics so every team uses the same definitions.
• Data Transformation & Visualization
  • While we have a Data Engineer managing the infrastructure, you will handle the "last mile" of data prep using KNIME or dbt (or similar tools like Alteryx or Python/Pandas).
  • Write efficient SQL to transform raw transaction data in Snowflake into usable datasets that reflect our financial business rules.
  • Design, build, and maintain high-impact dashboards in Sigma for Finance and leadership.

Qualifications

• 2–3 years of specific Data Analysis experience, ideally supporting finance.
• Hands-on experience building and maintaining financial forecasts (e.g., revenue, orders, or expenses) in SQL, spreadsheets, or a BI tool.
• Comfort with revenue recognition, COGS, gross vs. net sales, and contribution margin.
• Proven experience in DTC E-commerce.
• Strong proficiency with Snowflake (SQL) and Sigma.
• Advanced Excel or Google Sheets skills.
• Competency in KNIME or dbt is preferred.
• Awareness of how ELT tools function.

Requirements

• You have built or maintained forecasts that Finance relied on, and you can explain why actuals came in above or below them.
• You understand how a Shopify order becomes a processor payout and then a bank deposit, and where fees, refunds, and chargebacks create gaps.
• Understanding QuickBooks report structures is a plus.
• You have the patience and precision to trace a single transaction through the entire data lifecycle to solve revenue mismatches.
• You'd rather be right than fast, but you're fast too.

Benefits

• Salary: $80,000 - $100,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
• An amazing team to work alongside