Data, Tech & BI Lead

Data & Analytics London, England


Position at Mindshare

We are looking for a Data, Tech & BI Lead . The role involves developing and coordinating 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 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 Data, Tech & BI Lead will coordinate a dedicated team of data and visualisation specialists. They will laisse with key internal, client and 3rd party contacts. The role is responsible for Development, Coordination and Leadership in:
 Data systems and Reporting strategy
 Reporting tools selection and process development, with a focus on automating manual reporting tasks
 Consulting with account teams and clients, and interpreting reporting needs
 Planning, designing and development of reporting and visualisation solutions
 Developing and implementing ETL solutions
 Creating and deploying reports
 Developing and implementing relational and multidimensional database solutions
 Debugging, monitoring and troubleshooting solutions
 Developing and implementing best practices and guidelines for data management
 Liaising with GroupM on group-wide reporting solutions
 Maintaining industry knowledge and vendor relationships to ensure Mindshare leads in this field
 Developing and deploying reporting documentation and training for the broader agency team

Experience and Knowledge
Essential Skills
 Advanced understanding of Data Architecture / Data Structures
 Advanced SQL skills, ability to code and mine data
 Development skills in Microsoft .NET
 Understanding of the SQL Server technology stack, database design and programming
 End to End project development and implementation
 Able to deliver a broad range of data engagements in areas such as Data Architecture, Data Integration, Data Analytics, Data Lineage, Data Governance, Data Quality and BI Reporting
 Use of data profiling tools, ETL and data management tools (SSIS experience is a must)
 An understanding of digital media and associated data, both aggregate and event-level
 Experience of data visualisation/reporting tools
 Experience in data interpretation, ideally in a client-facing environment
 Self-starter and motivator with the ability to work in an autonomous, fast-paced environment
 The ability to quickly learn and understand new business environments
 The ability to achieve high quality results by paying attention to detail
 A proactive, “can do” attitude
 The ability to coordinate on multiple tasks/projects, work under pressure and meet agreed deadlines
 A natural desire to share knowledge and teach others
 The ability to influence groups of people to gain consensus
 Experience of building reporting around a single-customer view in cross-device, multi-screen environments
 Understanding of digital attribution approaches, including multi-touch attribution methodologies

Desirable Skills
 Understanding of data analysis techniques and how they can be applied in the marketing context
 Experience of Digital Ad Server processes and data
 Experience of Web Site analytics tools and data
 Understanding of Digital Ad Ops
 Understanding of media agency ‘booking’ systems
 Deveopment skills in common scripting/automation technologies (e.g. Python & Visual Basic)
 Understanding of the digital advertising ecosystem and the associated reporting challenges

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, Jaguar, Landrover, 3 Mobile, HSBC, 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.

Please click to apply and we will be in touch! We look forward to recieving your CV!

We are an equal opportunities employer. All GroupM agencies are equal opportunities employers and welcome applications from all suitably qualified persons regardless of their race, gender identity, disability, culture/religion/belief, sexual orientation or age.