Data Analyst (6 months Internship)

Data Analyst - Internship  

About Gain Theory 
 
Gain Theory is part of WPP, a creative transformation company that uses the power of creativity to build better futures for its people, planet, clients, and communities. 
 
Gain Theory is a global marketing effectiveness consultancy, that uses data and analytics to deliver successful business outcomes for clients. Our vision is to inspire marketing excellence by helping marketers focus on the right data, not ‘big data’, and asking and answering the questions that drive business value. We pair consultancy and technology to foster a data-informed culture that helps to drive sustainable business growth.  

The Role: What will I do? 

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. 

Qualifications 

• 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 

Nice to have skillsets:  

• 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 

Values and Behaviours  
 
Joining Gain Theory means joining a group of people who live, breathe and behave by our values: 

•  Be Curious: continuously asking, understanding, learning, and developing.  

•  Be Positive: approaching everything we do with a positive mindset and making positive impact on each other.  

•  Act with Consideration: seeing things from someone else’s perspective; respecting and embracing diverse thinking.  

•  Make it Better: continuous improvement and stretching our abilities, being honest with ourselves and each other.  

Gain Theory is committed to actively building a diverse, equitable and inclusive workplace where everyone feels welcomed, valued and heard, and is treated with dignity and respect. As leaders and creative partners across industries, it is our responsibility to cultivate an environment reflective of our greatest asset, our people. We believe that this commitment inspires growth and delivers equitable outcomes for everyone as well as the clients and communities we serve. 
 

WPP (Gain Theory) is an equal opportunity employer and considers applicants for all positions without discrimination or regard to 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. 

Gain Theory is a WPP-owned consultancy. For more information, please visit please visit our website and follow Gain Theory on our social channels via LinkedIn and Twitter.

Note: We rely on legitimate interest as a legal basis for processing personal information under the GDPR for purposes of recruitment and applications for employment

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.