Blueprint is a company focused on improving the global food supply and promoting health through science-based nutritional products. They are seeking a Business Intelligence Analyst to manage data visualizations, validation, and stakeholder reporting to provide leadership with timely insights from their data warehouse.
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
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
- Familiarity with dbt Cloud (not required to build models; just to read and test)
- Basic comfort with GitHub for version control or data documentation