BI Developer

About WPP

WPP is the creative transformation company. We use the power of creativity to build better futures for our people, planet, clients, and communities. Working at WPP means being part of a global network of more than 100,000 talented people dedicated to doing extraordinary work for our clients. We operate in over 100 countries, with corporate headquarters in New York, London and Singapore. WPP is a world leader in marketing services, with deep AI, data and technology capabilities, global presence and unrivalled creative talent. Our clients include many of the biggest companies and advertisers in the world, including approximately 300 of the Fortune Global 500. Our people are the key to our success. We’re committed to fostering a culture of creativity, belonging and continuous learning, attracting and developing the brightest talent, and providing exciting career opportunities that help our people grow.

Job Summary

We are seeking a highly skilled and experienced BI Developer to join our dynamic data and analytics team. This role is crucial for empowering our business stakeholders with reliable, insightful, and user-friendly data solutions. You will be responsible for designing, developing, and maintaining our business intelligence infrastructure, with a strong emphasis on leveraging Google Analytics 4 (GA4) data within Google BigQuery, and building sophisticated dashboards and reports in Looker.

Key Responsibilities

• Looker Development & Administration: Design, develop, and maintain complex Looker models (LookML) to create robust and scalable data views for various business domains.
• Build, optimize, and manage interactive Looker dashboards, Explores, and Looks that provide actionable insights to stakeholders across marketing, product, finance, and operations.
• Administer Looker instances, manage user access, and ensure data security and governance within the platform.
• Promote Looker best practices, conduct training sessions, and serve as a Looker subject matter expert for the organization.
• Data Extraction & Transformation (BigQuery & GA4): Write highly optimized and complex SQL queries to extract, transform, and load (ETL/ELT) data from Google BigQuery, with a specific focus on raw Google Analytics 4 (GA4) event data.
• Understand the GA4 data schema in BigQuery and effectively manipulate this data to create meaningful metrics and dimensions for reporting.
• Collaborate with Data Engineers to ensure data quality, availability, and optimal performance of data pipelines feeding into BigQuery.
• Develop and maintain data transformation logic within BigQuery or other tools to prepare data for consumption in Looker.

Requirements

• Deep expertise in Looker development.
• Strong SQL skills for data extraction and transformation from BigQuery.
• Solid understanding of digital analytics principles.