Post a new job
Job Summary: β€’ Determine requirements for reporting use cases via stakeholder interviews and review of existing dashboards β€’ Define ingestion and automation approach for Adobe Analytics data into GCP β€’ Automate loading of data from Google Cloud Storage into Big Query β€’ Write queries in Google BigQuery to stitch, aggregate and filter data from Google Search Ads 360, Display and Video 360 and Adobe Analytics β€’ Visualize data in Data Studio from BigQuery tables. Project Overview: Consultant will build a marketing data warehouse in Google Cloud for Comcast to optimize media spend and marketing interactions across channels. This work will be conducted across the three work streams outlined below at Comcast’s direction: 1) Strategy & Roadmap β€’ Refine, recommend and prioritize MDW measurement and activation use cases β€’ Audit ingestion of data sources already ingested β€’ Define holistic platform architecture, automation, and ID stitching roadmap, including approach for match-back use case 2... Data Source Ingestion & Automation β€’ Define ingestion automation approach β€’ Ingest data sources into GCP β€’ Validate against data sources for accuracy β€’ Set up recurring automated ingestion 3) Report Design & Development β€’ Document report specific requirements β€’ Audit current reports β€’ Mockup dashboards β€’ Define data aggregation logic and build queries β€’ Build dashboards in Data Studio β€’ Validate and review dashboards
Loading...