Senior Consultant - Marketing Analytics
Fractal Analytics
New York City, NY (Remote)
$100K/yr - $120K/yrIn-houseFull-timeSenior level
19 hrs ago
Sr Business Intelligence (BI) Marketing Analyst
New York City, NY (Hybrid)
$90K/yr – $120K/yrSenior Level3+ years expFull time
Posted 23 hrs ago
Job Summary
Own the end-to-end data pipeline and measurement framework for client marketing analytics, from data ingestion and validation to dashboards, MMM/attribution, and conversion tracking across platforms.
- Build and maintain SQL pipelines in BigQuery, aligned to client data sources
- Develop Looker Studio dashboards tied to client KPIs
- Implement and troubleshoot conversion tracking and server-side measurement
Job Description
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
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
Preferred
- 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)
- Marketing mix modeling: 1 year (preferred)
Benefits
- 401(k)
- Dental insurance
- Flexible spending account
- Health insurance
- Health savings account
- Paid time off
- Parental leave
- Vision insurance
Grain Group
0.0 Glassdoor
Since 2010, our singular mission has been to accelerate the growth of the world’s most ambitious brands. By aligning business insights with ROI-driven marketing - we unlock the competitive edge that allows clients to disrupt categories and reimagine industries. Lead by a team of strategic thinkers and doers - with diverse backgrounds in business, media, technology and finance.What does the fastest selling spirits brand have in common with a revolutionary global private education venture? Ambition. Grain works with brands that are comfortable being uncomfortable. We don’t chase trends - we build dynamic roadmaps that allow clients to traverse the ever-evolving consumer and digital landscape. Data is the heartbeat of every plan, bringing discipline to the biggest of dreams. Our process is simple; start with a meaningful business challenge, scenario plan, build hypotheses, align resources (media, creative, consumer experience, analytics), activate and iterate. We remove the guesswork with a systematic approach to brand performance that allows clients to invest with confidenceEvery engagement is bespoke. We pair boutique innovation with full agency capabilities. Our in-house, fully integrated media, design, development, and business intelligence teams allow us to manage all aspects of performance, from brand inception to transformation and exit.We don’t look like other agencies, which means our clients don’t get “agency” work. Our team comes from diverse backgrounds, led by experienced leaders in communications, technology, investment banking, and finance. We’ve generate award-winning work (The One Show, Shorty’s, Cannes Lions), and were an AdWeek 2024 Fastest Growing Agency.
Founded in 2010
New York, New York, USA
32 employees (15 in marketing)
0% recommend to a friend
Salaries
Posted range
$90K/yr – $120K/yr
Taken straight from the job posting.
Marketing Analytics median pay in the United States
$110K/yrMost earn $85K to $159K. Based on 1,905 salaries, including bonus and equity.
Marketing Team
Marketing Team Size
12 (38% of company)
Marketing Roles Posted (Last 30 Days)
2
Traffic Signals
Monthly Visitors
1.8K
Monthly Google Ads Budget
$44.3K
Traffic Source Mix
Search
60.1%
Direct
23.7%
Referral
4.9%
Social
10.1%
Paid
1.2%
Headcount Trend
Current headcount: ~32
Links
This role is listed on SalaryGuide for informational purposes. SalaryGuide is not the employer, recruitment agency, or hiring representative for this position. Hiring decisions and the application process are managed by the employer. SalaryGuide will never ask candidates to pay to apply for a job or request bank details or identification documents as part of an application.
