BI Developer

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.
Why we're hiring:
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. The ideal candidate will possess deep expertise in Looker development, strong SQL skills for data extraction and transformation from BigQuery, and a solid understanding of digital analytics principles.

What you'll be doing:

• 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.

Reporting & Analytics:

• Translate complex business requirements into technical specifications for BI solutions, reports, and dashboards.
• Perform in-depth data analysis to identify trends, patterns, and insights, particularly related to digital performance and user behavior.
• Ensure the accuracy, consistency, and reliability of all reported data.
• Provide ad-hoc data analysis and reporting support to various business units.

Stakeholder Collaboration & Communication:

• Work closely with business users to understand their data needs, gather requirements, and deliver tailored BI solutions.
• Clearly communicate complex technical concepts and data insights to non-technical audiences.
• Act as a bridge between data engineering and business teams.

Continuous Improvement:

• Stay up-to-date with the latest trends and features in Looker, BigQuery, GA4, and the broader BI landscape.
• Identify opportunities for process improvements, automation, and enhanced data capabilities.

What you'll need:
We're looking for someone who has these abilities and skills:

• Required Skills and Abilities:

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related quantitative field.

• 5-8 years of proven experience as a BI Developer, Data Analyst, or similar role with a strong focus on data visualization and reporting.
• Expert-level proficiency in Looker development, including extensive experience with LookML modeling, dashboard creation, and Looker administration.
• Strong hands-on experience extracting, transforming, and querying large datasets from Google BigQuery using advanced SQL.
• Demonstrable experience working with Google Analytics 4 (GA4) data, including understanding its event-based model and querying GA4 raw data in BigQuery.
• Proficiency in writing complex SQL queries (CTEs, window functions, aggregate functions, subqueries).
• Solid understanding of data warehousing concepts, dimensional modeling, and ETL/ELT processes.
• Excellent analytical, problem-solving, and critical thinking skills.
• Strong communication and interpersonal skills, with the ability to translate technical concepts for business users.

• Detail-oriented with a commitment to data accuracy and quality.

• Desired Skills and Abilities (Nice-to-Haves):

• Experience with other data visualization tools (e.g., Tableau, Power BI) is a plus, but Looker expertise is paramount.

• Familiarity with other GCP services (e.g., Cloud Storage, Dataflow, Cloud Functions).
• Experience with version control systems (e.g., Git/GitHub) for LookML development.
• Knowledge of Python for data manipulation or scripting.
• Experience in an e-commerce, digital marketing, or SaaS environment.
• Understanding of A/B testing methodologies and measurement.

Who you are:
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.

What we'll give you:
Passionate, inspired people
– We aim to create a culture in which people can do extraordinary work.

Scale and opportunity
– We offer the opportunity to create, influence and complete projects at a scale that is unparalleled in the industry.

Challenging and stimulating work
– Unique work and the opportunity to join a group of creative problem solvers. Are you up for the challenge?

We believe the best work happens when we're together, fostering creativity, collaboration, and connection. That's why we've adopted a hybrid approach, with teams in the office around four days a week. If you require accommodations or flexibility, please discuss this with the hiring team during the interview process.
WPP is an equal opportunity employer and considers applicants for all positions without discrimination or regard to particular characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.
Please read our Privacy Notice ) for more information on how we process the information you provide.