Data & AI jobs

Data Analyst / Engineer

MalbonSanta Monica, CAFull-timeHybridPosted 1 month ago

$120k–$140k/yr listed by the employer

Key facts

Experience
4+ years
Degree
Bachelor's degree or equivalent

Looks real and checked open today.

On Malbon’s own careers site (Greenhouse).

  • Checked: On the company's own careers siteGreenhouse board
  • Checked: Checked open todayGreenhouse board
  • Checked: Pay listedJob posting
  • Checked: No reposts foundGreenhouse board
  • Trust score 89 / 100 · Looks good
See all 5 checksShow fewer
How we check

What you’ll do

  • Build and maintain data pipelines and dimensional models that centralize ecommerce, marketing, retail/POS, and ERP data.
  • Own source-of-truth datasets, metric definitions, dashboards, recurring reporting, and data quality and reconciliation.
  • Analyze channel performance, customer cohorts and retention, merchandising and inventory, experiments, and ecommerce unit economics.
  • Partner with Finance on forecasting, unit economics, and channel profitability.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • 4+ years in a data analyst, analytics engineer, or business intelligence role, with meaningful time at a DTC or ecommerce brand
  • Direct experience with ecommerce source data, including Shopify order and customer schemas, ad platform reporting, and an email/SMS platform
  • Hands-on experience with a transformation framework (dbt or equivalent) and a cloud data warehouse (Snowflake, BigQuery, Redshift, or Databricks)
  • Self-directed and comfortable building without an established playbook as one of the first dedicated data hires
  • Apparel, fashion, or lifestyle brand experience; exposure to retail/POS or wholesale data (preferred)
  • Exposure to reverse ETL, customer data platforms, and pushing audiences and attributes back into marketing tools (preferred)
  • Omni experience (preferred)

Education

  • Bachelor's degree in a quantitative field or equivalent practical experience

Skills

  • Advanced SQL, including CTEs, window functions, and query optimization against large tables
  • Fluency in a modern BI tool and the ability to build a semantic model, not just individual charts
  • Understanding of ecommerce and DTC unit economics: contribution margin, CAC payback, cohort retention, and sell-through
  • Working knowledge of digital attribution and its limits, including reconciling platform-reported conversions against order data
  • Rigorous validation habits, including checking date windows, denominators, and channel scope before reporting
  • Python for analysis and automation (preferred)
  • Demonstrated working habit with AI tools for analysis, code, and documentation (preferred)
  • Experiment design and measurement, including A/B tests, holdouts, and statistical significance (preferred)

Other requirements

  • Clearly distinguish observed data from inference and speak up when the data cannot support a conclusion
  • Based at the Santa Monica, CA HQ with a hybrid schedule of 3 days per week in-office

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Benefits

Health insurance
Competitive medical plans
Dental & vision
Competitive dental and vision plans
Retirement plan
401(k) with matching
Paid time off
Generous PTO policy and observed holiday calendar
Equity
Annual RSU grant
Remote work stipend
Monthly mobile/internet stipend
Other
Employee discount for eligible Malbon products

Full job description

From Malbon’s careers site

Malbon is hiring a Data Analyst/Engineer to join our Digital team! This role will be based out of our HQ in Santa Monica, CA and report directly to our Director of Growth Marketing. This person will own both sides of the data: building the data models and presenting analysis to business stakeholders (this is not a reporting-only or pipeline-only role).

Location: Malbon HQ is based in Santa Monica, CA. We are currently operating from a hybrid work schedule of 3 days a week in-office.

What You’ll Do

Data Infrastructure & Modeling

  • Build and maintain the pipelines that bring Shopify, ad platform, Klaviyo, GA4, retail/POS, and ERP data into a central warehouse
Show full descriptionShow less
  • Design and own the transformation layer, from staging through mart, with dimensional models, version control, and automated testing
  • Own the source-of-truth datasets other teams build on; define and document the business logic behind every core metric
  • Work in a Git-based analytics workflow: branch, review, test, and deploy model changes rather than editing production directly
  • Monitor pipeline runs and triage failures; tune warehouse cost and query performance through materialization strategy, incremental models, and refresh scheduling

