Data Engineer – Contract

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, construct, and sustain scalable data pipelines utilizing BigQuery and dbt.

• Architect and enhance warehouse-first data models to facilitate analytics, marketing, and operational reporting.

• Develop and manage Looker dashboards and semantic layers.

• Integrate and transform data from Shopify, Klaviyo, Loop (subscriptions/returns), and 3PL systems (e.g., ShipHero, ShipBob, etc.).

• Create automated workflows for data ingestion, validation, and monitoring.

• Implement best practices for data quality, governance, and documentation.

• Utilize AI tools (LLMs, automation frameworks) to accelerate data transformation workflows.

• Refactor and optimize SQL/dbt models.

• Automate anomaly detection and quality assurance processes.

• Collaborate with analytics, product, and marketing teams to translate business requirements into scalable data solutions.

• Diagnose data discrepancies and provide root-cause analysis.

• Suggest architectural enhancements to boost performance, reliability, and scalability.

⛳️ Requirements

• Over 5 years of experience in data engineering within a contemporary cloud data stack.

• Proficient experience with BigQuery, dbt, and SQL performance optimization.

• Experience in building and maintaining Looker dashboards and data models.

• Solid understanding of eCommerce metrics (AOV, LTV, churn, CAC, retention).

• Knowledge in marketing attribution.

• Familiarity with subscription data structures.

• Experience integrating and modeling data from Klaviyo, Loop or similar subscription platforms, Shopify, and 3PL systems.

• Proven experience in implementing data quality checks and validation pipelines.

• Excellent written and verbal communication skills.

• Capability to work independently with minimal supervision.

🏝️ Benefits

• Competitive compensation.

• Generous vacation policy.

• Parental leave.

• Training opportunities.

• Enjoyable company-wide retreats.