Sr Business Intelligence (BI) Marketing Analyst

vibehackers; New York (NY); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

401(k)

Health insurance

Dental insurance

Vision insurance

Flexible spending account

Health savings account

Paid time off

Parental leave

Job summary

Grain Group is hiring a Senior Business Intelligence (BI) Marketing Analyst to perform hands-on technical analytics across its client portfolio. The role centers on integrating paid media, retail, e-commerce, and sales data to produce clean reusable datasets, dashboards, forecasts, and decision-ready recommendations that drive business outcomes for CPG and product brands.

Hybrid role based in New York, NY with three days on-site.

Qualifications

• 5+ years hands-on experience in media analytics, BI, or marketing analytics at a CPG brand, product company, or agency serving CPG.
• Advanced SQL skills (CTEs, window functions, multi-source joins).
• Strong Google Sheets and Apps Script skills (custom functions, triggers, API pulls, automations).
• Hands-on experience using AI coding tools for developing and debugging scripts and tools.

Responsibilities

• Write and maintain SQL in BigQuery to join media platforms, retail, e-commerce, and client sales data into clean, reusable tables.
• Own data integrity across accounts: QA tracking, tagging, and data feeds; diagnose and fix data breaks before client reporting.
• Build and maintain Looker Studio dashboards aligned to client KPIs and objectives.
• Build and update monthly impact estimates and compare against actuals; refine methods when estimates drift.
• Prepare data for and interpret marketing mix models (MMM), incrementality tests, and attribution analyses.
• Analyze sales and sell-through alongside media spend for clients across Amazon, Walmart, Instacart, and DTC channels.
• Write Google Apps Script and Google Sheets automations for pacing, QA, data pulls, and report preparation.
• Use AI coding assistants (e.g., Claude, Codex, Cursor) to prototype, test, and ship internal tools and scripts.
• Standardize recurring analytics workflows across accounts and mentor junior analysts.

Skills

SQL

Looker Studio

Google Sheets

Apps Script

AI-assisted coding

Data visualization

Tools

BigQuery

Tableau

Power BI

dbt

Fivetran

Supermetrics

Job description

Sr Business Intelligence (BI) Marketing Analyst

Uses AI coding assistants to "vibe code" internal tools and scripts, testing and shipping AI-assisted automations.

About the Role

Senior BI Marketing Analyst responsible for hands-on technical analytics across a client portfolio, connecting paid media, retail, e-commerce, and sales data to generate actionable insights and forecasts. The role focuses on SQL & BigQuery pipelines, Looker Studio dashboards, Google Sheets/Apps Script automations, and building internal tools with AI coding assistants.

Job Description

Role

Grain Group is hiring a Senior Business Intelligence (BI) Marketing Analyst to perform hands-on technical analytics across its client portfolio. The role centers on integrating paid media, retail, e-commerce, and sales data to produce clean reusable datasets, dashboards, forecasts, and decision-ready recommendations that drive business outcomes for CPG and product brands.

Key Responsibilities

• Write and maintain SQL in BigQuery to join media platforms, retail, e-commerce, and client sales data into clean, reusable tables.
• Own data integrity across accounts: QA tracking, tagging, and data feeds; diagnose and fix data breaks before client reporting.
• Build and maintain Looker Studio dashboards aligned to client KPIs and objectives.
• Build and update monthly impact estimates and compare against actuals; refine methods when estimates drift.
• Prepare data for and interpret marketing mix models (MMM), incrementality tests, and attribution analyses.
• Analyze sales and sell-through alongside media spend for clients across Amazon, Walmart, Instacart, and DTC channels.
• Write Google Apps Script and Google Sheets automations for pacing, QA, data pulls, and report preparation.
• Use AI coding assistants (e.g., Claude, Codex, Cursor) to prototype, test, and ship internal tools and scripts.
• Standardize recurring analytics workflows across accounts and mentor junior analysts.

Requirements

• 5+ years hands-on experience in media analytics, BI, or marketing analytics at a CPG brand, product company, or agency serving CPG.
• Advanced SQL skills (CTEs, window functions, multi-source joins) and at least 3 years of SQL experience.
• Strong Google Sheets and Apps Script skills (custom functions, triggers, API pulls, automations).
• Hands-on experience using AI coding tools for developing and debugging scripts and tools.
• Working knowledge of paid media platforms and metrics (Google, Meta, Amazon Ads, programmatic; ROAS, CPA, incrementality).
• Experience building dashboards in Looker Studio, Tableau, Power BI, or similar tools.
• Experience preparing data for MMM, incrementality, and attribution analyses; familiarity with MMM platforms is a plus.
• Clear communicator able to present findings to non-technical stakeholders and participate in client calls.

Preferred / Bonus Skills

• Familiarity with MMM platforms (Meridian, Robyn, PyMC-Marketing, Recast, Measured).
• Familiarity with retail media data sources (Amazon Marketing Cloud, Walmart Connect, Instacart, Skai).
• Experience with Python or R and ETL tools like dbt, Fivetran, or Supermetrics.

Location & Schedule

Hybrid role based in New York, NY 10018. Candidates must commute to the office in person three days per week. Relocation to New York prior to starting is required if not local.

• Pay range: $90,000 - $120,000 per year.
• Benefits include: 401(k), health insurance, dental insurance, vision insurance, flexible spending account, health savings account, paid time off, and parental leave.

Working Context

Full-time role within a fast-paced, entrepreneurial agency environment; involves cross-functional collaboration with Strategy and Performance teams and client-facing presentations.

BigQuery Looker Studio Google Sheets Google Apps Script Claude Codex Cursor Google (Paid Media) Meta (Paid Media) Amazon Ads Programmatic Tableau Power BI Amazon Marketing Cloud Walmart Connect Instacart Skai Meridian Robyn PyMC-Marketing Recast Measured Python R dbt Fivetran Supermetrics SQL

Skills

SQL Data Analysis Data Modeling Dashboarding Data QA Automation Scripting AI-assisted coding Marketing Analytics Attribution & Incrementality Marketing Mix Modeling Cross-functional Collaboration Stakeholder Communication Mentoring Self-starter