Business Intelligence Lead - 9 Month FTC

Omnicom Media Group; Camden Town; Hybrid; GBP 70,000 - 90,000; Full time

Job summary

A leading media and advertising firm based in London seeks a Power BI Lead to develop and optimize enterprise-grade dashboards for strategic decision-making. The role involves managing complex reporting structures and collaborating with global teams. Ideal candidates have extensive experience with Power BI, strong communication skills, and a proven track record in project coordination. This position offers a hybrid working model.

Benefits

Flexible working hours

Hybrid working model

Diversity and inclusion initiatives

Qualifications

• Proven experience leading Power BI delivery in complex environments.
• Strong ability to manage multi-brand, multi-market structures.
• Experience working with offshore development teams.

Responsibilities

• Lead design and deployment of Power BI dashboards.
• Translate business requirements into actionable solutions.
• Ensure data consistency and integrity across markets.

Skills

Power BI expertise

Project coordination

Strong communication skills

Data model building

Multi-brand reporting

Tools

Power BI

AWS

Azure

BigQuery

Snowflake

Job description

Overview

You\'ll be the central point of contact for delivering all reporting across global media activation hubs, working with both onshore stakeholders and offshore development teams to ensure consistent, scalable, and accurate reporting solutions.

Responsibilities

• Lead the design, development, and deployment of Power BI dashboards used across global media activation hubs.
• Translate business requirements into clear, actionable reporting solutions that enable the client and media agency teams to make data-informed decisions.
• Ensure data consistency and reporting integrity across multiple markets, brands, and campaign types.
• Collaborate closely with offshore/global resource teams to manage development pipelines, documentation, and quality assurance.
• Own the ongoing maintenance, enhancement, and troubleshooting of dashboards once live, ensuring long-term value and stability.
• Act as a bridge between client stakeholders, internal data teams, and external development partners.
• Define and enforce reporting standards and best practices to drive excellence in dashboard design and data governance.
• Mentor junior analysts and Power BI developers, both in-house and offshore, to ensure high-quality delivery and upskilling across the team.
• Proactively identify opportunities to evolve dashboards in line with changing business needs or media strategies.

Qualifications

• Proven experience leading Power BI delivery in complex, enterprise environments - ideally within media, advertising, or digital ecosystems.
• Demonstrated ability to manage multi-brand, multi-market reporting structures at scale.
• Advanced expertise in Power BI, DAX, Power Query, and building efficient, user-friendly data models.
• Experience working with offshore/global development teams, with strong project coordination and quality assurance capabilities.
• Comfortable taking ownership of end-to-end dashboard lifecycle, including post-launch maintenance and evolution.
• Strong communication skills - able to simplify complex data for non-technical stakeholders.
• Familiarity with media KPIs (e.g. impressions, reach, frequency, CPM) is a strong advantage.
• Experience working with cloud platforms and data tools such as AWS, Azure, BigQuery, or Snowflake is desirable.

About the Company

We are looking for a Power BI Lead to join our fast-paced, data-driven environment at Annalect. This is a pivotal role supporting one of our key clients. You will lead the development and optimisation of enterprise-grade dashboards that drive strategic media decisions across multiple markets and brands. Omnicom Media Group Europe (OMG EMEA) is the media division of Omnicom Group Inc., headquartered in London with offices in Manchester and Newcastle. The Annalect EMEA team at OMG EMEA is the data, technology, and analytics division. We help CMOs and their teams harness data, technology, and advanced analytics to grow their brands. We have built a variety of innovative product and specialist service solutions for clients and agency partners. We build and maintain the Omni platform which gives agency and client teams access to these capabilities as well as the ability to integrate and combine their own data and technology with Omni. Omni has over 30,000 active users and is recognized in the industry as a leading marketing platform. We continuously innovate the platform to ensure our clients stay ahead of their competitors in data driven marketing. Our team of Annalectuals is growing rapidly and are based in over 80 countries around the globe, supported by global and regional team hubs in NY, London, Singapore, Gurgaon, Bangalore, and Hyderabad. The EMEA team is responsible for global and regional client relationships led from London, as well as the development of new data-driven marketing capabilities. They form part of our global team and collaborate closely with local market Annalect teams across EMEA as well as regional Omnicom agency partners.

Work Environment

Flexible Working: We have a hybrid working model (three days in the office, two working remotely) to balance in-person collaboration with remote flexibility. Standard hours are 9:30-17:30, with core hours 10:30-16:30. Examples of flexible start/finish times include 8:30-16:30 or 10:30-18:30. We encourage open conversations to support individual circumstances and high-need periods.

Be Your Best

We welcome candidates from diverse backgrounds and are happy to adjust the recruitment process to help you perform at your best. Please discuss any specific requirements with your dedicated Talent Team, or email [e-mail] for confidential support.

Diversity, Equity & Inclusion

At OMG, our vision is to be an agency where difference is valued and everyone thrives in a culture of equality, inclusion, and belonging. We are committed to an inclusive environment that reflects today\'s society, where everyone can bring their true selves to work, and diverse voices are valued, heard, and represented. We will process your personal data in accordance with our Recruitment Privacy Notice, available at https://omnicommediagroup.com/recruitment-privacy-notices/.