Data Analyst, Generalist

Scale Media•Burbank, CA

7d•$80,000 - $100,000•Remote

About The Position

Scale Media is seeking a hands-on, mid-level Data Analyst to support Supply Chain, Customer Service, and Brand Marketing teams. The analyst will investigate business operations and marketing performance, own analysis of inventory, customer service performance, and brand strategy, and translate complex data into actionable insights. The role includes forecasting inventory depletion and purchase-order timing; analyzing ERP data on stock, lead times, and fulfillment; evaluating promotions, campaigns, audience segments, and product launches; and tracking customer service metrics and experience friction points. The analyst will also prepare and transform data using tools such as KNIME, dbt, Alteryx, Tableau Prep, or Python/Pandas, write SQL to transform Snowflake data according to business rules, and build stakeholder-focused dashboards in Sigma. The position works collaboratively with a Data Engineer and business partners across the three supported functions. Scale Media is a fully remote company focused on science-backed wellness brands. It emphasizes ownership, candid feedback, thoughtful execution, clear communication, accountability, and continuous learning.

Requirements

At least 3 years of specific Data Analysis experience; the role is intended for a hands-on mid-level analyst.
Proven experience in DTC e-commerce.
Fluency in Shopify and Amazon Seller Central data schemas.
Strong proficiency with Snowflake SQL.
Strong proficiency with Sigma for building dashboards and workbooks.
Deep familiarity with e-commerce data schemas and Customer Service ticketing platforms, including extracting and modeling complex operational data.
Experience supporting marketing or brand teams with performance analytics, targeting metrics, and new product launch measurement.
Hands-on experience with inventory forecasting, purchase-order timing predictions, and supply chain metric tracking.
Ability to work across supply chain metrics, such as turnover ratios and lead times, and marketing metrics, such as conversion rates and promotion ROI.
Patience and precision in tracing product lifecycle data from warehouse through customer purchase and subsequent customer-service interactions.

Nice To Haves

Competency in KNIME or dbt; candidates experienced with Alteryx, Tableau Prep, or Python/Pandas are also considered and should be able to adapt quickly.
Awareness of ELT tools such as Hevo, Fivetran, Airbyte, and Azure.

Responsibilities

Build and maintain models to predict inventory depletion and recommend when to place purchase orders across the brand portfolio.
Ingest, clean, and analyze ERP (Odoo) data to provide insights on stock levels, lead times, and fulfillment efficiency.
Track and report inventory management metrics to help prevent stockouts, reduce overstock, and optimize cash flow.
Partner with Brand Marketing to analyze the ROI of promotions, targeted campaigns, and brand initiatives, including customer response to messaging and creative direction.
Support new product launch strategy and planning with historical analysis, initial-demand forecasts, and early performance tracking.
Provide data to support audience segmentation, market positioning, and long-term marketing strategy.
Analyze Customer Service platform data to track contact rates, ticket resolution times, and CSAT scores.
Connect customer service ticket data with fulfillment and inventory metrics to identify customer-experience friction and investigate service-level drops.
Prepare, clean, merge, and format data for analysis using KNIME, dbt, or similar tools.
Write efficient SQL to transform raw log-level data in Snowflake into datasets that reflect business rules.
Design, build, and maintain dashboards and workbooks in Sigma, translating complex queries into visualizations for Brand, Customer Service, and Inventory stakeholders.
Communicate with the Data Engineer about potential data-pipeline adjustments, using an understanding of ELT tools.