Data Engineer (Contract)

Anatta, a Shopify Platinum Partner, is seeking a highly experienced Data Engineer to support a fast-growing eCommerce brand. The role involves designing, building, and optimizing scalable data infrastructure across various workflows, utilizing tools like BigQuery, dbt, and Looker.

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:
• 1. Accelerate data transformation workflows
• 1. Refactor and optimize SQL/dbt models
• 1. 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

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)
• Strong understanding of marketing attribution
• Strong understanding of subscription data structures
• Experience integrating and modeling data from 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
• 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)