Senior CRM Data Analyst

Massive Rocket; United States; Remote; USD 110,000 - 170,000; Full time

Job summary

Massive Rocket seeks a Senior CRM Data Analyst to own analytics for client accounts from intake to readouts. You’ll deliver insights, reporting, and strategic input with trust from the CRM team and clients.

You’ll work in a CRM pod with the Lead Consultant and collaborate across marketing, loyalty, and data teams. You’ll focus on analysis, insight, and reporting rather than Braze builds or data engineering.

Qualifications

• Production‑quality SQL in Snowflake or another cloud warehouse.
• Experience building dashboards and reporting in a BI tool such as Power BI or Tableau, plus advanced Excel.
• Experience with a product or digital analytics tool (Amplitude, GA4, Mixpanel).
• Hands‑on cohort and behavioural analysis on customer, transaction or loyalty data.
• A strong grasp of data quality, validation and governance.
• Experimentation and statistics in Python or R, including test design, sample size, significance and incremental uplift.
• Experience building or using a propensity or segmentation model, such as recency and frequency tiers or 90/180/365‑day activity tiers.
• CRM, loyalty or customer analytics experience, with the commercial sense to challenge a flawed question.
• Clear client‑facing English, with the ability to explain findings to non‑technical audiences in writing and in person.

Responsibilities

• Own the analytics workstream on your accounts, running request intake and prioritisation within the agreed hours and flagging early when a request is project sized.
• Act as the client’s go‑to contact for data questions, testing whether each question is framed fairly before you run the analysis.
• Write production‑quality SQL in the client’s warehouse (Snowflake, Databricks or similar) and develop the transformation logic behind your analysis.
• Trace data lineage, fix gaps in existing reports, SQL and data events, and reconcile metrics across systems, including the client’s analytics tool (Amplitude, GA4).
• Run cohort, behavioural and decomposition analysis on transaction and loyalty data, covering first vs repeat purchase, ATV, revenue, frequency, retention, LTV and offers.
• Build or use propensity and segmentation models, and connect insights on segments, offers, channels and seasonality to revenue, efficiency and cost savings.
• Design and report on tests independently, from sample size and holdout design to incremental uplift and results by segment, using AI to make your analysis and testing faster and more effective.
• Build and maintain dashboards in the client’s BI tool (Power BI, Tableau, Looker or similar) and own the KPI definitions behind them.
• Validate and document every figure before it reaches the client, and present findings and recommendations to senior stakeholders in clear, strategic stories.
• Review other analysts’ SQL, coach consultants on using data, manage 1–2 junior analysts as the team grows, and build reusable assets that work across accounts

Skills

SQL

Snowflake

Databricks

Redshift

Power BI

Tableau

Looker

Excel

Amplitude

GA4

Mixpanel

Python

R

Propensity modeling

Tools

Power BI

Tableau

Looker

Snowflake

Databricks

GA4

Mixpanel

Job description

Who Are Massive Rocket?

Massive Rocket is a rapidly scaling Braze and Snowflake agency on a mission to transform how digital marketing, product, and engineering teams connect. In just five years, we’ve grown at speed and are now gearing up for our next big milestone: hitting $100M in revenue. We build human experiences at scale, powered by cutting‑edge web, mobile, cloud, data, and AI technologies. If you’re excited by innovation, love solving complex challenges, and want to help shape the future of digital experiences, you’ll feel right at home here.

Every role at Massive Rocket is entrepreneurial. The people who thrive here don’t just focus on their own remit — they understand the goals of the teams around them and actively contribute to the success of their colleagues, customers, and partners. We’re building a culture of ownership, collaboration, and growth, and we’re looking for people who want to make a real impact.

Who Are We Looking to Add to Our Team?

As a Senior CRM Data Analyst at Massive Rocket, you’ll be the single, hands‑on owner of analytics for your client accounts. You’ll take a request from the client’s first message all the way to a readout without supervision, and your insights, outcomes reporting and strategic perspective will be something both our CRM team and our clients can trust.

