Google BigQuery specialist to handle data migration

Looking for a skilled BigQuery specialist to facilitate the migration of analytical data from Google Analytics into BigQuery.

Namely, this involves the transfer of lifetime Google Analytics 3 data as well as the backfilling and ongoing synchronisation of Google Analytics 4 information. The selected candidate will configure BigQuery and design optimised storage schemas to preserve all pertinent metrics and dimensions from GA3 while ensuring comprehensive historical datasets from GA4.

Automated scripting must also be set up to upload new GA4 data on a daily basis and implement retention policies addressing privacy regulations. Data integrity and performance are top priorities.

You should demonstrate extensive experience architecting similar analytics solutions on BigQuery. The ability to future-proof the platform through an elastic data architecture and support ongoing needs as they evolve is indispensable.

Please provide examples of past projects, rates, and anticipated timelines.