Note: The job is a remote job and is open to candidates in USA. Scale Media builds and scales science-backed wellness brands and is investing in data and AI to improve product development and brand growth. The mid-level Data Analyst will support Supply Chain, Customer Service, and Brand Marketing teams through forecasting, operational and marketing analytics, data transformation, SQL modeling, and dashboard development.
Responsibilities
- Predictive Forecasting: Build and maintain models to predict inventory depletion rates and recommend optimal times to place additional Purchase Orders (POs) across our brand portfolio
- Platform Mastery: Ingest, clean, and analyze complex datasets from our ERP (Odoo) to provide granular insights on stock levels, lead times, and fulfillment efficiency
- Supply Chain Support: Track and report on core inventory management metrics, empowering the operations team to prevent stockouts, reduce overstock, and optimize cash flow
- Promotion & Targeting Analysis: Partner with the Brand Marketing team to analyze the ROI of promotions, targeted campaigns, and overall brand initiatives. Help the team understand what messaging, look, and feel is resonating with our customers
- New Product Launches: Support the strategy and planning phases of new product launches by providing historical data analysis, forecasting initial demand, and tracking early performance metrics
- Strategic Planning: Empower the brand team with actionable data for audience segmentation, market positioning, and long-term marketing strategy
- CS Performance Tracking: Analyze data from our Customer Service platforms (e.g., Zendesk, Gorgias) to track contact rates, ticket resolution times, and customer satisfaction (CSAT) scores
- Operational Optimization: Identify friction points in the customer experience by connecting CS ticket data with fulfillment and inventory metrics, acting as the lead investigator for service-level drops
- 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
- Dashboarding: Design, build, and maintain high-impact dashboards in Sigma. You will translate complex SQL queries into visual stories tailored for specific stakeholders in Brand, CS, and Inventory
Skills
- 3+ years of specific Data Analysis experience
- Proven experience in DTC E-commerce is required
- You must be fluent in Shopify and Amazon Seller Central data schemas
- Strong proficiency with Snowflake (SQL) and Sigma (building robust dashboards and workbooks)
- 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 ecommerce data schemas and Customer Service ticketing platforms, understanding how to extract and model complex operational data
- You have experience supporting marketing or brand teams with performance analytics, targeting metrics, and tracking the success of new product launches
- You have hands-on experience conducting inventory forecasting, PO timing predictions, and supply chain metric tracking
- You are comfortable bouncing between supply chain metrics (turnover ratios, lead times) and marketing metrics (conversion rates, promotion ROI)
- You have the patience and precision to trace a product's lifecycle from the warehouse to the customer, while also analyzing the marketing strategies that drove the initial purchase and the customer service interactions that followed
- Competency in KNIME or dbt is preferred
Benefits
- Medical, Dental, Vision, and Life Insurance
- Fully remote, full-time position
- Monthly work-from-home stipend
- Generous paid time off program
- Discounted products
- An amazing team to work alongside
Company Overview
Company H1B Sponsorship