Data Analyst

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

Values and Behaviors I Demonstrate

Joining Gain Theory means joining a group of people who live, breath 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.

Why work for us? 

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. 

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.

What we pride ourselves on: 

• Growth and development
• Meaningful work
• Flexible by design
• Brilliant benefits 
• Culture with Heart 
  
  

Our exceptional and skilled team defines Gain Theory. That's why we seek individuals who strive for excellence and continually challenge us to improve.

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.

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.