Marketing Data Analyst

Arc

United States

Remote

USD 110,000 - 165,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Consultancy-me is seeking a Marketing Analytics professional to own reporting end-to-end for multiple accounts, spanning B2B and B2C clients. You will build dashboards, connect CRM and ad data, and deliver repeatable insights that drive spend efficiency and revenue growth.

You will work with HubSpot and Salesforce data, craft SQL-based pipelines, and partner with paid search and paid social teams to adapt reports as needs evolve.

Qualifications

  • 4+ years in marketing analytics and building reports
  • Experience building funnel/pipeline reporting from HubSpot or Salesforce
  • Experience with B2C performance reporting: spend, conversion, ROAS
  • Proficiency in SQL and coding by hand or with AI tools
  • Strong knowledge of BigQuery and advanced Google Sheets
  • Experience with paid search and paid social data
  • Agency or multi-client environment experience
  • Able to translate requests into reports with minimal direction
  • Detail-oriented and quality-driven data validation

Responsibilities

  • Build B2B reporting: funnel and cohort tables joining CRM data to ad spend
  • Support B2C performance reporting: pacing, spend and revenue analysis
  • Create creative analysis to show which concepts drive results
  • Turn requests into reports with cross-channel data sources
  • Develop data pipelines using SQL, Apps Script or Python
  • Reconcile CRM numbers with platform data and explain gaps
  • Document logic and provide notes for future maintenance
  • Collaborate with paid search, paid social and creative leads

Skills

SQL
BigQuery
Google Sheets
Paid search
Paid social

Tools

HubSpot
Salesforce
BigQuery

Job description

ABOUT the company

Client is a performance marketing agency running paid acquisition across B2B, e-commerce, and consumer brands — long-sales-cycle accounts where revenue closes in a CRM, and transactional ones where it closes in a cart. The work sits with senior operators: no coordinators between you and the strategy, and no junior team executing your plan badly.

For an analyst who likes building more than maintaining, that means new reporting to stand up for every new account, channel and creative leads who actually use what you build, and the room to own your work end to end.

WHY THIS ROLE EXISTS

Since we first scoped this role, we have added several new clients, mostly B2B. Each one needs reporting built from the ground up, and the reports keep changing as the channel and creative teams ask XXXX XXXX. Maintaining what is already built will not take time off the team’s plate; building will. We need someone who can take a request, work out where the data lives, and build reporting we can trust without our Marketing Analytics Lead rebuilding it.

WHAT YOU’LL DO
  • Build B2B reporting: funnel and cohort tables (MQL → SQL → Opportunity), influenced pipeline, and channel and campaign breakdowns, joining CRM data to ad spend
  • Support B2C accounts too: performance, pacing and creative reporting for our consumer clients, where the focus is spend efficiency, conversion and revenue
  • Build creative analysis: work with our creative lead to show which concepts, formats and messages drive results, and when a creative is wearing out
  • Turn requests into reports: work with our paid search, paid social and creative leads to scope what they need, ship a first version, and improve it as their questions change
  • Build the pipelines behind the reports: combine CRM data (HubSpot, Salesforce), ad platform data and BigQuery into one reporting layer using SQL, Apps Script or Python. Write the code yourself or with AI coding tools like Claude Code; using AI is encouraged
  • Connect the dots: reconcile CRM numbers against platform numbers and explain the gaps (attribution, consent loss, conversion lag)
  • Keep what you build accurate: you own the reports you build, and leave enough notes that someone else could follow the logic
  • Our Marketing Analytics Lead will stay responsible for measurement design, test design sign-off and final QA. You own the build.
YOUR FIRST 3 MONTHS
  • Weeks 1–4: Learn our reporting setup and ship your first build, a new view on an existing B2B report
  • Weeks 5–8: Own a full B2B build end to end, from data connection to finished report, with our Marketing Analytics Lead reviewing
  • Weeks 9–12: Take requests directly from the paid search, paid social and creative leads across B2B and B2C accounts. Our Marketing Analytics Lead will review your work, but will not direct it step by step
HOW WE’LL MEASURE SUCCESS
  • Builds ship: a request becomes a usable first version within the agreed time, and review is checking, not rebuilding
  • Accuracy: an error rate under 2%, nothing wrong reaches a client, and CRM numbers reconcile to the source
  • Hours off our lead’s plate: our Marketing Analytics Lead’s time on build work goes down month over month
  • The team uses it: channel and creative leads rely on what you build in weekly and quarterly reviews
WHAT WE ARE LOOKING FOR
  • B2B reporting experience is required: you’ve built funnel or pipeline reporting from HubSpot or Salesforce yourself, and you understand lifecycle stages, contact-to-deal joins and deduplication
  • B2C performance reporting experience: spend, conversion, ROAS and pacing for consumer brands
  • 4+ years in marketing analytics, including building reports, not only maintaining them
  • Writes efficient SQL and code, by hand or with AI tools
  • BigQuery and SQL; advanced Google Sheets
  • Paid search and paid social data, and eager to learn new platforms as we add them
  • Agency or multi-client experience: comfortable working across several accounts at once
  • Can take a loose request, ask XXXX XXXX questions and deliver without step-by-step direction
  • Detail-oriented: checks the numbers before anyone else sees them
NICE TO HAVES
  • Tracking and measurement basics: conversion events, UTMs, GTM/GA4, and how consent and attribution settings affect the data
  • Statistics for marketing: A/B testing, significance testing, power and sample size, and knowing when a result is inconclusive
  • Incrementality and lift testing: holdouts, geo tests or conversion lift studies
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Marketing Data Analyst
Senior Marketing Data Analyst

Pilot • San Francisco (CA)

On-site
USD 120,000 - 190,000
Flexible vacation
Holiday pay
Parental leave 100% pay (12 weeks)
+2
Senior Marketing Analytics Manager
Senior Marketing Analytics Manager

Horizon3 • United States

Remote
USD 120,000 - 190,000
Growth opportunities
Innovation‑driven culture
Inclusive and diverse team
+1
Demand Generation Lead
Demand Generation Lead

FairCom • Columbia Township (MO)

On-site
USD 90,000 - 130,000
Senior Marketing Analyst
Senior Marketing Analyst

Fivetran, Inc. • Michigan

Hybrid
USD 100,000 - 150,000
Manager, Marketing Analytics
Manager, Marketing Analytics

Mile Marker • New York (NY)

Hybrid
USD 120,000 - 180,000
Principal of Marketing Analytics
Principal of Marketing Analytics

Elastic • United States

Hybrid
USD 140,000 - 210,000
Fully paid health coverage for you and
Family health coverage
Flexible location and schedule
+3
Director, Analytics
Director, Analytics

unlockhealth • United States

On-site
USD 140,000 - 190,000
Junior Marketing Analyst: AI-Driven Data & Reporting
Junior Marketing Analyst: AI-Driven Data & Reporting

Team SI • Little Rock (AR)

Hybrid
USD 42,000 - 55,000
Analytics Senior Lead
Analytics Senior Lead

pmg • Dallas (TX)

On-site
USD 90,000 - 150,000
Performance Marketing Lead
Performance Marketing Lead

Weekday AI • Missouri

Remote
USD 120,000 - 180,000