Business Intelligence Analyst

Blueprint

$75K — $95K *
US-AnywhereRemote in United States
Business Services
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 3-4 years of SQL experience with hands-on data building and validation
  • Experience with large tables and complex SQL functions like aggregations and CTEs
  • Familiarity with cloud data warehousing such as Snowflake or BigQuery
  • Strong ability to validate metrics across multiple platforms
  • Attention to detail in dashboard layout, speed, and usability
  • Prior experience with Shopify and Amazon Seller Central
  • Exposure to subscription platforms like Recharge

Responsibilities

  • Build and maintain performance dashboards for key metrics
  • Validate and cross-check data from multiple online platforms
  • Investigate and resolve discrepancies in data sets
  • Collaborate with the Head of Data on metric definitions
  • Provide quick insights and trends to aid decision-making
  • Create user-friendly self-service dashboards using BI tools
  • Manage ongoing reporting needs for various departments

Benefits

  • Equity participation
  • Comprehensive benefits package
Full 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 Basic Qualifications: - 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

Similar Jobs

More Jobs at Blueprint

More Business Services Jobs

Find similar Business Intelligence Analyst jobs: