BI Developer - #2204388

Havas Media UK


Date: 6 hours ago
City: Leeds
Contract type: Full time
Havas Media UK
Agency

Havas Media

Job Description

BI Developer

Reporting to: BI & Technology Director

Location: Leeds

Role Summary

Job Purpose

The BI Developer is responsible for developing, testing and supporting Business Intelligence solutions that help the organisation and its clients make better use of data.

This is not purely a technical delivery role. A key part of the position is building strong relationships across the agency, understanding how different marketing and media teams operate, and getting to the heart of what stakeholders and clients are trying to achieve. Rather than simply taking a set of requirements and building against them, you’ll be encouraged to ask questions, understand the “why” behind a requirement and help shape the right solution. You should be curious about why a metric matters, how it will be used and what decisions the insight needs to support. You’ll work across the BI lifecycle, including data ingestion, transformation, modelling, visualisation and reporting, while identifying opportunities to improve the organisation’s use of data, automation and AI. As AI continues to change how BI solutions are developed, we’re looking for someone who combines strong technical and data capability with curiosity, sound judgement, attention to detail and the ability to build meaningful relationships across the business.

Key Responsibilities

BI Development & Implementation

  • Develop, test, deploy and maintain BI and analytics solutions in line with the defined BI architecture and standards.
  • Build and maintain data pipelines for the collection, transformation and modelling of internal, client and third-party data, following agreed patterns.
  • Build data models that support reporting, dashboarding and analytical/AI use cases, in line with agreed modelling standards.
  • Create and maintain dashboards and reports in Microsoft Power BI.
  • Develop and optimise SQL queries, data transformation processes and analytical datasets.
  • Work primarily with Google Cloud Platform (GCP) and BigQuery as the cloud data and analytical platform.
  • Use Dataform to develop, test and manage SQL-based data transformation workflows.
  • Use Funnel.io and other appropriate technologies to ingest advertising, marketing and media data.
  • Implement solutions that are robust, extensible, scalable and supportable, working closely with the BI & Technology Director.
  • Integrate applications and data sources through APIs and web services.
  • Apply defined version control, testing, documentation and deployment standards using Git and Azure DevOps.

Stakeholder Partnership & Commercial Understanding

  • Build strong relationships with business stakeholders, account teams, activation teams and clients to understand their objectives, challenges and reporting needs.
  • Go beyond the initial brief by asking the right questions, understanding the “why” behind a requirement and translating business and client needs into meaningful technical solutions.
  • Develop a strong understanding of how our media and marketing teams operate, including the commercial context behind the data and metrics they use.
  • Work directly with stakeholders and clients to understand how reporting is used, what decisions it needs to support and what success looks like.
  • Use your BI and data expertise to challenge requirements constructively and suggest better approaches where appropriate.
  • Work with department leads to apply consistent approaches to data collection, tagging, categorisation and reporting.
  • Manage and prioritise BI development requirements in conjunction with the wider Technology and BI team.
  • Identify opportunities to consolidate solutions and reduce duplicated data, reporting and development effort.
  • Clearly communicate technical concepts, solutions and limitations to both technical and non-technical audiences.
  • Take ownership of the outcome of your work, not simply the technical delivery, ensuring solutions provide clear value to the teams and clients using them.

Development Standards & Delivery

  • Work closely with the BI & Technology Director to implement solutions in line with defined BI development standards and best practices.
  • Maintain high standards for code quality, documentation, testing and maintainability.
  • Participate in peer code reviews and act on review feedback.
  • Use Git for source control and Azure DevOps for development planning and delivery.
  • Ensure development work and progress are appropriately captured and managed through Azure DevOps.
  • Follow agreed testing and deployment processes for data pipelines, models and reporting solutions.
  • Monitor and optimise BI solutions for performance, reliability and cost.

Quality & Ownership

  • Take personal ownership of the accuracy and reliability of the data, dashboards and reporting you deliver.
  • Approach every output with a strong quality mindset, recognising that clients and teams rely on BI solutions to make important commercial decisions.
  • Validate outputs thoroughly and investigate anomalies rather than assuming that technically successful development means the result is correct.
  • Care about the end result and user experience, ensuring each solution answers the question it was designed to solve.
  • Maintain quality even when balancing multiple client requirements and competing priorities.

AI & Automation

  • Explore how tools such as Microsoft Copilot and Claude can accelerate development, prototyping and analysis, freeing up more time for problem-solving, stakeholder engagement and higher-value strategic work.
  • Identify opportunities to use automation and AI to improve BI development, analytics and wider business processes.
  • Use AI-assisted development appropriately to accelerate development, prototyping, documentation, analysis and troubleshooting.
  • Work with the wider Technology team to evaluate emerging AI, data and automation technologies.
  • Ensure AI-enabled solutions follow organisational security, governance and data-protection requirements.

