Sr Business Intelligence (BI) Marketing Analyst

Grain Group; New York (NY); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Grain Group is seeking a Sr BI Analyst to perform hands‑on analytics and measurement across client portfolios. You will connect paid media, retail, CRM, e‑commerce, and sales data to build measurement infrastructure and generate insights that drive business outcomes.

Responsibilities include developing SQL in BigQuery, QA data integrity, building Looker Studio dashboards, and implementing server‑side and offline conversion pipelines. Strong skills in AI tooling and Apps Script are valued.

Qualifications

• 5+ years in media analytics, BI, or marketing analytics for CPG or agencies.

Responsibilities

• Write and maintain SQL in BigQuery joining media, retail, e‑commerce, and client data into clean, reusable tables.

Skills

BI analytics

Advanced SQL

Google Sheets

Apps Script

AI tools

Paid media knowledge

Looker Studio

Tableau

Power BI

GTM

Server-side measurement

Conversion architecture

Communication

Self-starter

MMM platforms

Meridian

Robyn

Education

Bachelor's degree

Tools

Looker Studio

Tableau

Power BI

Google Tag Manager

dbt

Fivetran

Supermetrics

Python

R

Meridian

Robyn

Job description

Grain Group accelerates growth for ambitious consumer brands by aligning business insights with ROI-driven marketing. The team comprises strategic thinkers with backgrounds in business, media, technology, and finance.

Position Summary

Grain Group is seeking a Sr BI Analyst for hands-on, technical analytics and measurement work across our client portfolio. The role requires strong SQL skills, dashboard and database management, expertise in conversion tracking and measurement implementation, comfort building scripts and automations in Google Sheets and Apps Script, and experience using AI coding tools to build working analyses and internal tools.

You will connect paid media, retail, CRM, e-commerce, and sales data for CPG and product brands, build the measurement infrastructure required to accurately track performance, and turn that data into insights, performance forecasts, and recommendations that drive business outcomes.

Key Responsibilities

• Write and maintain SQL in BigQuery that joins media platform, retail, e-commerce, and client-side sales data into clean, reusable tables
• Own data integrity across accounts: QA tracking, tagging, conversion events, and data feeds, and fix breaks before they reach client reporting
• Build and maintain Looker Studio dashboards aligned to client KPIs and business objectives
• Build and update monthly Impact Estimates using historical performance, benchmarks, and current results; compare against actuals and adjust the method when estimates drift
• Prepare data for and interpret marketing mix models (MMM), incrementality tests, and attribution analysis
• Analyze sales and sell-through data alongside media spend for CPG clients across Amazon, Walmart, Instacart, and DTC
• Write Google Apps Script and Sheets automations for pacing, QA, data pulls, and report prep
• Vibe code internal tools and scripts with AI coding assistants (Claude, Codex, Cursor, or similar), then test and ship them
• Manage and implement conversion tracking across platforms, including Google Tag Manager, platform pixels/tags, and ad account conversion action settings
• Implement and troubleshoot server-side and advanced measurement solutions, including Conversion API and similar platform integrations
• Build offline and CRM-based conversion pipelines that send lead stage and downstream outcome data back to advertising platforms for reporting, attribution, and bid optimization
• Design funnel-based measurement frameworks that connect upper-funnel actions to qualified leads, opportunities, purchases, revenue, or other meaningful business outcomes
• Standardize recurring analytics workflows so they run the same way on every account

Strategic & Cross-Functional Responsibilities

• Serve as a subject matter expert for data, measurement, conversion tracking, and analytics tooling
• Partner with Strategy team on planning inputs and with Performance team on interpreting results and improving execution
• Turn analysis into clear, decision-ready recommendations for strategists and clients
• Develop measurement plans that define KPIs, conversion hierarchies, funnel stages, data sources, and optimization signals
• Advise teams on conversion architecture, including primary vs. secondary conversion actions, attribution considerations, offline conversion imports, enhanced/server-side measurement, and platform optimization signals
• Participate in client calls and presentations to walk through analysis and findings
• Contribute to new business efforts including performance projections, measurement plans, and MMM scoping
• Mentor junior analysts on SQL, data QA, and automation best practices

Requirements

• 5+ years hands‑on experience in media analytics, BI, or marketing analytics at a CPG brand, product company, or agency serving them
• Proven experience analyzing sales and marketing data together: spend, impressions, and conversions alongside retail sales, sell‑through, or e‑commerce revenue
• Advanced SQL, including CTEs, window functions, and multi‑source joins
• Strong Google Sheets and Apps Script skills: custom functions, triggers, API pulls, and automations
• Hands‑on experience vibe coding with AI tools, including testing and debugging the output
• Working knowledge of paid media platforms (Google, Meta, Amazon Ads, programmatic) and metrics such as ROAS, CPA, NTB, and incrementality
• Experience building dashboards in Looker Studio, Tableau, Power BI, or similar
• Hands‑on experience implementing and troubleshooting digital conversion tracking using tools such as Google Tag Manager, configuring ad platform (Meta/Google/etc) conversion actions, event mappings, optimization events, and attribution settings
• Experience with advanced or server‑side measurement such as Meta Conversion API, Google Enhanced Conversions, server‑side GTM, or similar solutions
• Understanding of conversion architecture, including event deduplication, identifiers, attribution, conversion hierarchies, and primary vs. secondary optimization events
• Clear communicator who can explain findings to non‑technical partners and clients
• Self‑starter thriving in fast‑paced, entrepreneurial environments
• Experience with MMM platforms such as Meridian, Robyn, PyMC‑Marketing, Recast, or Measured (strong plus)
• Familiarity with retail media data (Amazon Marketing Cloud, Walmart Connect, Instacart, Skai), Python or R, or ETL tools such as dbt, Fivetran, or Supermetrics (bonus)

Education:

Bachelor's degree (required)

Experience:

• SQL: 3 years (required)
• Marketing or media analytics: 3 years (required)
• GTM conversion tracking / measurement implementation: 3 years (required)
• Excel + Google Sheets / Apps Script: 3 years (required)
• Marketing mix modeling: 1 year (preferred)

Location: Hybrid.

Must commute to New York, NY 10018 (in person) currently 3‑days a week.