You’ll be part of our data team and work inside a CRM pod, where the pod’s Lead Consultant sets day‑to‑day priorities. You’ll partner closely with the Lead and Senior Consultants on the account, Account Management and Project Management, as well as the client’s marketing, loyalty and data teams. Your focus is analysis, insight and reporting rather than Braze builds, campaign execution or data engineering.

You’ll thrive here if you care about every number being right, can turn analysis into recommendations people can act on, and know when a request fits the agreed hours and when it needs scoping as a project.

What Will You Do?

• Own the analytics workstream on your accounts, running request intake and prioritisation within the agreed hours and flagging early when a request is project‑sized
• Act as the client’s go‑to contact for data questions, testing whether each question is framed fairly before you run the analysis
• Write production‑quality SQL in the client’s warehouse (Snowflake, Databricks or similar) and develop the transformation logic behind your analysis
• Trace data lineage, fix gaps in existing reports, SQL and data events, and reconcile metrics across systems, including the client’s analytics tool (Amplitude, GA4)
• Run cohort, behavioural and decomposition analysis on transaction and loyalty data, covering first vs repeat purchase, ATV, revenue, frequency, retention, LTV and offers
• Build or use propensity and segmentation models, and connect insights on segments, offers, channels and seasonality to revenue, efficiency and cost savings
• Design and report on tests independently, from sample size and holdout design to incremental uplift and results by segment, using AI to make your analysis and testing faster and more effective
• Build and maintain dashboards in the client’s BI tool (Power BI, Tableau, Looker or similar) and own the KPI definitions behind them
• Validate and document every figure before it reaches the client, and present findings and recommendations to senior stakeholders in clear, strategic stories
• Review other analysts’ SQL, coach consultants on using data, manage 1–2 junior analysts as the team grows, and build reusable assets that work across accounts

What Makes You a Great Fit

• Production‑quality SQL in Snowflake or another cloud warehouse (Databricks, Redshift or similar)
• Experience building dashboards and reporting in a BI tool such as Power BI or Tableau, plus advanced Excel
• Experience with a product or digital analytics tool (Amplitude, GA4, Mixpanel)
• Hands‑on cohort and behavioural analysis on customer, transaction or loyalty data
• A strong grasp of data quality, validation and governance
• Experimentation and statistics in Python or R, including test design, sample size, significance and incremental uplift
• Experience building or using a propensity or segmentation model, such as recency and frequency tiers or 90/180/365‑day activity tiers
• CRM, loyalty or customer analytics experience, with the commercial sense to challenge a flawed question
• Clear client‑facing English, with the ability to explain findings to non‑technical audiences in writing and in person

Bonus points if you have:

• Experience with Braze, SFMC or Adobe Campaign, and an understanding of how segments and insights are used in them
• Experience with a CDP such as Hightouch, Segment or similar
• QSR, restaurant or retail experience
• Uplift modelling experience
• Agency or consultancy experience (in‑house candidates who work closely with stakeholders are very welcome too)

Why You’ll Love Working Here

Rocket‑Fuelled Growth – Big challenges, fast learning, and the chance to level up quicker than anywhere else

A Culture That Actually Gives a Damn – Supportive, positive, and built around people who want to see you win

A Global Crew – Collaborate with brilliant teammates across Europe, the US, and beyond

Remote‑First for Life – Work from wherever you feel your best

Real Career Momentum – Clear progression, real ownership, and space to grow into your next chapter

Moments That Matter – Meetups, events, and team experiences that make the journey unforgettable

A Few Things to Know Before We Get Started

Bring Your Own Device – We operate a BYOD policy, so you’ll use your own kit for work

Right to Work – You’ll need a valid work visa; we’re not able to offer sponsorship at the moment

ID Checks – We may ask for proof of identity (passport, ID card, or a recent utility bill)

References – We may request two references, so have names, relationships, and contact details ready

For Contractors – Proof of incorporation and up‑to‑date insurance is required