Data Engineer (Contract)

Overview 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 Key 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 Service Level Agreements (SLAs) Response Time: Acknowledge requests within 24 hours Critical Issues (P0): Immediate response and active resolution Standard Requests: Timeline provided within 72 hours Billing Model: Time & materials based on agreed scope and hours worked Requirements

• 5+ years experience in data engineering within a modern cloud data stack

• Advanced experience with BigQuery, Dbt, SQL perf