Business Intelligence Analyst

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