BI Developer

Data & Analytics London, England


Description

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.

Key Responsibilities

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
Essential Requirements
 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

Desirable Skills
 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#

Company Overview

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:

Website: http://www.mindshareworld.com/uk

Twitter: https://twitter.com/#!/mindshare_uk

Linkedin: http://www.linkedin.com/company/mindshare

#LI-NG1
 

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.