BI Analyst

829 Studios

. Support a small number of high-value enterprise accounts as the analytical owner .

Posted 9/15/2026full-timeRemote • Arizona • United StatesMid-LevelSenior💰 $80,000 - $90,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in digital analytics and business intelligence, with a strong focus on SQL, data modeling, and forecasting methodologies. Capable of synthesizing complex datasets and translating analytical insights into actionable strategies for enterprise clients.

Highest-signal resume keywords

Expert-Level SQLBigQueryData ModelingForecasting ModelsMulti-Touch Attribution

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Digital AnalyticsStatistical AnalysisTime-Series MethodsRegression ProjectionsData ManipulationForecastingAttribution LogicPerformance OptimizationScenario-Based ModelingCall Tracking

Soft Skills

Exceptional CommunicationStorytelling SkillsAnalytical Problem-Solving

Tools & Technologies

GA4Google AdsMeta AdsLooker StudioTableauFivetranStitchDbtPower QueryClaude Code

Industry Keywords

Business IntelligenceMarketing Data ScienceCross-Channel MeasurementRevenue DataData Governance

Tech Stack

Tools & technologies

BigQueryPandasPythonSQLTableau

About the role

Key responsibilities & impact

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

What you’ll need

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

Comp & perks

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