Job Description

About Us
IPG Mediabrands is the media and marketing solutions division of Interpublic Group (NYSE: IPG). Mediabrands manages approximately $40 billion in marketing investment globally on behalf of its clients and provides strategic services and solutions across its award-winning, full-service agency networks UM, Initiative and Mediahub and through its innovative marketing specialist companies Kinesso, Magna, Orion, Rapport and Mediabrands Content Studio. Mediabrands clients include many of the world's most recognisable and iconic brands from a broad portfolio of industry sectors. The company employs more than 13,000 marketing experts in more than 130 countries, representing the full diversity of humanity. For more information, please visit our website: .
Role Description
The Business Intelligence AD will be responsible for the technical delivery of projects for Nike.
This is a client-facing, technical role requiring hands-on experience of media data and infrastructure, with the expertise to understand client requirements, identify and design appropriate solutions and ensure successful delivery (with the support of the team director).
This role will be responsible for training and supporting more junior members of the BI team, successfully delegating (both up and down) to ensure timely and accurate delivery of projects, from data prep to dashboard visuals to generating insights.
An independent worker, this person will also enjoy collaborating with team members from the Analytics craft, as well as with colleagues from other markets and other IPG agency partners. We are looking for someone who 'gets' numbers and enjoys using them to solve problems; they will constantly strive to make things more effective and more efficient.
Key Responsibilities

• Communicate with stakeholders and clients to understand reporting and analytics requirements
• Challenge existing ways of working
• Design and define new solution requirements, with the BI Director
• ETL/ELT of data from various sources
• Drive efficiencies in how analytics services are delivered, through standardization and automation
• Data analysis and insights generation
• Ensure the ongoing success of projects through design and implementation of appropriate QA processes

• Manage multiple projects calmly and timely

• Contribution to the ongoing development of data systems
• Provide training and guidance to analysts in the team, and ensure high standards of work
• Line management of one to two data analysts
• Collaborate with cross-craft teams on campaign taxonomy implementation and ensure the alignment of workflows with Initiative's data privacy policy

Desired Skills & Experience

• Experience in data science, analytics or similar, preferably in a media or agency environment
• Experience with SQL and/or Python. Strong Excel skills
• Experience with APIs
• Experience in data analysis and generating insights
• Strong presentation skills
• Experience managing junior team members
• Excellent numeracy and a problem-solving mindset
• Strong communication skills to effectively manage stakeholders (clients and internal)
• Experience of managing and delivering complex projects

Desirable

• Degree in STEM or Economics or similar
• Experience of Tableau or other data visualisation tools
• Experience with Snowflake
• Experience of GCP, Azure and/or AWS

Employee Transparency
At IPG Mediabrands, we celebrate differences and believe this makes us stronger. IPG Mediabrands are an equal-opportunity employer committed to championing an inclusive culture that provides a sense of belonging for all our employees. We do not discriminate against any applicant based on age, disability, race, colour, ethnicity, national origin, gender, sexual orientation, gender identity, religion, belief, marital status or any other characteristic protected by law.
Please reach out to Ninette at , if you would like to have a confidential conversation regarding any adjustments that would ensure our recruitment process is accessible for you. Please note requesting a reasonable adjustment will not affect your application.
The Perks
We aim to provide all our people with a supportive and fun work environment where you can develop your full potential and benefit from the broad range of opportunities within the agency. When you join us, we want to make sure you feel valued - and that you are rewarded for your fantastic work. So, we also offer a range of benefits:

• Flexi-leave, with 25 days annual leave to be taken as minimum. In addition to your holiday entitlement, the office usually closes between Christmas & New Year
• Free breakfast and free lunch
• Early finish Fridays
• Core Hours (Mon-Thurs, flexible start/finish times)
• Retail discounts
• Electric vehicle salary sacrifices car scheme
• Wellbeing programme, including Headspace & flu jabs
• Interest free season ticket loan
• Paid time off for Volunteering
• Group Income Protection
• Life Assurance
• Private Medical Insurance or Health Cash Plan (dependent on level)
• Group Personal Pension Plan with matched contributions from 3-6%
• Generous Parental Leave & Pay
• Independent mortgage advice
• Financial education
• Employee Assistance Programme
• Free eye tests
• Flexible benefits including Dental, Travel insurance, Cycle to Work, Gym Discounts and many more!

Skills Required