商业智能分析师
BI Analyst
我们正在寻找一位高度技术化、数据驱动的BI分析师，以支持少量高价值的企业客户。该职位适合一位能够处理大型复杂数据集，并将其转化为清晰、可决策的洞察的人。与客户经理、策略和媒体总监一起工作，你将负责每个指定客户的分析层——生成绩效洞察、制作预测，并发现推动业务成果的模式。你将在客户自有的数据仓库如BigQuery、Snowflake和Sigma中流畅操作，使用Power BI/Tableau等工具构建BI环境，并将模糊的业务问题转化为结构化的分析工作。该职位的核心是深入了解每个客户的业务，并利用这种量化理解来指导策略、投资和预测决策。该职位在策略、付费媒体、客户服务和分析之间发挥关键的跨职能作用。
**你将负责**
数据分析与洞察生成
- 将来自付费媒体、网站、CRM、电商、线下转化和电话追踪等多个来源的大型数据集整合成清晰的绩效叙述
- 对渠道贡献、漏斗效率、受众细分、LTV、CAC、MER和群体行为进行深入分析
- 通过应用统计方法对复杂、多维的数据集进行分析，发现隐藏的模式、异常和机会
- 将原始数据转化为与收入、销售线索、留存和增长结果相关的业务对齐的洞察
- 与策略领导合作，为测试路线图、投资决策和预算重新分配提供支持
预测与预测建模
- 为付费渠道、电商和获客环境中的收入、支出、CAC、ROAS、CPA和其他KPI构建和维护预测模型
- 开发情景模型（基准 vs 优化），预测战略调整带来的增量机会
- 应用季节性分解、时间序列方法和基于回归的预测技术
- 量化审计发现、优化建议和预算变化的财务影响
- 在滞后指标出现之前，识别出表现不佳的领先指标
商业智能与数据可视化
- 使用Power BI、Looker、Tableau和Sigma等工具构建和维护BI环境
- 设计语义数据模型、DAX度量值和可重用数据集，实现跨客户扩展
查看英文原文
We are seeking a highly technical, data-driven BI Analyst to support a small number of high-value enterprise accounts. This role is built for someone who lives in large, complex datasets and turns them into clear, decision-grade insights. Working alongside an Account, Strategy and Media Directors, you will own the analytical layer for each assigned client - generating performance insights, producing forecasts, and surfacing the patterns that drive business outcomes. You will operate fluently inside client-owned data warehouses such as BigQuery, Snowflake, and Sigma, build BI environments in tools like Power BI/Tableau, and translate ambiguous business questions into structured analytical work. This role centers on developing a deep quantitative understanding of each client's business and using that fluency to inform strategy, investment, and forecasting decisions. The position plays a critical cross-functional role between Strategy, Paid Media, Client Services, and Analytics.
**What You'll Do**
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
Business Intelligence & Data Visualization
- Build and maintain BI environments using tools such as Power BI, Looker, Tableau, and Sigma
- Design semantic data models, DAX measures, and reusable datasets that scale across clients and account types
- Build executive-ready dashboards that translate complex datasets into clear, narrative-driven views of performance
- Establish single-source-of-truth reporting frameworks that reconcile platform data with CRM and ecommerce truth
- Optimize query performance, data refresh patterns, and cost efficiency across BI infrastructure
Working Within Client Data Environments
- Operate fluently inside client-owned data warehouses, including BigQuery, Snowflake, and Sigma, to query, model, and analyze marketing and business data
- Write performant SQL against client schemas to build the datasets, views, and aggregations that power analysis and reporting
- Develop attribution logic in the warehouse layer (multi-touch, last-click, position-based, custom blends) using whatever stack the client provides
- Adapt to varying data architectures, naming conventions, and governance models across enterprise client environments
- Partner with client data teams to align on definitions, source-of-truth logic, and access patterns
- Support offline conversion pipelines via platform APIs (Google Ads, Meta CAPI) where data engineering input is required
Measurement Foundation & Data Integrity
- Validate that conversion tracking, attribution logic, and data flow across Google Ads, Meta, LinkedIn, TikTok, GA4, and CRM environments feed the warehouse cleanly and consistently
- Partner with tag management specialists to translate analytical requirements into data layer specifications
- Identify discrepancies between platform reporting and source-of-truth, and trace them to root cause
- Enforce consistent event taxonomies, UTM structures, and naming conventions at the data layer
- Ensure analytical outputs respect privacy frameworks and consent management requirements
Cross-Functional Partnership
- Act as the analytical counterpart to the Strategy Director or Enterprise Account Director on assigned enterprise accounts
- Serve as the agency's go-to voice for diagnosing performance issues, sizing opportunities, and pressure-testing strategic hypotheses with data
- Translate technical findings into language that resonates with C-level client stakeholders
- Collaborate with Paid Media, SEO, Client Services, and Strategy teams to align analytical outputs with execution
**What You'll Bring**
- 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)
- Demonstrated ability to translate ambiguous business questions into structured analytical work
- Exceptional documentation, communication, and storytelling skills across both technical and executive audiences
- 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)
**Benefits and Perks We Provide**
- **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.
**What We Believe**
At 829 Studios, we boldly embrace diversity, inclusivity, and equal opportunity. Our goal: a team rich in backgrounds, perspectives, and talents. Why? Because inclusivity powers our brilliance and client success. We are an Equal Opportunity Employer that is committed to equal employment opportunities regardless of race, religion, creed, color, sex, pregnancy, sexual orientation, gender, gender identity, national origin, disability, mental illness, age, ancestry, genetic information, military service, or any other status protected under applicable federal, state, or local laws.
**Who We Are**
829 Studios is a Boston-based integrated digital marketing agency with a mission to propel organizations to unlock their full potential and accomplish their most ambitious goals. We harness the power of logic with magic – a balance of data-driven strategy and brand-focused creative. We partner with diverse organizations across various industries and our client list encompasses venture-backed start-ups, publicly traded companies, non-profits, and more. By committing not only to our growth as a company, but the development of our employees and teams’, we have created a collaborative environment that fosters ingenuity and promotes diversity, equity, inclusion, and belonging values within our community. 829 has been recognized as one of the nation’s top agencies by the Inc. 5000 Fastest-Growing Privately Held Companies, Adweek 100 Fastest-Growing Digital Agencies, Boston Business Journal's Fast 50 (Massachusetts' 50 Fastest-Growing Private Companies), HubSpot's Top Digital Agencies list, and a we are and employee-certified Great Place to Work.
**Salary Range:** $80,000- $90,000
We determine compensation based on experience, demonstrated skills, and current market conditions at the time of hire to ensure fairness and consistency across roles. Actual compensation will depend on experience and may be adjusted based on skills, qualifications, and alignment with the scope and impact of the role.