Data Engineer (Contract)

Data EngineerWe are seeking a highly experienced Data Engineer to support a fast-growing eCommerce brand operating within a modern, warehouse-first data architecture. This is a project-based, on-demand engagement for a senior-level professional who can design, build, and optimize scalable data infrastructure across analytics, marketing, and operational workflows. The ideal candidate has deep expertise in BigQuery, dbt, and Looker, with hands-on experience modeling complex eCommerce data from platforms such as Shopify, Klaviyo, subscription systems (e.g., Loop), and 3PL providers.Key Responsibilities:Design, build, and maintain scalable data pipelines using BigQuery and dbtArchitect and optimize warehouse-first data models to support analytics, marketing, and operational reportingDevelop and maintain Looker dashboards and semantic layersIntegrate and transform data from Shopify, Klaviyo, Loop (subscriptions/returns) and 3PL systems (e.g., ShipHero, ShipBob, etc.)Build automated workflows for data ingestion, validation, and monitoringImplement best practices for data quality, governance, and documentationLeverage AI tools (LLMs, automation frameworks) to:Accelerate data transformation workflowsRefactor and optimize SQL/dbt modelsAutomate anomaly detection and QA processesCollaborate with analytics, product, and marketing teams to translate business requirements into scalable data solutionsTroubleshoot data discrepancies and provide root-cause analysisRecommend architectural improvements to improve performance, reliability, and scalabilityService Level Agreements (SLAs):Response Time: Acknowledge requests within 24 hoursCritical Issues (P0): Immediate response and active resolutionStandard Requests: Timeline provided within 72 hoursBilling Model: Time & materials based on agreed scope and hours workedRequirements:5+ years experience in data engineering within a modern cloud data stackAdvanced experience with BigQuery, Dbt, SQL performance optimizationExperience building and maintaining Looker dashboards and data modelsStrong understanding of:eCommerce metrics (AOV, LTV, churn, CAC, retention)Marketing attributionSubscription data structuresExperience integrating and modeling data from (not exactly similar software would work) Klaviyo, Loop or similar subscription platforms, Shopify 3PL systemsExperience implementing data quality checks and validation pipelinesStrong written and verbal communication skillsAbility to work independently with minimal oversightPreferred Qualifications:Experience working with distributed or agency environmentsExperience supporting DTC brandsExperience with marketing data pipelines (Google Ads, Meta, TikTok)Experience building reverse ETL workflowsFamiliarity with data ingestion tools (Fivetran, Daton, Airbyte, etc.)Experience implementing AI-assisted data transformation workflowsExposure to experimentation analytics (A/B testing frameworks)Ideal Candidate Profile:Understands both technical architecture and business implicationsCan move quickly in a project-based environmentThinks in systems, not just SQL queriesIs comfortable leveraging AI tools to improve speed and efficiencyHas experience working across marketing, product, and operations dataThe duties and responsibilities described here are not a comprehensive list and the scope of the job may change as necessitated by business demands. Anatta Design reserves the right to revise the job description as circumstances warrant.Compensation Transparency & Pay Philosophy At Anatta Design, we believe in fair and competitive compensation based on location. We post salary ranges in compliance with state requirements for U.S.-based roles, ensuring transparency for candidates in those regions. If you are applying from outside the U.S., please note that our pay scales are adjusted based on the cost of living and market conditions in each country.