Data Analyst - Internship (6 months)

WPP is the trusted growth partner for the world’s leading brands. We unite cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and expert strategic counsel in a single company – powered by exceptional talent and our agentic marketing platform, WPP Open, to help our clients navigate change, capture opportunity and deliver transformational growth. For more information, visit WPP.com.

As a Data Analyst, you will be part of the Gain Theory Data Practice and will be embedded in one of Gain Theory’s client-based squads.  Working with your manager, you will be working on some of the top brands in the world and be hands on with data ranging from media, client specific, Gain Theory specific, sales, and more.  You will work as part of a team to process and organize data in preparation for modeling.  You will be challenged and have the opportunity to help innovate and automate.

The Data Analyst is expected to make use of data processing techniques including SQL and ETL to handle the data. They will also utilize our internal data automation tools to ensure data pipelines, which clean and transform data, are executed effectively. This person will also run robust data QA processes.  The quality of our data is the lifeblood of our work.  Additionally, the Data Analyst will work with their manager on coordinating client and agency contacts around the continued flow of data from relevant data sources. The role will also interact with the wider data community within Gain Theory, especially with members of the Data Centre or Excellence (DCOE) to share best practice, and both provide and receive support.

Our teams bring together cutting-edge data engineering, advanced analytics, unified measurement products and enterprise scalable engineering to build products that will shape the next decade of faster, smarter, data-informed decision-making. We believe that consumer privacy, client confidentiality, brand growth, and user experience are essential to performance.

• Degree in Computer Science, Data Science, Data Engineering, Information Science, Business Intelligence or related quantitative field
• Familiar with standard data processing tools/concepts (e.g. SQL, NoSQL ETL)
• Knowledge of QA processes
• Required skillsets: SQL, Excel & ETL

• Snowflake, Python, GIT, Cloud Compute/Storage (Azure or AWS)
• Experience with the advertising ecosystem (e.g. ad trafficking, Ad servers, DSPs, Media Strategy and Activation, etc.)
• Working knowledge of appropriate metrics, measurement, and reporting.
• Experience with DBT is valuable but not required
• Project management skills including planning tasks and deliverables, managing timelines and risks, and overseeing simultaneous projects
• Organized, detail-oriented, QA-focused
• Excellent written, verbal, and presentation skills
• English proficiency

When you click "Submit Application", this will send any information you add to Gain Theory. Before you do this, we think it's a good idea to read through our Recruitment Privacy Policy.  California residents should read our California Recruitment Privacy Notice which explains what we do with your personal data when you apply for a role with us, and, how you can update the information you have provided us with or how to remove it.