Data Analyst

Scale Media•Burbank, CA

11d•$80,000 - $95,000•Remote

About The Position

Scale Media is seeking a mid-level Data Analyst, referred to as a "Data Detective," to focus on customer retention and lifecycle analysis. The role requires expertise in CRM and loyalty platforms like Klaviyo and Loyalty Lion, with a strong emphasis on churn analysis, cohort tracking, and LTV maximization. The Data Analyst will partner with Brand and Retention teams to translate raw data into actionable insights regarding customer behavior, email/SMS performance, and brand loyalty. This is a fully remote, full-time position. The Data Analyst will be responsible for deep-dive analytics into customer data to understand LTV, repeat purchase rates, and cohort degradation. They will build churn prediction models and identify drop-off points in the customer journey. The role also involves empowering the marketing team with data on campaign performance, segment health, and loyalty program engagement. Additionally, the analyst will map the customer journey post-purchase, optimize the loyalty program by tracking reward point usage and tier migrations, and generate reports aligning brand initiatives with revenue growth and customer health. In terms of data transformation and visualization, the analyst will handle the final stages of data preparation using tools like KNIME or dbt to clean and format data. They will write SQL to transform raw data into usable datasets reflecting business rules and design/build dashboards in Tableau to present complex data visually to stakeholders.

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 candidates experienced with Alteryx, Prep, or Python who can adapt quickly are considered.
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 the 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

We are not looking for Junior Analysts or Senior Data Architects; we need a hands-on mid-level executor.
Open to candidates experienced with Alteryx, Tableau Prep, or Python who can adapt quickly to KNIME or dbt.

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.
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 overall customer health.
Handle the "last mile" of data prep using KNIME or dbt (or similar tools like Alteryx, Tableau Prep, or Python/Pandas) to clean, merge, and format data for specific analyses.
Write efficient SQL to transform raw log-level data in Snowflake into usable datasets that reflect specific business rules.
Design, build, and maintain high-impact dashboards in Tableau, translating complex SQL queries into visual stories for stakeholders.