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

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

Data Engineer – Contract

Key skills