Collaboration & Knowledge Sharing

  • Work closely with the BI & Technology Director, raising technical questions, risks and improvement ideas for review.
  • Proactively build relationships across Havas, spending time with different media, marketing, activation and client teams to understand their work, challenges and priorities, and bring that knowledge into BI solutions.
  • Be a visible and approachable member of the agency, sharing ideas, learning from other disciplines and helping teams understand how data and BI can support their work.
  • Actively seek opportunities to learn from colleagues outside the BI team, building a broader understanding of the agency and its clients.
  • Collaborate with other BI developers through peer reviews, pairing and problem solving.
  • Share BI knowledge and apply agreed standards and best practices consistently across the team.
  • Support training and knowledge-sharing sessions for the wider organisation where appropriate.
  • Keep up to date with emerging technologies and suggest potential applications to the BI & Technology Director.

Essential

Technical Skills & Experience

  • Commercial experience in a Business Intelligence, Data Engineering or Analytics Engineering role.
  • Strong SQL skills.
  • Experience developing dashboards and analytical solutions using Microsoft Power BI.
  • Experience working with Google BigQuery and Google Cloud Platform.
  • Good understanding of data warehousing, modelling and ETL/ELT concepts.
  • Experience building and maintaining data pipelines and transformation workflows.
  • Experience with Dataform, dbt or comparable SQL transformation frameworks.
  • Experience working with Git and modern source-control practices.
  • Experience using Azure DevOps or equivalent development lifecycle tooling.
  • Experience building scalable, reliable and maintainable solutions in line with defined architecture and standards.
  • Good understanding of testing, deployment and development best practices.

Desirable

  • Experience with Funnel.io or similar marketing-data integration platforms.
  • Experience with Microsoft Copilot, Claude and other AI-assisted development tools.
  • Experience integrating data using REST APIs, web services and third-party data sources.
  • Experience working with advertising and marketing platforms such as Google Ads, Meta and Google Analytics.
  • Understanding of digital media data, including DSP, paid search/PPC, SEO, OOH, AV and Google Analytics.
  • Experience with Azure services and the broader Microsoft data ecosystem.
  • Experience developing reusable semantic models and governed reporting datasets.
  • Experience supporting client-facing analytics solutions.

What You’ll Bring

  • Curiosity. You want to understand why something is being built, not simply how to build it.
  • Commercial thinking. You can connect data and reporting back to the decisions stakeholders and clients need to make.
  • Relationship building. You enjoy working with people across different disciplines and getting closer to teams to understand how they operate.
  • Quality and ownership. You care about getting things right and take responsibility for the accuracy and reliability of your work.
  • Constructive challenge. You’re comfortable asking questions and suggesting a different approach where you believe there is a better solution.
  • Communication. You can explain technical concepts clearly to people who don't work in technology or data.
  • Collaboration. You enjoy sharing ideas, learning from others and contributing to a team.
  • Problem solving. You can translate complex business requirements into practical, robust technical solutions.
  • Adaptability. You’re interested in how AI and emerging technologies are changing BI and want to continually develop how you work.
  • Commercial curiosity. You’re interested in marketing, media and the wider business, and want to understand the context behind the data you work with.
  • The ability to balance multiple priorities and work effectively within an agile development environment.

Why This Role?

This is an opportunity to be much more than the person who builds the dashboard.

You’ll work closely with teams across the agency and with our clients to understand their challenges, shape solutions and help determine how data can be used to make better decisions.

As AI continues to transform the technical side of BI development, we're increasingly interested in the things technology can't replace: curiosity, judgement, commercial understanding, relationships and the ability to turn data into something genuinely useful.

You'll have the opportunity to combine strong technical BI work with exposure to different areas of media and marketing, developing a broad understanding of how data supports both our teams and our clients.

Contract Type

Permanent

Here at Havas across the group we pride ourselves on being committed to offering equal opportunities to all potential employees and have zero tolerance for discrimination. We are an equal opportunity employer and welcome applicants irrespective of age, sex, race, ethnicity, disability and other factors that have no bearing on an individual’s ability to perform their job.

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

Early Years Support

Veritas Education Recruitment Ltd,
£14 - £15 / hour
10 hours ago
Nursery Practitioner Full-Time or Part-Time Opportunities | Leeds Are you looking for a nursery where you'll feel welcomed, supported, and genuinely valued? We're currently recruiting for qualified and unqualified Nursery Practitioners to join friendly and well-established nursery settings across Leeds...
Veritas Education Recruitment Ltd

Senior Events Executive

Equals One,
£33,000 / year
1 day ago
Senior Events Executive Leeds 7 (occasional travel across Yorkshire) Salary: £33,000 per annum Full-time, Permanent Office based Monday to Thursday - home based Friday Are you an experienced, highly organised events professional looking for a new challenge with real purpose...
Equals One

Graduate Revit Technician

confidential,
£27,000 - £28,000 / year
1 day ago
Imagine a building without ventilation, heat, electricity. security, water, and gas? It wouldn’t be much use, no matter how well it was designed. This is why building services are so important: they really bring a building to life. And this...