BI Analyst

🔥 12 hours ago

🌵 Arizona, California, +26 more states – Remote

🌵 Arizona – Remote 🏄 California – Remote ⛰️ Colorado – Remote 🦌 Connecticut – Remote 🐊 Florida – Remote 🥔 Idaho – Remote 🌽 Illinois – Remote 🐎 Kentucky – Remote 🦞 Maine – Remote 🎰 Nevada – Remote 🗻 New Hampshire – Remote 🏖️ New Jersey – Remote 🗽 New York – Remote 🌲 North Carolina – Remote 🏈 Ohio – Remote 🌪️ Oklahoma – Remote 🦀 Maryland – Remote 🍂 Massachusetts – Remote 🚗 Michigan – Remote 🏰 Missouri – Remote 🔔 Pennsylvania – Remote ⚓ Rhode Island – Remote 🌴 South Carolina – Remote 🎸 Tennessee – Remote 🤠 Texas – Remote ⛷️ Utah – Remote 🍁 Vermont – Remote ⚔️ Virginia – Remote

💵 $80k - $90k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

📊 Business Intelligence Developer

👻 Ghost score 0%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

829 Studios

WebsiteLinkedInAll Job Openings

201 - 500 employees

Founded 2007

📣 Marketing

🤝 B2B

🤖 Artificial Intelligence

💰 Series unknown on 2021-09

Marketing • B2B • Artificial Intelligence

829 Studios is a performance-driven full-service digital marketing and brand experience agency. They provide end-to-end services including performance marketing (paid search, paid + organic social, programmatic & CTV, retail media, affiliate), SEO, marketing automation, conversion-rate optimization, brand strategy, web and digital product design, PR and crisis communications, influencer campaigns, and AI & analytics (data engineering, BI, AI/ML). The firm emphasizes a tech-first approach with proprietary platforms (Apollo performance software and analytics systems) and integrations across major ad, analytics, CMS, and marketing automation platforms to drive measurable growth for clients across B2B/enterprise, e-commerce, retail, higher education and other verticals.

📋 Description

• Support a small number of high-value enterprise accounts as the analytical owner • Generate performance insights, forecasts, and business-outcome-focused analyses • Synthesize paid media, web, CRM, ecommerce, offline conversion, and call-tracking datasets • Analyze channel contribution, funnel efficiency, audience segmentation, LTV, CAC, MER, and cohort behavior • Apply statistical methods to identify patterns, anomalies, and opportunities • Inform testing roadmaps, investment decisions, and budget reallocation with Strategy leadership • Build and maintain forecasts for revenue, spend, CAC, ROAS, CPA, and other KPIs • Develop baseline-versus-optimized scenario models and quantify financial impact • Apply seasonality decomposition, time-series methods, and regression projections • Build BI environments, semantic data models, DAX measures, reusable datasets, and executive dashboards • Establish single-source-of-truth reporting and optimize query performance, refresh patterns, and infrastructure cost • Query and model client-owned warehouses and write performant SQL datasets, views, and aggregations • Develop warehouse-layer attribution logic, including multi-touch, last-click, position-based, and custom blends • Partner with client data teams on definitions, source-of-truth logic, governance, and access patterns • Support offline conversion pipelines through Google Ads and Meta CAPI APIs • Validate conversion tracking, attribution, and data flow across advertising, analytics, CRM, and warehouse environments • Identify reporting discrepancies and trace root causes • Enforce event taxonomies, UTM structures, naming conventions, privacy, and consent requirements • Act as analytical counterpart to Strategy or Enterprise Account Directors • Diagnose performance issues, size opportunities, and pressure-test strategic hypotheses • Translate technical findings for C-level client stakeholders • Collaborate with Paid Media, SEO, Client Services, Strategy, and Analytics teams

🎯 Requirements

• 6+ years of experience in digital analytics, business intelligence, marketing data science, or closely related discipline • Expert-level SQL, including CTEs, window functions, materialized views, and cost-aware query design • Hands-on experience with BigQuery, Snowflake, and Sigma • Advanced BI proficiency in data modeling, DAX, Power Query, performance optimization, and row-level security • Strong adoption and comfort with AI tools including Claude Code, Cursor, or Codex • Experience unifying paid media, web, CRM, and revenue data into analysis-ready datasets • Strong working knowledge of GA4, Google Ads, Meta Ads, and their export/API data structures • Experience building forecasting models using time-series methods, regression, or scenario-based modeling • Hands-on Python 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, and call tracking platforms • Ability to translate ambiguous business questions into structured analytical work • Exceptional documentation, communication, and storytelling skills for technical and executive audiences • Familiarity with Looker Studio, Tableau, or other secondary BI surfaces (preferred) • Working familiarity with GTM and GA4 implementation (preferred) • Experience with marketing mix modeling, incrementality testing, or geo-experiments (preferred) • Familiarity with Fivetran, Stitch, or dbt (preferred) • Experience designing or architecting marketing data warehouses from scratch (preferred, not required) • Legally authorized to work in the United States • Must answer whether employment visa sponsorship will be needed

🏖️ Benefits

• Remote workplace with option to work at the Boston office or remotely from listed states • Paid vacation benefits increasing annually • 12 company holidays • Summer Fridays from Memorial Day through Labor Day • 401K plan with 4% Safe Harbor employer match after one year • Financial literacy services through retirement provider • No-cost life insurance coverage • Short-term disability benefit • Healthcare plans with 80% employer coverage for medical and dental premiums • 100% employer coverage for vision • FSA program option • Commuter benefits with pre-tax funds and savings up to 40% annually • Monthly team-led webinars • 829-cohort based learning • Digital course platforms • Funding opportunities for national conferences and events