WPP is seeking a GCP Data Engineer to build, maintain, and optimize their data infrastructure to enable robust analytics and reporting capabilities, ensuring data quality, accessibility, and performance for critical business insights.
Requirements
- Proven experience as a Data Engineer, with a strong focus on Google Cloud Platform (GCP).
- Expertise in BigQuery for data warehousing and optimization.
- Experience with Google Cloud Storage (GCS) for data lake and backup solutions.
- Proficiency in SQL and Python for data engineering tasks.
- Familiarity with data ingestion techniques, including connectors and custom pipelines.
- Understanding of data partitioning, schema management, and data retention policies.
- Knowledge of data governance, security (IAM), and quality best practices.
Responsibilities
- Design, develop, and maintain scalable data pipelines for ingesting, transforming, and loading data from various sources (e.g., Google Analytics, transactional databases, APIs, flat files) into our BigQuery data warehouse.
- Work with diverse data formats including JSON, CSV, Avro, and Parquet, ensuring efficient data handling and storage.
- Implement and manage data storage solutions within Google Cloud Storage (GCS) for raw data and backups, and optimize BigQuery for performance and cost-efficiency, leveraging partitioning strategies.
- Develop and orchestrate ETL/ELT processes, including managed daily batch ingestion, to support data analytics and reporting needs.
- Collaborate with data analysts and product teams to understand data requirements and translate them into technical solutions.
- Ensure data quality, governance, and security by implementing IAM roles, adhering to logging/auditing standards, and managing schema.
- Utilize SQL and Python for data manipulation and pipeline development, with an understanding of Bash scripting.
Other
- Ability to work collaboratively within a global team and agile environment, utilizing tools like Jira and Confluence.
- You're open: We are inclusive and collaborative; we encourage the free exchange of ideas; we respect and celebrate diverse views. We are open-minded: to new ideas, new partnerships, new ways of working.
- You're optimistic: We believe in the power of creativity, technology and talent to create brighter futures or our people, our clients and our communities. We approach all that we do with conviction: to try the new and to seek the unexpected.
- You're extraordinary: we are stronger together: through collaboration we achieve the amazing. We are creative leaders and pioneers of our industry; we provide extraordinary every day.
- Teams in the office around four days a week.
