Overview
We are seeking a Data Engineer to join a specialist Data and Tech Solutions team within a media and marketing environment. The successful candidate will be responsible for building the infrastructure that supports campaign planning, activation, and reporting, collaborating closely with stakeholders while managing multiple projects. This is a contract role requiring on-site work in Central London.
Responsibilities
- Develop data infrastructure on Google Cloud Platform (GCP), particularly using BigQuery.
- Design and optimize data models and pipelines in BigQuery.
- Deliver dashboards and reports using Looker, leveraging LookML where applicable.
- Integrate data solutions with Salesforce Marketing Cloud and/or Salesforce CRM for data synchronization and campaign automation.
- Build and maintain ETL/ELT pipelines to ensure data flow and accessibility.
- Configure and integrate APIs across various data sources efficiently.
- Manage stakeholder expectations and independently handle multiple projects.
Requirements
- Hands-on experience with Google Cloud Platform (GCP) and BigQuery in a production environment.
- Proficient in designing, building, and optimizing data models and pipelines in BigQuery.
- Experience delivering dashboards and reports using Looker, with knowledge of LookML.
- Genuine integration experience with Salesforce Marketing Cloud and/or Salesforce CRM.
- Strong skills in SQL and Python for data manipulation and analysis.
- Familiarity with ETL/ELT pipeline development and maintenance.
- Understanding of marketing and media metrics within the ad and martech landscape.