Data Engineer (Contract)

Key Responsibilities

• Design, build, and maintain scalable data pipelines using BigQuery and dbt
• Arcitect 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 to:
• Accelerate data transformation workflows
• Refactor and optimize SQL/dbt models
• Automate anomaly detection and QA processes
• 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

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)
• Marketing attribution
• Subscription data structures

Preferred Qualifications

• 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)