We are looking for a BI Developer to help evolve Mindshare’s approach to client reporting. We plan advertising communications for our clients, covering traditional channels such as TV and radio, and data-rich digital channels such as PPC and Social. Together with our clients we want to understand how we are getting on – we want to know what is working and what is not. We need to adapt quickly, making sure we do more of the good stuff. This means we need timely and meaningful information at our finger tips.
Our reporting needs to link different audiences and media channels across the whole marketing communications journey, from first exposure to that final sale. This means combining multiple data sources, generating meaningful insight and adding value through creative visualisation. Once that’s done we need to scale and automate the whole operation.
We are looking for someone who can not only do the data plumbing but can also work with internal and external clients to make sense of data. This is a pivotal role in a business that puts data and insight at its heart.
The BI Developer will work within a dedicated team data engineers and visualisation specialists, also liaising with key internal, client and 3rd party contacts. Duties include:
Consulting with internal teams and clients, collecting and interpreting reporting needs
Planning, designing and deploying reporting and visualisation solutions
Developing and implementing ETL solutions
Developing and implementing database solutions
Maintaining data infrastructure, including database performance optimisation
Assisting with the debugging, monitoring and troubleshooting of all solutions
Developing and implementing best practices and guidelines for data management
Liaising with GroupM partners on group-wide reporting solutions
Maintaining industry knowledge and vendor relationships to ensure Mindshare leads in this field
Developing and maintaining reporting documentation and code repositories
Experience and Knowledge
Advanced understanding of data architecture and IT infrastructure
Advanced SQL skills, with the ability to write complex queries to mine and transform data
Understanding of the Microsoft SQL Server and Azure technology stacks
Experienced user of ETL tools, such as Microsoft SSIS and or Azure Data Factory
Experience with at least one major data visualisation platform (Tableau or PowerBI preferable)
Experience designing and developing approaches to maintaining data quality
Self-starter and motivator with the ability to work autonomously in a fast-paced environment
The ability to quickly learn and understand new business models and environments
The ability to achieve high quality results by paying attention to detail
A natural desire to share knowledge and teach others
An understanding of the digital media landscape, it’s typical data sources and reporting challenges
Database performance optimisation skills
Development skills in common scripting/automation technologies (e.g. Python or Visual Basic)
Development skills in C#
Mindshare is a media agency within the WPP network, the world’s leading communications services group. We work with more than 100 of the UK’s most prestigious brands including Unilever, Marks & Spencer, 3 Mobile, Ford, Nike, Chanel and Facebook.
We win lots of awards for our innovative work - Cannes Gold Lions, IPA Effectiveness and MediaGuardian Innovation to name a few. We are the home to Huddle, an industry-famous festival of thinking where we play host to a jam-packed agenda of discussions about the future of media with a mix of leading media figures.
Our spectacular office is located in Central St Giles in the heart of London, close to Soho, Covent Garden and Oxford Street. And it’s not all work here - Mindshare holds social events for everyone including ski trips, monthly free bar get-togethers and all the usual seasonal parties.
Further information can be found on:
GroupM is an equal opportunity employer. We view everyone as an individual and we understand that inclusion is more than just diversity – it’s about belonging. We celebrate the fact that everyone is unique and that’s what makes us so good at what we do. We pride ourselves on being a company that embraces difference and truly represents the global clients we work with.
If you need assistance or an accommodation due to a disability, please email us via TalentTeam.UK@GroupM.com.