Principal Analyst (MMM)
ExternalPrepare for this interview
EliteAI-generated questions, company research, and talking points tailored to this role
About the role
You will support senior colleagues in achieving the efficient delivery of client projects. Typical responsibilities and duties are the collection and preparation of data, contributing to the finalisation of models, writing results and implications and SFX creation. Your role as Principal Analyst is to take responsibility for and oversee other analysts. You will also be expected support the development of analysts through the Training Academy, Knowledge Shares and feedback. Principal Analysts should develop relationships with their counterparts client side and be able to communicate Gain Theory approaches and brand beliefs.
Responsibilities
- Working with data: Data extraction and manipulation, data analysis and validation, batch files, programming
- Undertake data extraction, manipulation, and data analysis to understand the marketplace and client context relevant to each project.
- Analyse all datasets to ensure that each KPI is understood and can be explained back to the team.
- Ensure that all tables, charts and other information produced by you, or others has been checked for accuracy and formatted to GT standards before passing on to senior project team.
- Be responsible for data collection including preparation and sending of data requests, chasing outstanding data and querying data with clients and agencies.
- Ensure that ROVA input files are structured to meet requirements of project (e.g. order and number of variables, exclusion of unnecessary variables)
- Ensure that all outputs are checked for accuracy by analysts; record any checks made.
- Proficiency in using data extraction tools (i.e. Advantage, AdDynamix, Sysomos, Google Trends, Google Analytics, Double Click) and able to teach others in their use. Be aware of alternatives and the PROs / CONs of the tool.
- Proficiency in using Excel/SQL/Python/Pandas/Analytics Workbench to process, transform, create variables and build models. Be or be working towards expert knowledge in a selection of these tools / approaches.
- Building Models: Model building and validation, sales effects calculations, ROIs, media optimisation
- Oversee the building of comprehensive base models according to the project specification, incorporating all drivers of KPIs, providing rationale for variables entered, understanding coefficients and SFX.
- Taking base models, oversee or build in additional improvements and progress the model towards finalization.
- Calculate sales effects throughout the project to check results and assess their correctness, i.e. does media contribution make sense? Report to project team on preliminary findings and observations
- Create sales effect/ ROI workbook, ensure it is easy to follow and all links are correct.
- Create response curves and optimisation spreadsheets or alternatively use available tools for budget allocation. Run scenarios required to answer client objectives.
- Validate models, identify areas of weakness, suggest and test possible improvements and ensure robustness and validity.
- . Creation of presentations: Content creation, summary of findings, accuracy checks
- Create content as specified by project lead, taking responsibility for entire sections rather than focusing on just factual and data slides.
- Assist in the creation of all areas of the deck as directed.
- Ensure that all content is checked for accuracy and that it is correctly labelled, complete and ready for delivery to client.
- Summarise and comment on findings, add consultancy input rather than on factual statements.
- Be able to explain and justify any potential changes that need to be made to provide sensible results. Especially important when reviewing others' outputs that you are overseeing.
- Client Relationship Management & Interaction: Client contact and interaction, delivery of results to the client
- Answer specific data questions that may arise in external meetings as the lead analyst; act as a specialist closest to the data.
- Be prepared to lead calls with clients (data calls, weekly calls etc.).
- Be involved in the delivery of results to the client and present sections of presentations during meetings.
- Take charge of day-to-day client contact using email and telephone where appropriate.
- Interpretation of results: Result interpretation and rationale, recommendations, translation of results from analytics into actionable recommendations
- Provide input into the results and implications and comment on the interpretation for future strategies.
- Interpret results and underst
Additional Information
About WPP 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 .
Your Match
How well this role fits your profile.
Company Intel
What employees say
Worked at gaintheory? Share your experience