Senior CRM Data Analyst

massive-rocket; United States; Remote; USD 90,000 - 130,000; Full time

Benefits offered by this job

Remote-first

International team

BYOD policy

Job summary

Massive Rocket is seeking a client analytics lead to own the analytics lifecycle for accounts—from intake to insights and presentation. You will work with consultants, account managers, and client stakeholders in a CRM-focused environment, prioritizing analysis, experimentation, and reporting over campaign execution or data engineering.

You will write production SQL in a cloud warehouse, perform cohort and behavioral analyses, and build dashboards to track KPIs.

Qualifications

• Strong SQL skills in Snowflake or a comparable cloud warehouse.
• Dashboard and reporting experience with a BI tool, plus advanced Excel.
• Experience with digital or product analytics tools such as Amplitude, GA4, or Mixpanel.
• Hands-on cohort and behavioral analysis using customer, transaction, or loyalty data.
• Experimentation and statistics experience using Python or R, including test design, sample size, significance, and incremental lift.
• Experience using or building segmentation or propensity models, and sound commercial judgment when evaluating analysis requests.
• Clear client-facing English and ability to explain findings to non-technical audiences.

Responsibilities

• Own analytics requests and priorities within agreed account hours, identifying early when work needs separate project scoping.
• Clarify client questions and assess whether the requested analysis is framed appropriately before proceeding.
• Write production-quality SQL in a cloud data warehouse, develop analysis transformations, trace data lineage, and reconcile metrics across systems.
• Analyze customer, transaction, and loyalty behavior, including purchase patterns, revenue, frequency, retention, lifetime value, and offer performance.
• Design experiments and report results, covering sample size, holdouts, incremental lift, and differences between customer segments.
• Build and maintain BI dashboards and KPI definitions; validate and document figures before sharing results.
• Present clear recommendations to senior stakeholders, review other analysts’ SQL, coach consultants, and support junior analysts as the team grows.

Skills

Client-facing communication

Analytical mindset

Project management

Tools

Snowflake / cloud data warehouse

BI dashboards

Excel (Advanced)

Amplitude / GA4 / Mixpanel

Python or R

Job description

Role overview

Own analytics for client accounts, carrying questions from initial intake through analysis and presentation of findings. You'll work within a CRM-focused team and partner with consultants, account and project managers, and client stakeholders. The role centers on analysis, insight, experimentation, and reporting rather than campaign execution or data engineering.

Responsibilities

• Manage analytics requests and priorities within agreed account hours, identifying early when work needs separate project scoping.
• Clarify client questions and assess whether the requested analysis is framed appropriately before proceeding.
• Write production-quality SQL in a cloud data warehouse, develop analysis transformations, trace data lineage, and reconcile metrics across systems.
• Analyze customer, transaction, and loyalty behavior, including purchase patterns, revenue, frequency, retention, lifetime value, and offer performance.
• Design experiments and report results, covering sample size, holdouts, incremental lift, and differences between customer segments.
• Build and maintain BI dashboards and KPI definitions; validate and document figures before sharing results.
• Present clear recommendations to senior stakeholders, review other analysts’ SQL, coach consultants, and support junior analysts as the team grows.

Requirements

• Strong SQL skills in Snowflake or a comparable cloud warehouse.
• Dashboard and reporting experience with a BI tool, plus advanced Excel.
• Experience with digital or product analytics tools such as Amplitude, GA4, or Mixpanel.
• Hands-on cohort and behavioral analysis using customer, transaction, or loyalty data.
• Strong data quality, validation, and governance practices.
• Experimentation and statistics experience using Python or R, including test design, sample size, significance, and incremental lift.
• Experience using or building segmentation or propensity models, and sound commercial judgment when evaluating analysis requests.
• Clear client-facing English and ability to explain findings to non-technical audiences.

Nice to have

• Experience with CRM campaign platforms, a customer data platform, or uplift modeling.
• Retail, restaurant, or quick-service restaurant experience; agency or consulting background is useful but not required.

Benefits and work setup

• Remote-first work with an international team, career development, and team events.
• Bring-your-own-device policy; candidates need existing work authorization because sponsorship is unavailable.