Data Engineer (Contract) - North America

Anatta Design•Charleston, SC

18h•$50 - $70

About The Position

We 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

Requirements

5+ years experience in data engineering within a modern cloud data stack
Advanced experience with BigQuery, Dbt, SQL performance optimization
Experience building and maintaining Looker dashboards and data models
Strong understanding of: eCommerce metrics (AOV, LTV, churn, CAC, retention) Marketing attribution Subscription data structures
Experience integrating and modeling data from (not exactly similar software would work) Klaviyo, Loop or similar subscription platforms, Shopify 3PL systems
Experience implementing data quality checks and validation pipelines
Strong written and verbal communication skills
Ability to work independently with minimal oversight

Nice To Haves

Experience working with distributed or agency environments
Experience supporting DTC brands
Experience with marketing data pipelines (Google Ads, Meta, TikTok)
Experience building reverse ETL workflows
Familiarity with data ingestion tools (Fivetran, Daton, Airbyte, etc.)
Experience implementing AI-assisted data transformation workflows
Exposure to experimentation analytics (A/B testing frameworks)

Responsibilities

Design, build, and maintain scalable data pipelines using BigQuery and dbt
Architect and optimize warehouse-first data models to support analytics, marketing, and operational reporting
Develop and maintain Looker dashboards and semantic layers
Integrate 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 monitoring
Implement best practices for data quality, governance, and documentation
Leverage AI tools (LLMs, automation frameworks) to: Accelerate data transformation workflows Refactor and optimize SQL/dbt models Automate anomaly detection and QA processes
Collaborate with analytics, product, and marketing teams to translate business requirements into scalable data solutions
Troubleshoot data discrepancies and provide root-cause analysis
Recommend architectural improvements to improve performance, reliability, and scalability