Key skills
BigQuerydbtLookerSQL optimizationeCommerce metricsdata quality checksdata ingestion toolscommunicationindependent workSQLAIETLData EngineeringAnalyticsFivetranShopifyPerformance OptimizationA/B TestingCommunication
About this role
TIU Consulting 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 analytics, marketing, and operational workflows.
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 2. Refactor and optimize SQL/dbt models 3. 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)