Data Analyst

Scale Media builds and scales science-backed wellness brands and is investing heavily in data and AI to improve product development and brand growth. The mid-level Data Analyst will own analytics for customer retention and lifecycle management, using CRM, loyalty, e-commerce, and behavioral data to analyze churn, cohorts, LTV, and customer journeys. The role will also support Brand and Retention teams through data preparation, SQL transformation, and Tableau dashboarding.

Responsibilities:

• Deep-Dive Analytics: Ingest, clean, and analyze complex datasets from our CRM and loyalty platforms (Klaviyo, Loyalty Lion) to provide granular insights on LTV, repeat purchase rates, and cohort degradation
• Churn & Retention Expert: Build robust churn prediction models and identify drop-off points in the customer journey to help the retention team intervene effectively
• Lifecycle Support: Empower the marketing team with actionable data on email/SMS campaign performance, segment health, loyalty program engagement, and channel efficiency
• Customer Journey Mapping: Analyze the post-purchase funnel to understand how product usage, subscription models, and brand interactions drive repeat behavior
• Loyalty Program Optimization: Act as the lead investigator for our loyalty data. Track earn/burn rates of reward points, VIP tier migrations, and the incremental value of our rewards program
• Reporting: Generate reports that align brand initiatives and CRM metrics with overall revenue growth and overall customer health
• Data Preparation: While we have a Data Engineer managing the infrastructure, you will handle the "last mile" of data prep. You will use KNIME or dbt (or similar tools like Alteryx, Tableau Prep, or Python/Pandas) to clean, merge, and format data for specific analyses
• Business Logic Application: Write efficient SQL to transform raw log-level data in Snowflake into usable datasets that reflect our specific business rules (e.g., defining "active vs. lapsed vs. churned" customer logic)
• Dashboarding: Design, build, and maintain high-impact dashboards in Tableau. You will translate complex SQL queries into visual stories for stakeholders

Requirements:

• • Experience Level: 3 years of specific Data Analysis experience
• • Industry: Proven experience in DTC E-commerce is required
• You must be fluent in Shopify and Amazon Seller Central data schemas
• • Warehousing & BI: Strong proficiency with Snowflake (SQL) and Tableau (LOD expressions, complex visualizations)
• • Transformation Tools: Competency in KNIME or dbt is preferred, but we are open to candidates experienced with Alteryx, Prep, or Python who can adapt quickly
• • ELT Familiarity: Awareness of how ELT tools (like Hevo, Fivetran, Airbyte, Azure, etc.) function, so you can communicate effectively with our Data Engineer when pipeline adjustments are needed
• • You are deeply versed in the data schemas of Klaviyo and Loyalty Lion, understanding how to extract and model complex email, SMS, and rewards program data
• • You have hands-on experience conducting complex churn analysis, cohort retention modeling, and LTV forecasting
• • You intimately understand the nuances of lifecycle metrics and can easily analyze the true impact of deliverability, Apple's Mail Privacy Protection (MPP) on open rates, click-to-purchase rates, and SMS unsubscribe behaviors
• • You are comfortable working with subscription metrics (MRR, churn rate, retention curves, payback periods)
• • You have the patience and precision to trace a single customer's journey through multiple touchpoints (a purchase, an email open, an SMS click, a loyalty redemption) to understand their true lifetime value
• • Transformation Tools: Competency in KNIME or dbt is preferred