Business Intelligence Developer

Why we're hiring:

WPP is the world's leading creative transformation company. Our Enterprise Data Group (EDG) sits at the heart of WPP's global intelligence infrastructure, empowering HQ and the wider WPP network with the data insights needed to drive strategic decision-making at scale.

As we continue to invest in our data capabilities, we are looking for a talented and passionate BI Developer to join our growing team and help shape the future of business intelligence across one of the world's most iconic organisations.

Reporting directly to the Head of Data Experience, WPP Enterprise Data Group, this is a high-impact role where you will design, develop, and maintain world-class business intelligence reports and dashboards used by senior stakeholders across WPP's global network.

You will be a key bridge between complex data ecosystems and the people who rely on clear, actionable insights to make critical business decisions. This is not just a technical role — it's an opportunity to champion data literacy, elevate visual storytelling, and drive meaningful change through the power of data.

What you'll be doing:

• Translate complex business requirements into intuitive, visually compelling BI dashboards and reports that deliver actionable insights
• Create wireframes, prototypes, and proof-of-concepts aligned with stakeholder requirements, ensuring adherence to best practices, branding guidelines, and accessibility standards.
• Develop custom visuals where native BI functionality does not meet business needs
• Maintain quality control standards across your own and the team’s projects, ensuring deliverables meet benchmarks before being shared with stakeholders.
• Enable the successful introduction of AI/LLM tools by preparing and structuring data effectively, demonstrating a strong understanding of the overall data model, and providing clear guidance so end users can interact with it confidently.

• Design robust, scalable data models that underpin reliable and performant reporting solutions
• Partner with the Engineering team to identify, ingest, and validate data sources required to meet reporting requirements
• Apply strong knowledge of ETL processes, data warehousing, and data modelling to ensure data integrity and consistency
• Leverage Power Query, Power Pivot, DAX, and the broader Power Platform to build efficient, maintainable solutions

• Implement and maintain row-level security (RLS) and application-layer security models to ensure appropriate data access controls
• Manage and monitor scheduled data refreshes, proactively resolving issues to ensure dashboards always reflect the latest available data
• Maintain and continuously improve the BI infrastructure, ensuring stability, performance, and scalability
• Apply and enforce access and security best practices across all solutions

• Integrate BI reports into third-party applications using embedded analytics, BI Service (SaaS), and APIs
• Lead or assist in migrating legacy BI platforms to current ones, ensuring smooth transitions with minimal disruption.
• Continuously monitor the BI roadmap and broader landscape to identify opportunities to adopt new features, tools, and best practices

• Engage proactively with business stakeholders across WPP to gather, validate, and refine requirements, facilitating workshops and engagement sessions as needed
• Assess feasibility and suggest appropriate or alternative solutions as needed.
• Deliver effective end-user training on dashboard usage, data interpretation, and data-driven decision-making
• Champion data and visual analytics literacy across the department, educating both technical and non-technical team members
• Collect ongoing feedback on dashboard effectiveness and drive a culture of continuous improvement

• Work as an integral part of a cross-functional team alongside UX Architects, Business Owners, Product Managers, Content Strategists, and Engineering Teams
• Collaborate with the team to achieve optimal outcomes and provide support whenever needed.
• Translate complex datasets into clear, compelling narratives tailored for audiences at all levels, including C-suite stakeholders
• Maintain a strategic perspective while managing multiple concurrent deliverables and priorities

What you'll need:

2 – 4 years of hands-on development experience in PowerBI, Tableau or any other BI tools

Proficient in writing complex DAX queries and expressions

Strong SQL skills for data extraction, transformation, and analysis

Solid understanding of the Azure data ecosystem (Azure SQL, Synapse Data Factory, etc.)

Understanding of the Databricks platform UI, and skills in designing interactive BI dashboards

Pinpoint common stakeholder questions, collect relevant data, and provide straightforward instructions for AI readiness.

Expertise across Power Query, Power Pivot, Power Automate, Power View, and the broader Power Platform

Ability to implement RLS and understand application security layer models in P

Experience with BI Report Server and back-end infrastructure management

Experience integrating BI via embedded analytics or REST APIs

Strong understanding of data warehousing, data modelling, and ETL principles

Proven experience migrating from other BI platforms (e.g., Tableau, Qlik) to Power BI

Experience producing advanced static visualisations and infographic products for business intelligence

Proficiency in design tools such as Adobe XD or Adobe Creative Cloud

• Deep expertise in Power BI custom visual development
• Strong grasp of design principles for visual analytics and data storytelling
• Proficient in Microsoft Office, with advanced Excel skill
• Familiarity with other BI tools (e.g., Tableau) is advantageous
• Experience in SQL and Databricks

• Good verbal and written communication skills, with the ability to convey complex data simply and effectively
• Comfortable presenting to and engaging with senior and executive-level stakeholders
• Strong organisational skills with the ability to manage multiple workstreams simultaneously
• Analytical mindset with outstanding attention to detail — understanding that precision at every step prevents downstream issues
• Ability to balance competing stakeholder opinions and navigate ambiguity to deliver the best outcomes for the project
• Demonstrates steady performance under stress and reliably delivers results within demanding timeframes.

• A natural curiosity and passion for data, technology, and continuous learning
• Demonstrate a positive attitude toward work while taking ownership and accountability for delivering results and meeting deadlines
• A collaborative team player who thrives in a cross-functional, fast-paced environment
• Strategic thinker who can zoom out to see the bigger picture while executing at the detail level
• Self-motivated and proactive — always looking for ways to improve processes and solutions

Who you are: