Analytics Engineer (dbt/BigQuery)

Format: Project-based contract, remote

We’ve already set up raw data ingestion into BigQuery via Airbyte and are now looking for an experienced Analytics Engineer (freelancer or agency) to model the data and build actionable management dashboards with minimal guidance from our side.

🔧 Scope of Work

• Data modeling in dbt: staging → intermediate → marts layers; defining core entities (customers, orders, products, sessions, support tickets).
• Sources for modeling and joins: Shopify, internal PostgreSQL tables, Google Ads, GA4, Meta Ads, Front (support), Klaviyo (email).
• Key metrics & KPIs: revenue, AOV, conversion rate, cohorts/LTV, ROAS, CAC, basic attribution, support SLA, email performance.
• Visualization: Metabase dashboards for leadership (North Star), marketing/growth, product, and operations/support teams with drill-down capabilities.

📦 Expected Deliverables

• A production-ready dbt project in our repository (models, tests, documentation).
• Source-to-Target mapping and a comprehensive data dictionary.
• Metabase dashboards with saved questions and filters.
• A Runbook detailing model build logic, update schedule, and best practices for safe expansion.

🛠️ Tech Stack

• BigQuery (data warehouse)
• Airbyte (ETL — already configured by us)
• dbt (data modeling)
• SQL
• Metabase (visualization)

💼 Terms

• Estimated initial scope: 6–12 weeks.
• Compensation: fixed-price or hourly.