Business Intelligence Consultant

Business Intelligence Consultant 
  

London           

Who is mSix& Partners           

mSix&Partners is one of the fastest growing media network in the world . We have marked the chapters of our expansion with new client relationships: TalkTalk helped us open our doors in the UK, Toyota enabled us to grow into EMEA and EA has strengthened our presence and offering in APAC and North America. Today over 50 offices and spanning 5 continents and this role of Business Intelligence Consultant  is key to our continued growth and success           

We take our clients and people Further Faster.           

As a joint venture between independent agency network The &Partnership and GroupM, backed by   WPP , we offer our clients the best of both worlds. Because of this unique structure, we create new operating models that integrate agency functions and often embed our people into our clients’ marketing teams. Our ability to come together with our clients, regardless of whether co-located or working remotely, has proven critical to our success.           

The way we behave - Honest, Energetic and Pioneering :           

• Honest: we build trusted relationships through openness, focus & clarity
• Energetic: we meet people with warmth & positivity. We say ‘yes, and not ‘yes, but.’
• Pioneering: we drive forwards, looking for new technology, new ideas & new sources of growth. We are driven to look for the next innovation, to meet our clients’ challenges

We are known for delivering great award-winning work for our clients. We have continued to win industry accolades throughout the last year whilst also celebrating our people’s achievements who have also seen individual industry recognition.    

We have been awarded the IPA CPD Gold accreditation in the UK for continuous professional development of our people for 3 years in a row , and in 2022 we won the IPA CPD Platinum accreditation alongside a small group of agencies. We have won Campaign’s Best Places to Work 2022, which recognise s mSix as one the best employers in our industry, showing our commitment to our culture of learning and our focus on the professional development of all m Six ers , in order to become the most important place in their careers. In 2022, we also won Digiday’s Best Workplace in Young People’s Careers.           

Our Diversity, Equity and Inclusion commitment:           

We are committed to being a diverse, equitable and inclusive agency with the aim to build and retain teams that represent the communities we operate in. Our Global employee-run DEI group, The Collective , are pioneers in delivering and maintaining accountability of these commitments.           

We were the first media agency in the UK to partner with Ambitious about Autism and launch an internship programme designed to actively champion neurodiversity and unlock the potential of young autistic adults. Now in its fourth year, our commitment continues, expanding our already successful internship programme and calling the industry to open their doors and minds to young autistic talent.     

Further to this commitment to pioneering diversity and equality in our business, we welcome people of all backgrounds into our agency. We want our people to bring with them diverse attitudes, opinions and beliefs into a culture where they are treated with respect, can be comfortable being their authentic self and feel like they belong. We are therefore keen to encourage applications from people from all walks of life and we want you to be at your best throughout the recruitment process. Please reach out to us to discuss any specific adjustments, or how we can help you throughout the recruitment process.           

What is the role?           

Business Intelligence Consultant

Where is the role based?           

m Six and Partners in London

What does the Data and Tech team do?

This role is part of the Technology team. This team is responsible for all Adtech and Martech projects internally and for clients. The team designs, builds and maintains data solutions across multiple mSix clients. MSix’s main data centre is Google Cloud Platform (GCP), where media performance data is extracted from media platforms into mSix’s GCP usin g in-house python APIs. This data is then transformed in Big Query using SQL, where it is then used to power multiple reporting solutions, including Power BI, Tableau and Data Studio dashboards.           

What will be your responsibilities?           

-           Lead a data executive to develop and maintain cloud ETL processes designed to provide a reporting infrastructure for various  mSix clients. This involves transforming data in Big Query using SQL and creating bespoke dashboards in multiple data visualisation tools (e.g. Power BI, Tableau, Looker)           

-           Support with the development of in-house Marketing python APIs for media performance and web analytics data.           

-                     

-           Identify, recommend, and implement data improvement opportunities and provide technical and troubleshooting support to the agency.           

-           Provide advice on reporting capabilities by completing API, naming convention and data audits.             

Who are you?           

-   Proven experience in business intelligence and/or data engineering using SQL and python           

-           B ackground in cloud computing ( preferably Google Cloud Platform and BigQuery . Azure and AW S tech stacks also desirable)           

-     Front end data visualisation experience – Power BI , Tableau, Data Studio desirable .           

-           Maths/Data/ Computing or related field undergraduate degree preferrable . Marketing degrees also acceptabl e.           

-           Experience managing and project management           

-      Knowledge of the media landscape /common media data sources d esirabl e             

How will success in this role be measured?           

·           Delivery of all projects to time and in full           

·           Maintain cloud platforms with no downtime           

·           Build success relationships with internal teams & clients