Sales Data Analyst | SQL, BigQuery & Dashboards

**Are you a SQL-fluent analyst who can look at a raw BigQuery table and turn it into an answer a sales leader can act on the same day?Are you someone who instinctively distrusts a number until you've traced exactly which model it came from and what grain it's sitting at?Are you comfortable using AI tools like Claude Code every single day to write, debug, and ship SQL faster — not just someone who says they're "open to" AI?We are My Derma Dream! A nearly 9-figure Skin Care brand in the United States since 2022.We are continuing to scale quickly and hiring across multiple functions across the business.BUT…We do not need an analyst who waits for someone to ask a question before opening BigQuery.We need someone who goes looking for the story in the data before anyone asks for it.We are looking for a Sales Data Analyst who can specialize in the full sales side of the business: bundles, DTC order economics, subscriptions and churn, product profitability, and phone sales team performance.In order to achieve this, you will work directly inside our dbt-modeled BigQuery gold layer, building dashboards from scratch in areas where none exist today — starting with bundle performance and phone sales optimization.You will use AI tools like Claude Code and text-to-SQL copilots daily to move faster than a traditional analyst workflow allows, and you'll work across our homegrown BI stack (Metabase, Looker Studio, and whatever else gets added) without needing months of ramp-up on a new tool.If you love turning a messy transactional dataset into a number a sales leader trusts enough to act on...If you want to be the person who finally builds the dashboards that don't exist yet, not maintain ones that already do...If you're an AI-native analyst who moves noticeably faster because of it...
Then APPLY NOW!
===========Results:**

• Dashboards and analyses that sales and ops leadership actually use to make calls — not reports that sit unread.

• A real bundle-performance story (which tiers convert, where bundles cannibalize each other) built from data that already exists but has never been turned into an answer.

• Subscription and churn reporting that correctly separates true churn from payments rescued through payment-retry recovery — not a naive rebill count.

• Phone sales performance analysis that tells reps and managers exactly what separates the best performers from the rest.

• **A gold-layer query and dashboard footprint sales leadership can rely on without needing to check your work.

===========Responsibilities:**

• Own SQL-based analysis across bundles, DTC order economics, subscriptions, churn, product profitability, and phone sales performance.