Marketing Data Platform on BigQuery

An enterprise marketing data platform on Google BigQuery.

Problem and purpose

Data-driven marketing at enterprise scale needs one governed, secure data layer with fast analytical queries and controlled Google Cloud cost.

My role and responsibility

I built the data infrastructure on BigQuery: the governance and security policies, and the query and cost optimisation.

Architecture and key decisions

• Data governance and security policies with access-controlled data
• Analytical queries that return in under a second
• Partitioning and clustering to lower Google Cloud costs
• A governed data layer that AI and analytics features can depend on

Technologies

Google BigQuery, Google Cloud.