GroupM EMEA
Location
Remote | United Kingdom
Job description
Position at mSix&Partners
Business Intelligence Consultant
London
Who is mSix&Partners
mSix&Partnersis 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 continentsand 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:
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 UKfor continuous professional development of our people for 3 years in a row, and in 2022 we won the IPA CPD Platinum accreditationalongside a small group of agencies.We have won Campaign’s Best Places to Work 2022, which recognisesmSix 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 mSixers, in order to become the most important place in their careers.In 2022,we also wonDigiday’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 ConsultantWhere is the role based?
mSix and Partners in LondonWhat 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’smain data centre is Google Cloud Platform (GCP), where media performance data is extracted from media platforms into mSix’s GCP using 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.
-Work closely with client teams to scope projects and support with the completion of required statement of works, project plans and technical documentation.
-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. Professional certifications not required but desirable.
-Background in cloud computing (preferably Google Cloud Platform and BigQuery. Azure and AWS tech stacks also desirable)
-Front end data visualisation experience – Power BI, Tableau, Data Studiodesirable.
-Maths/Data/Computing or related field undergraduate degree preferrable. Marketing degrees also acceptable.
-Experience managing and project management
-Knowledge of the media landscape/common media data sources desirable
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
Job tags
Salary
