BI Developer
- Hiring from
- United Kingdom
- Work type
- Hybrid
- Posted
625,816 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
Agency :
Havas MediaJob 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.
Technical Skills & Experience
Essential
- 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 :
PermanentHere 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.
About Us
Founded in 1835 by Charles-Louis Havas, Havas is one of the world’s largest global communications groups, with more than 23,000 people in over 100 countries sharing one single mission: to make a meaningful difference to brands, businesses, and people. Havas has developed a fully integrated model covering all communications activities. The teams of the three business units, Creative, Media and Health & You, work together with agility and in perfect synergy to offer clients tailor-made, meaningful, innovative and entertainment-oriented solutions that support them in their positive transformation.
Life at Havas
We take great pride in our Havas family. They bring many unique personalities, perspectives and passions to their work. Collaboration is at the core of how we operate, and Havas Villages are the homes we work in. We encourage our people to take advantage of our many opportunities to learn and grow. Through local agency training sessions, our unique global and development programs, we offer our people endless opportunities to explore.
Havas Creative Network
At Havas, we believe creativity isn’t just a description of our business, it is part of our agencies’ DNA. We bring together some of the industry’s most creative and accomplished agencies. By combining creative expertise with the strategic and innovative power of our Villages, we can build seamless teams around the individual needs of each of our clients.
Havas Media Network
We create the best media experience, capitalizing on the most meaningful media to build more meaningful brands. We know how to connect a client with their target audience – in the context of where they are, through the content they pay attention to. We deliver this expertise through the Mx System, our global operating methodology and strategic planning process, that creates value for our clients by turning consumer intelligence into clear growth targets, aligning stakeholders and KPIs, and measuring the impact of media experiences.
Havas Health
Driven by human purpose and focused on the betterment of humanity through health, Havas Health & You leverages a global collection of experts and individuals to help people everywhere live healthier lives. With a spirit rooted in innovation, creativity, and education, we are dedicated to delivering consistent excellence and groundbreaking work.
