Data Analyst

Scale Media•Burbank, CA

9d•Remote

About The Position

Scale Media is seeking a mid-level Data Analyst, referred to as a "Data Detective," to own customer retention and lifecycle analytics. The ideal candidate will be a "Lifecycle Data Master" with expertise in CRM and loyalty platforms (Klaviyo, Loyalty Lion), churn analysis, cohort tracking, and LTV maximization. This role involves partnering with Brand and Retention teams to translate raw data into actionable insights regarding customer behavior, email/SMS performance, and long-term brand loyalty. Scale Media is a profitable, self-funded, fully remote company with a strong focus on data and AI, known for its growth and positive work environment, recognized by Forbes, Great Place to Work, and Inc.

Requirements

3 years of specific Data Analysis experience.
Proven experience in DTC E-commerce is required.
Fluent in Shopify and Amazon Seller Central data schemas.
Strong proficiency with Snowflake (SQL) and Tableau (LOD expressions, complex visualizations).
Competency in KNIME or dbt is preferred, but open to candidates experienced with Alteryx, Prep, or Python who can adapt quickly.
Awareness of how ELT tools (like Hevo, Fivetran, Airbyte, Azure, etc.) function.
Deeply versed in the data schemas of Klaviyo and Loyalty Lion.
Hands-on experience conducting complex churn analysis, cohort retention modeling, and LTV forecasting.
Intimate understanding of lifecycle metrics and ability to analyze the impact of deliverability, Apple's Mail Privacy Protection (MPP) on open rates, click-to-purchase rates, and SMS unsubscribe behaviors.
Comfortable working with subscription metrics (MRR, churn rate, retention curves, payback periods).
Patience and precision to trace a single customer's journey through multiple touchpoints.

Nice To Haves

KNIME or dbt experience is preferred, but candidates experienced with Alteryx, Prep, or Python who can adapt quickly will be considered.

Responsibilities

Ingest, clean, and analyze complex datasets from CRM and loyalty platforms (Klaviyo, Loyalty Lion) to provide granular insights on LTV, repeat purchase rates, and cohort degradation.
Build robust churn prediction models and identify drop-off points in the customer journey to help the retention team intervene effectively.
Empower the marketing team with actionable data on email/SMS campaign performance, segment health, loyalty program engagement, and channel efficiency.
Analyze the post-purchase funnel to understand how product usage, subscription models, and brand interactions drive repeat behavior.
Act as the lead investigator for loyalty data, tracking earn/burn rates of reward points, VIP tier migrations, and the incremental value of the rewards program.
Generate reports that align brand initiatives and CRM metrics with overall revenue growth and customer health.
Handle the "last mile" of data preparation using tools like KNIME or dbt (or similar) to clean, merge, and format data for specific analyses.
Write efficient SQL to transform raw log-level data in Snowflake into usable datasets reflecting specific business rules.
Design, build, and maintain high-impact dashboards in Tableau, translating complex SQL queries into visual stories for stakeholders.