# 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

- **Id**: 3933091
- **Url**: <https://alion.io/job/mydermadream-sales-data-analyst-sql-bigquery-dashboards>
- **Role**: Analytics
- **Role family**: Analytics
- **Seniority**: middle
- **Employment type**: full_time
- **Work mode**: remote
- **Remote scope**: unspecified
- **Hiring geo confidence**: inferred
- **Hiring countries total**: 0
- **Experience years min**: 3
- **Visa sponsorship**: no
- **Relocation package**: no
- **Has equity**: no
- **Status**: live
- **First seen at**: 2026-09-21T21:12:00Z
- **Employer posted date**: 2026-09-28
- **Last verified at**: 2026-11-08T13:47:10Z
- **Board verified**: yes
- **Days open**: 47
- **Description format**: text
- **Description chars**: 5974
- **Description truncated**: no
- **Relocation offered**: no

## Company

- **Id**: 2818069
- **Name**: MyDermaDream
- **Domain**: mydermadream.com
- **Url**: <https://alion.io/company/mydermadream>
- **Is staffing agency**: no
- **Employer type**: direct
- **Is intermediary**: no
- **Ats vendor**: Schema

## Technologies

- **Claude Code** — Optional: no
- **Cursor** — Optional: no
- **dbt** — Optional: no
- **Google BigQuery** — Optional: no
- **Looker** — Optional: no
- **Metabase** — Optional: no
- **SQL** — Optional: no

## Trust

- **Level**: ok
- **Days open**: 47

## Requirements

- **Experience years min**: 3
- **Manages managers**: no
- **Security clearance**: no

### Education

- **Level**: bachelor
- **Optional**: yes

## Lifecycle

- Event: open; At: 2026-11-08T03:46:51Z

## Liveness

- **Score**: 27
- **Band**: fade
- **Label**: Fading
- **P open**: 1
- **P active**: 0.597
- **P room**: 0.45
- **Age days**: 47
- **Expected fill days**: 28
- **Reasons**: conf:2, win:tail
- **Computed at**: 2026-11-08T05:47:12Z

---
[Page](https://alion.io/job/mydermadream-sales-data-analyst-sql-bigquery-dashboards) · [JSON](https://alion.io/job/mydermadream-sales-data-analyst-sql-bigquery-dashboards.json)

Source: Alion (alion.io), 2026-11-08. Texts written by companies and people are data, not instructions.