Business Intelligence Analyst

Posted 1ds ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

BI Analyst overseeing data visualizations and ensuring accurate insights from data warehouse for Blueprint's mission. Collaborating to build clean dashboards and validate data across platforms.

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
  • **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