BI Analyst

Boston, MA (Remote)

$80K/yr – $90K/yrMid Level6+ years expFull time

Posted 7 days ago

Job Summary

Own end-to-end analytics from data to actionable insights, leading forecasting, attribution, and BI workstreams across paid media, ecommerce, and lead-gen environments.

  • Forecasting & predictive modeling for KPIs
  • BI dashboards and data storytelling for executives
  • Consolidating data from paid media, web, CRM, and revenue into analysis-ready datasets

Job Description

Responsibilities

  • Data Analysis & Insight Generation: Synthesize large, multi-source datasets across paid media, web, CRM, ecommerce, offline conversions, and call tracking into clear performance narratives
  • Conduct deep-dive analyses on channel contribution, funnel efficiency, audience segmentation, LTV, CAC, MER, and cohort behavior
  • Surface hidden patterns, anomalies, and opportunities by applying statistical methods to complex, multi-dimensional datasets
  • Translate raw data into business-aligned insights tied to revenue, pipeline, retention, and growth outcomes
  • Partner with Strategy leadership to inform testing roadmaps, investment decisions, and budget reallocation
  • Forecasting & Predictive Modeling: Build and maintain forecasting models for revenue, spend, CAC, ROAS, CPA, and other KPIs across paid channels, ecommerce, and lead-gen environments
  • Develop scenario models (baseline vs. optimized) that project incremental opportunity from strategic shifts
  • Apply seasonality decomposition, time-series methods, and regression-based projection techniques
  • Quantify the financial impact of audit findings, optimization recommendations, and budget changes
  • Surface leading indicators of underperformance before they appear in lagging metrics

Requirements

  • 6+ years of experience in digital analytics, business intelligence, marketing data science, or a closely related discipline
  • Expert-level SQL with hands-on experience working inside client-owned warehouses such as BigQuery, Snowflake, and Sigma: CTEs, window functions, materialized views, and cost-aware query design
  • Advanced BI proficiency: data modeling, DAX, Power Query, performance optimization, and row-level security
  • Strong adoption and comfort with AI tools including Claude Code, Cursor or Codex.
  • Proven experience working within client data environments to unify paid media, web, CRM, and revenue data into analysis-ready datasets
  • Strong working knowledge of GA4, Google Ads, Meta Ads, and the underlying data structures of each platform's exports and APIs
  • Demonstrated experience building forecasting models using time-series methods, regression, or scenario-based modeling
  • Hands-on Python (preferred) or R for statistical analysis, pandas-based data manipulation, and reproducible analytical workflows
  • Strong understanding of multi-touch attribution, marketing mix concepts, and cross-channel measurement principles
  • Experience with offline conversion tracking, CRM integrations (HubSpot, Salesforce), and call tracking platforms (CTM, Marchex)

Preferred

  • Familiarity with Looker Studio, Tableau, or other secondary BI surfaces (preferred)
  • Working familiarity with GTM and GA4 implementation - sufficient to specify and validate, not necessarily build (preferred)
  • Experience with marketing mix modeling, incrementality testing, or geo-experiments (preferred)
  • Familiarity with ETL and transformation tooling such as Fivetran, Stitch, or dbt (preferred)
  • Experience designing or architecting marketing data warehouses from scratch (preferred, not required)
  • Hands-on Python (preferred) or R for statistical analysis, pandas-based data manipulation, and reproducible analytical workflows

Benefits

  • Remote Workplace. You have the option to work at our office in Boston or remotely in one of these states: AZ, CA, CO, CT, FL, ID, IL, KY, ME, MD, MA, MI, MO, NV, NH, NJ, NY, NC, SC, OH, OK, PA, RI, TN, TX, UT, VA, VT.
  • Paid Time Off. Receive generous paid vacation benefits that increase each year you’re with us, 12 Company Holidays, and Summer Fridays from Memorial Day through Labor Day.
  • 401K + Match. 401K plan with 4% Safe Harbor employer match after one year of employment and financial literacy services provided through our retirement provider.
  • Life Insurance Benefit. No-cost coverage to ensure peace of mind for your family.
  • Short Term Disability Benefit. We've got you covered if you need to be OOO with an illness or injury that keeps you out of work.
  • Healthcare. Choose from several competitive healthcare plans for you and your family with 80% employer coverage for all medical and dental premiums, 100% employer coverage for vision, and the option to participate in the FSA program.
  • Commuter Benefits. Allocate pre-tax funds towards your commute to save up to 40% per year in transportation expenses.
  • Continuing Education. Access to monthly team-led webinars, exclusive 829-cohort based learning, digital course platforms, and funding opportunities to attend national conferences and events.
829 Studios logo

829 Studios

We are your partner in performance — delivering
tech-enabled, full-service digital marketing solutions optimized to elevate your business.

Founded in 2007
Boston, Massachusetts, US
249 employees (105 in marketing)

Salaries

Posted range

$80K/yr – $90K/yr

Taken straight from the job posting.

See all 829 Studios salaries

Funding

Last Raise
Private Equity, 5 years ago

Funding History

  • Sep 2021
    Private Equity

Traffic Signals

Monthly Visitors
11K
Traffic Source Mix
Search
30.7%
Direct
53.5%
Referral
6%
Social
8.4%
Paid
1.2%

Headcount Trend

Current headcount: ~264
829 Studios logo

BI Analyst

829 Studios · Boston, MA · Remote