Sr Business Intelligence (bi) Marketing Analyst

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.

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

Location: New York, NY 10018

Salary: USD 90,000 - 120,000/year

Type: Full-time

Posted: 4 days ago

Category: AI/ML & Data

Company Rating: 1.0 (1 reviews)

Vibe Markers: 💻 Open Source, ✨ New

Experience Level: Senior

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.
• Bachelor’s degree required.

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.

Compensation & Benefits

• 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.

Tech Stack

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

Benefits

• 401(k)
• Dental insurance
• Flexible spending account
• Health insurance
• Health savings account
• Paid time off
• Parental leave
• Vision insurance