Business Intelligence Analyst

Blueprint, Inc
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 95K

Job location

Tech stack

Google AdWords
Google BigQuery
Cloud Computing
Data Validation
Data Warehousing
Github
Google Analytics
Query Optimization
Power BI
Shopify
SQL Databases
Tableau
Klaviyo Email and SMS Marketing
Snowflake
Amazon Web Services (AWS)
Facebook Ads Api
Looker Analytics

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

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.

About the company

Blueprint was founded by Bryan Johnson, who has the world's best comprehensive biomarkers. He is quantitatively the healthiest person on the planet. Blueprint is methodically built on science. Bryan freely shares his protocol, learnings and data with everyone to use. Blueprint has also developed a family of nutritional products to make the benefits of the Blueprint protocol affordable and available to all. We're a small, tight-knit team working to clean up the global food supply, provide healthy food to everyone, and build Don't Die into the most influential ideology in the world. We move quickly, work efficiently, and enjoy an environment defined by competence.

Apply for this position