Job Closed
This listing is no longer active.
We deliver the right information, to the right person, at the right moment.
Business Intelligence Analyst
Location
United States
Posted
227 days ago
Salary
$75K - $95K / year
Seniority
Senior
Job Description
Business Intelligence Analyst
Blueprint
• 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
Job Requirements
- 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 Core (not required to build models; just to read and test).
- Basic comfort with GitHub for version control or data documentation.
Benefits
- $75,000-95,000
