Client Data Analyst

Data Analyst – Intelligence Team

Reports to: Head of Intelligence

Location: Blend of London office (Rose Court) and home

About us

Kinetic are the UK’s #1 specialist out of home agency. We work with more of the UK’s leading brands and agencies than anyone else to influence valuable audiences on the move. We are a diverse group of passionate experts, united in our devotion to one medium.

We are entering a new era for OOH, one defined by significant growth and disruption. Technology and dynamic data are aligning with the unparalleled creativity and scale of this magical medium to help us re-imagine advertising. Innovation is changing our world to be able to shape people’s emotions and behaviour through boundless creative possibilities and smart data driven insights, increasingly in real time. Yet OOH remains the only universally accessible medium that offers a shared experience for people and the most amazing creative canvas for brands.

We want to be the agency that is leading the industry through this change. To deliver outcomes that are human, inspiring, and effective. Using intelligence, creativity, and technology to fuel both brand- and sales-driven campaigns.

Role Summary 

The transformation towards digital OOH demands new processes and tools to improve our implementation, optimization, and reporting capabilities.

This role will receive, diarise, and fulfil incoming data requests from comms planners, in collaboration with the wider Research and Intelligence team. The team is data- and technology-driven, delivering research on OOH trends and reporting the effects of OOH campaigns.

The role will help develop and promote Journeys, Kinetic’s behavioural audience planning product.  The data analyst will be responsible for some data updates and troubleshooting. The role will develop and deliver training on usage of the product, and assist Account teams with the planning, reporting, and optimisation of Journeys campaigns as required.

The analyst will also be responsible for transforming data to respond appropriately to channel data requests for media mix modelling or econometrics reporting purposes.

Main tasks and responsibilities:

• Work alongside the Data and Account teams to integrate and deploy the “Journeys” planning tool.
• Creation of BI tools to help streamline company pain points.
• Assist with and produce Econometrics reporting data to agencies as required.
• Provide meta-analysis to define best practice, and performance analytics.

Specific responsibilities:

• Creating Journeys brief responses, in support of Journeys platform superusers, providing insights and analysis for accounts team to present back to clients 
• Working with planning teams to identify requirements, track implementation and roll out
• Training account planners on Journeys platform and other self-service data products
• Learn, identify and set best practice for optimising OOH campaigns
• Generate and analyse advanced daily/weekly/monthly reports and highlight insights
• Optimise against the performance of these goals
• Troubleshooting of tracking and set-up issues within the Journeys platform
• Generation of OOH inputs for econometric reporting for agency contacts
• Maintenance and support of internal BI tools and products

Requirements:

• Collaborate effectively with technical and non-technical people inside and outside the organisation.
• Ability to make complex data analysis clearly understood and useful.
• Must understand how to prepare and format data for use in business intelligence dashboards.
• Experience creating and maintaining business intelligence dashboards is required. Experience with Microsoft Power BI Desktop is desired but experience in Tableau, Google Data Studio, etc. would also be valuable.

Nice to have:

• Experience writing complex database queries in SQL, including use of geospatial functions, is highly desired. We use Microsoft SQL Server, PostgreSQL and Snowflake, but experience with any flavour of SQL would be valuable.
• Familiarity with Microsoft Office, especially Excel, Outlook, and PowerPoint, will be an advantage.
• Some experience with scripting in Python, Node/JavaScript, or VBA is desirable.
• A passion and curiosity in the data and technology space, and an interest in out-of-home advertising, with a desire for continuous learning and innovation.

Key performance indicators of success for this role are:

• Grow data expertise and use within the organisation
• Evangelise our data products and be a go-to resource for our planners
• Respond to requests in an effective and efficient way aligned with business priorities

Key supporters for this role and key stakeholders: Planning and Journeys Superuser teams.

 #LI-ED1