Senior Data Engineer: BigQuery, dbt & Looker for Ecommerce

Anatta - Shopify Platinum Partner; Charleston (SC); On-site; USD 100,000 - 130,000; Full time

Job summary

Anatta - Shopify Platinum Partner is seeking a highly experienced Data Engineer to join their team. This role involves supporting a fast-growing eCommerce brand by designing and optimizing scalable data infrastructure tailored for analytics, marketing, and operational workflows.

Ideal candidates will possess at least 5 years of data engineering experience, deep expertise in BigQuery, dbt, and Looker, and a strong understanding of eCommerce metrics. This project-based engagement offers flexibility and the chance to work with elite data systems.

Qualifications

• 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).
• Experience integrating and modeling data from Klaviyo, Loop, or similar platforms.

Responsibilities

• Design, build, and maintain scalable data pipelines using BigQuery and dbt.
• Architect and optimize warehouse-first data models for reporting.
• Develop and maintain Looker dashboards and semantic layers.
• Integrate and transform data from eCommerce platforms.
• Automate workflows for data ingestion, validation, and monitoring.

Skills

BigQuery

dbt

Looker

SQL performance optimization

eCommerce metrics

Data validation pipelines

Tools

Klaviyo

Loop

3PL systems

Fivetran

Daton

Airbyte

Job description

Anatta - Shopify Platinum Partner is seeking a highly experienced Data Engineer to join their team. This role involves supporting a fast-growing eCommerce brand by designing and optimizing scalable data infrastructure tailored for analytics, marketing, and operational workflows.

Ideal candidates will possess at least 5 years of data engineering experience, deep expertise in BigQuery, dbt, and Looker, and a strong understanding of eCommerce metrics. This project-based engagement offers flexibility and the chance to work with elite data systems.