Analytics Engineer: Central Analytics Warehouse (BigQuery + dbt)

We run a multi-brand e-commerce business and need a central analytics warehouse that consolidates our marketing and SEO data into one queryable place. SCOPE Build an analytics warehouse in Google BigQuery, in our GCP project, with scheduled ingestion from: - GA4 (native BigQuery export) - Google Search Console - API feeds we provide Model the raw data with dbt into clean, documented, well-named tables suitable for self-service querying, including AI-assisted querying via MCP. Build a set of evergreen Looker Studio reports on top of the modeled summary tables. Set up scheduled refreshes, write documentation, and hand off a system our team can maintain. REQUIREMENTS - Strong dbt and BigQuery experience with prior warehouse builds you can show - Experience ingesting from third-party APIs (custom Python connectors or Airbyte/Fivetran) - Experience building Looker Studio reports on BigQuery - Clear documentation habits ENGAGEMENT Initial build, with light monthly maintenance and tasks ongoing. TO APPLY Include a short description of a similar warehouse you built, the sources involved, and how you structured the dbt layer.