Reporting & Self-Serve BI

  • Build and maintain dashboards across ecommerce, marketing, merchandising, retail, and finance
  • Establish KPI definitions and reporting standards so the organization works from one version of each number
  • Deliver the recurring reporting cadence: daily trading, weekly performance, and monthly business review

Data Quality, Reconciliation & Documentation

  • Own reconciliation across every channel revenue comes through (web, POS, retail, app, exchanges, and international) so totals hold up
  • Validate that reported figures match source systems before they reach leadership; investigate and resolve discrepancies
  • Maintain documentation, data lineage, and metric definitions so the work is durable and easy for others to build on
  • Identify where AI and automation can take on repetitive data work, such as reconciliation checks, documentation, and routine analysis, and put those workflows into production
  • Flag where the data cannot support a conclusion rather than producing a number that looks confident

Business Analysis & Insight

  • Channel efficiency, incrementality, and the gap between platform-reported and actual contribution
  • Customer analysis: cohorts, retention, repeat rate, LTV, and CAC payback by acquisition source
  • Merchandising and inventory analysis: sell-through, size curves, markdown impact, and demand signals for planning
  • Design and measure experiments across site tests, campaign tests, and product launches, and report results with stated confidence
  • Partner with Finance on forecasting, unit economics, and channel profitability

What You’ll Bring

  • 4+ years in a data analyst, analytics engineer, or business intelligence role, with meaningful time at a DTC or ecommerce brand
  • Bachelor's degree in a quantitative field or equivalent practical experience
  • Direct experience with ecommerce source data, including Shopify order and customer schemas, ad platform reporting, and an email/SMS platform
  • Advanced SQL, including CTEs, window functions, and query optimization against large tables
  • Hands-on experience with a transformation framework (dbt or equivalent) and a cloud data warehouse (Snowflake, BigQuery, Redshift, or Databricks)
  • Fluency in a modern BI tool and the ability to build a semantic model, not just individual charts; Omni experience a plus
  • Understanding of ecommerce and DTC unit economics: contribution margin, CAC payback, cohort retention, and sell-through
  • Working knowledge of digital attribution and its limits, with the ability to reconcile platform-reported conversions against order data and explain the difference
  • Rigorous validation habits: checks date windows, denominators, and channel scope before reporting a number
  • Clearly separates what is observed from what is inferred, and speaks up when the data won't support a conclusion
  • Clear communication to non-technical stakeholders
  • Self-directed and comfortable as one of the first dedicated data hires, building without an established playbook

Nice to Have

  • Apparel, fashion, or lifestyle brand experience; exposure to retail/POS or wholesale data
  • Python for analysis and automation
  • Demonstrated working habit with AI tools for analysis, code, and documentation
  • Exposure to reverse ETL, customer data platforms, and pushing audiences and attributes back into marketing tools
  • Experiment design and measurement: A/B tests, holdouts, and statistical significance

Compensation

This is a full-time position with an expected salary range of $120,000-$140,000. Compensation decisions are determined using a variety of job-related factors such as skill set, geographic location, market demands, experience, and education / certifications. If we extend an offer for employment, we will consider all individual qualifications.

Perks & Benefits

  • Benefits: Competitive plans for Medical, Dental, Vision
  • 401(k) + matching
  • Annual RSU grant
  • Generous PTO policy + observed holiday calendar
  • Monthly mobile/internet stipend
  • Employee discount for eligible Malbon products

Diversity & Inclusion

At Malbon, we celebrate individuality. Our team is built on inclusivity, creativity, and community. We’re committed to fostering a diverse workplace where every employee feels welcomed, respected, and empowered to grow.

Something wrong with this job? Report it · This flag looks wrong

Similar jobs

Senior Data Engineer

Gatik AI · Santa Clara, CA

$180k–$260k/yrHybrid

StrongChecked open todayPosted 7 days ago

Data Steward

Esri · Redlands, CA

$71k–$110k/yrOn-site

StrongChecked open todayPosted 8 days ago

Machine Learning Engineer

Voyager Technologies, Inc. · El Segundo, CA

$120k–$280k/yr · see postingOn-site

Wide pay rangeChecked open todayPosted 8 days ago

See more like this