Full Job Description
We are looking for a BI Analyst to oversee day-to-day visualizations, data validation, and stakeholder reporting. This person ensures leadership has fast, accurate insights from our data warehouse without bottlenecks.
**Requirements**
Position Responsibilities:
- Build and maintain performance dashboards
- Validate data across Shopify, Amazon, Recharge, GA4, Klaviyo, and marketing platforms
- Investigate and reconcile discrepancies across systems
- Work directly with the Head of Data to ensure metrics definitions and transformations are consistent
- Surface actionable insights and trends for decision-makers quickly
- Build clean, self-service dashboards (in Sigma Computing but has similar experience - Tableau, Looker, Power BI)
- Oversee weekly and ad-hoc reporting needs for marketing, operations, and finance
- Document logic and sources to keep dashboards accurate as data models evolve
Basic Qualifications:
- 3-4 years hands-on SQL experience building and validating datasets
- Comfortable joining large tables, using window functions, CTEs, aggregations, and troubleshooting discrepancies
- Familiar with Snowflake, BigQuery or a similar cloud data warehouse (permissions, basic query tuning, lineage awareness)
- Capable of validating metrics (e.g., Shopify vs Snowflake vs Amazon totals)
- Strong attention to layout, speed, and usability
- Prior experience with Shopify and Amazon Seller Central data
- Exposure to subscription platforms (Recharge, Loop, etc.)
- Familiar with Google Analytics / GA4, Google Ads, Facebook Ads, and Klaviyo metrics
Preferred Skills:
- Familiarity with dbt Cloud (not required to build models; just to read and test).
- Basic comfort with GitHub for version control or data documentation.
**Benefits**
Salary Range: $75-95k + equity + benefits