About the role
from listingOverview
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)
Language: English (required)
Location: Hybrid. Must commute to New York, NY 10018 (in person) currently 3-days a week.
Benefits
401(k)
Dental insurance
Flexible spending account
Health insurance
Health savings account
Paid time off
Parental leave
Vision insurance
Job Type: Full-time
Pay: $90,000.00 - $120,000.00 per year
Ability to Commute:
New York, NY 10018 (Required)
Seniority level: Mid-Senior level
Employment type: Full-time
Industries: Advertising Services