Sr Business Intelligence; BI) Marketing Analyst

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

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 & Big Query pipelines, Looker Studio dashboards, Google Sheets/Apps Script automations, and building internal tools with AI coding assistants.

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.

• Write and maintain SQL in Big Query 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.

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

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

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.

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

Big Query 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

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