As an 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 the Data Manager on co-ordinating with client and agency contacts around 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

• Background (1-2 years+) in Computer Science, Data Science, Data Engineering Information Science, Business Intelligence or related quantitative field
• In depth experience with all things data including ability to work with a variety of datasets from multiple sources, familiar with standard data processing tools/concepts (e.g. SQL, NoSQL ETL), and experience driving robust QA processes
• Experience with the advertising ecosystem (e.g. ad trafficking, Ad servers, DSPs, Media Strategy and Activation, etc.) and a working knowledge of appropriate metrics, measurement, and reporting
• Required skillsets: SQL, ETL, Cloud Compute/Storage (Azure or AWS)
• Nice to have skillsets: Snowflake, Python, GIT
• Experience with DBT is valuable but not required
• Has 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

WHAT WE DO

Gain Theory is a global marketing effectiveness and foresight consultancy. Our vision is to accelerate growth for ambitious brands by giving clients the confidence to make better data-informed investment decisions. High-touch consultancy powered by unique partnerships and proprietary technology are used to power our award-winning solutions.
As a WPP consultancy, Gain Theory also has access to a range of data, expertise, and tools that create a truly differentiated offering.
Gain Theory is a WPP agency (NYSE: WPP).

WHO WE ARE

We are a people-centric organisation whose culture is underpinned by 4 important values: Be Curious, Be Positive, Make it Better and Act with Consideration. We channel these values through our behaviours, in the way we work, and in the interactions we have with each other and our clients.
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.

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