Scale Media ยท 9 hours ago
Data Analyst
United States
Full-time
Remote
Entry, Mid Level
$80K/yr - $90K/yr
2+ years expScale Media is a company that builds and scales mission-driven health and wellness brands through data-driven storytelling and performance marketing. They are seeking a mid-level Data Analyst who will analyze complex datasets, support customer acquisition strategies, and collaborate with the Finance team to ensure data integrity and financial reporting.
Computer Software
Responsibilities
Deep-Dive Analytics: Ingest, clean, and analyze complex datasets from major ad networks (Meta, Google, TikTok, Amazon Ads) to provide granular insights on ROAS, CAC, and LTV
Attribution Expert: Move beyond 'last-click.' Implement and refine multi-touch attribution models, run incrementality tests, and manage lift studies to determine the true value of our media spend
Media Buying Support: Empower the growth team with actionable data on creative performance, audience segmentation, and channel efficiency
Finance Support: Collaborate with the Finance team to support P&L analysis and assist in validating financial reports
Reconciliation Investigations: Act as the lead investigator for revenue discrepancies. You will reconcile data between payment processors (Stripe/Shopify Payments/Amazon), bank deposits, and our internal database to ensure every dollar is accounted for
Reporting: Generate reports that align operational metrics with financial outcomes (understanding QuickBooks report structures is a plus)
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 'new vs. returning' customers logic)
Dashboarding: Design, build, and maintain high-impact dashboards in Tableau. You will translate complex SQL queries into visual stories for stakeholders
Qualification
Required
2-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)
You understand the difference between pixel data, server-side tracking, and ad-platform reported data
You have executed or analyzed conversion lift tests and understand incrementality (preferably using a UMM tool like WorkMagic, Lifesight, Measured etc.)
You can explain the discrepancy between Facebook Ads Manager revenue and Shopify Analytics revenue without blinking
You are comfortable working with financial concepts (Revenue recognition, COGS, Net vs. Gross Sales)
You have the patience and precision to trace a single transaction through the entire data lifecycle to solve revenue mismatches
Preferred
Competency in KNIME or dbt is preferred, but we are open to candidates experienced with Alteryx, Prep, or Python who can adapt quickly
Awareness of how ELT tools (like Hevo, 5tran, Airbyte, Azure etc.) function, so you can communicate effectively with our Data Engineer when pipeline adjustments are needed
Benefits
Health, dental, and vision insurance
Paid holidays + 15 days PTO (+ 3 floating days)
$240 annual wellness stipend
Professional Development stipend
Monthly work-from-home stipend
Remote-first culture with collaboration hubs
Company
Scale Media
Scale is a tech-driven company that builds next generation health and wellness DTC brands, smarter.
51-200 employees
H1B Sponsorship
Scale Media has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (2)
Funding
Current Stage
Growth StageLeadership Team
Ben Flohr
Co-Founder
Ziv Haklili
Co-Founder
Company data provided by crunchbase