Senior Analyst; MMM Marketing Effectiveness & Intelligence England, United Kingdom

As a Senior Analyst at Gain Theory, you will play a critical role in delivering outstanding work for our clients. You will work closely with senior colleagues to support the efficient delivery of projects, including data collection and preparation, contributing to model finalization, writing results, and supporting the development of other analysts.

You will also be expected to develop strong relationships with clients and communicate Gain Theory's approaches and beliefs. Before joining a client delivery team, you will undergo our industry-leading Training Academy, where you will gain technical skills and knowledge of our working practices and methodologies.

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 file is 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

• Building of 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 finalisation.
• 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.

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 understand the implications of these results to the client. Be able to explain your interpretation to the team and defend your POV
• 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 Management & Interaction:
Client contact and interaction, delivery of results to the client

• Answer…