Overview:
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 DTCWrite 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)
