Senior BI Marketing Analyst: AI-Driven Insights & Dashboards

vibehackers; New York (NY); Híbrido; USD 90.000 - 120.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

401(k)

Health insurance

Dental insurance

Vision insurance

Flexible spending account

Health savings account

Paid time off

Parental leave

Descripción de la vacante

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.

Formación

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

Responsabilidades

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

Conocimientos

SQL

Looker Studio

Google Sheets

Apps Script

AI-assisted coding

Data visualization

Herramientas

BigQuery

Tableau

Power BI

dbt

Fivetran

Supermetrics

Descripción del empleo

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.