Assist in ingest and structure raw web traffic data (e.g., from server logs, APIs, or tools like Quantum Metric / Google Analytics) into scalable datasets in BigQuery, designing schemas for efficient querying and in-depth analysis of individual user sessions, logged-in behaviors, conversion funnels, and personalization opportunities. Proficiency in digital marketing metrics, ROI analysis, and tools for web analytics (e.g., Google Analytics, Adobe Analytics), visualization (e.g., Power BI, Looker Studio), and personalization (e.g., marketing automation platforms like Microsoft Dynamics 365 or HubSpot).