Senior Product Analyst — Cross-Platform Analytics Setup (GA4, BigQuery, GTM, Stape)

We are looking for a Senior Product Analyst to complete cross-platform analytics setup for AirAdvisor (flight compensation claims service). We have an existing foundation: GA4, GTM, and BigQuery (data warehouse) are already in place. We need someone to finish the remaining integration and validation work across 4 milestone areas. SCOPE (Milestone-Based): M1: - Troubleshoot G-Ads tracking issues - URGENT (potential conversion data pollution due to cookie consent mis-config) M2: — G-Ads, Microsoft Ads Tracking & BigQuery Ingestion - Set up Microsoft Ads conversion tracking (offline + enhanced) - Ingest Microsoft Ads data into BigQuery via Fivetran or custom pipeline - Validate conversion data accuracy across platforms M2 — Internal Data x GA4 Integration in BigQuery - Design join keys between internal claim data and GA4 sessions - Build deduplication and attribution logic - Create unified user journey views in BigQuery M3 — Reporting & Intelligence Layer - Build a Looker Studio dashboard OR semantic layer for LLM-based querying - Key metrics: acquisition cost by channel, claim conversion rates, user LTV signals - Must connect to BigQuery as single source of truth M4 — Metrics Testing & QA - End-to-end validation of all tracking and data pipelines - Cross-platform reconciliation (GA4 vs BigQuery vs Microsoft Ads vs internal) - Document data model, known limitations, and handover notes REQUIREMENTS: - Strong hands-on experience with GA4, GTM, BigQuery, and SQL - Experience with ad platform conversion tracking (Google/Microsoft Ads) - Ability to write and optimize BigQuery SQL for analytics use cases - Understanding of attribution logic and cross-platform data joins - This is NOT a dashboard-only role — we need deep technical analytics skills HOW WE WORK: - Fixed-price, milestone-based payments only (no hourly) - Work tracked via Hubstaff for transparency - M1: budget TBD, time: ASAP/URGENT - M2-M5: - Budget: $1,500 USD provisional for all 2-5 milestones (exact TBD based on proposal) - Timeline: ~2-3 weeks Please include in your proposal: 1. Relevant experience with similar analytics setups 2. Your approach to M1-M5 (brief, not a novel) 3. Any questions or scope clarifications needed