johnnie-O · 19 hours ago
Analytics Engineer
Johnnie-O is a branded lifestyle apparel company seeking an outstanding Analytics Engineer to join their data team. The role focuses on analytics engineering and data engineering responsibilities, collaborating with Marketing and eCommerce stakeholders to deliver trusted reporting foundations and operationalize datasets for marketing efforts.
Responsibilities
Build and maintain DBT models for Shopify and related sources, maintaining curated marts for orders, customers, products, inventory/fulfillment, refunds/returns, discounts/promotions, and cohorting
Define and standardize marketing and ecommerce KPIs (channel performance, CAC, ROAS, funnel conversion, retention/cohorts, LTV, promotion performance, etc.)
Create durable, well-documented “gold” datasets that reduce channel reporting inconsistencies and enable trusted executive reporting
Collaborate on ingestion and integration of marketing/ecomm data (e.g., Shopify, GA4, ad platforms, email/SMS platforms, CDP), including handling schema evolution and source changes
Contribute to pipeline resiliency: monitoring inputs, improving failure recovery/backfills, and improving pipeline performance
Support orchestration workflows (e.g., DBT Cloud, Airflow, Azure Data Factory), focusing on dependable scheduling, dependency management, and operational visibility
Build and maintain attribution-ready datasets by standardizing UTMs, channel groupings, campaign mappings, and conversion alignment
Partner with stakeholders to align on attribution assumptions (last-click vs other heuristics), reporting windows, and reconciliation strategies across attribution platforms
Own the creation and governance of consistent definitions and a ubiquitous language within the Marketing & eCommerce domain, establishing a durable “source of truth” that aligns stakeholders across platforms and reporting
Work closely with the Data Scientist to create marts, training/validation datasets, and experimentation-ready tables for marketing and ecommerce initiatives
Support testing and iteration loops by producing reliable datasets for A/B tests, holdouts, lift measurement, audience evaluation, and lifecycle performance tracking
Help operationalize model outputs and experimentation artifacts into analytics-ready tables that BI and stakeholders can use
Partner closely with the BI Engineer to ensure marketing and ecommerce datasets are optimized for reporting performance and semantic consistency
Provide stable marts and clear definitions so BI dashboards are maintainable and stakeholders can self-serve with confidence
Implement strong DBT testing coverage and freshness expectations for high-impact marketing/ecomm models
Maintain documentation (DBT docs, lineage, and a marketing/ecomm data dictionary) emphasizing metric definitions and “how to use” guidance
Qualification
Required
2+ years experience as an Analytics Engineer or Data Engineer with meaningful ownership of production data models
Advanced SQL and strong proficiency with DBT (layering strategies, incremental models, tests, macros, docs)
Strong familiarity with Shopify (or similar eCommerce platforms) data structures and ecommerce lifecycle concepts (orders, customers, products, discounts, refunds, fulfillment, etc.)
Practical experience with marketing attribution concepts (UTMs, events, conversion windows, channel taxonomy, campaign mapping, sales‑funnel attribution, etc.)
Working proficiency in Python for data workflows (APIs, automation, validation scripts) is required
Comfort collaborating on orchestration/ELT tools (e.g., DBT Cloud, Azure Data Factory, Airflow, Fivetran, etc.)
Experience with modern warehouses (e.g., Snowflake, BigQuery) and production modeling practices (git, code reviews, CI/CD)
Strong cross-functional communication skills—able to align stakeholders on definitions and tradeoffs
Strong communication skills—able to translate business operations into clean, enforceable data definitions
Ability to work independently as well as collaboratively across functional teams
Self-motivated with a strong desire to learn, adapt, and continuously improve
Demonstrated ability to execute efficiently and effectively
Preferred
Experience with GA4 event data, identity stitching considerations, and web analytics pipelines
Experience with common marketing platforms (Google Ads, Meta, Amperity, etc.)
Experience building experimentation/measurement datasets (holdouts, lift, incrementality)
Familiarity w/ Domain Driven Design concepts
Benefits
Health, Dental, Vision, Short-Term disability insurance, 401K, FSA, Life Insurance benefits.
Paid time off and paid holidays.
Employee discounts.
Company
johnnie-O
Johnnie-O offers a collection of SoCal lifestyle essentials for men and boys.
H1B Sponsorship
johnnie-O 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
2025 (1)
Funding
Current Stage
Growth StageTotal Funding
$131.48M2022-04-25Series Unknown· $108M
2019-01-18Series Unknown· $4.28M
2017-01-20Series Unknown· $8.81M
Recent News
2026-01-13
Company data provided by crunchbase