Description
Business Intelligence Consultant
London, Manchester, hybrid
DEPT® is a Growth Invention company built to help the world's most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ specialists deliver growth invention services across Brand & Media, Experience, Commerce, CRM, and Technology & Data. We're 50|50 tech and marketing, partner-led, and first to move. Clients include Google, Lufthansa, Meta, eBay, and OpenAI. We have been certified B Corp and Climate Neutral since 2021.
JOB PURPOSE
As a Business Intelligence Consultant at DEPT®, you help our clients turn complex data into clear, actionable insight. You work closely with stakeholders to understand how their business is run, what decisions they need to make, and which KPIs truly matter – then translate this into smart BI solutions and dashboards that people actually use.
As a Business Intelligence Consultant, you are the absolute expert in translating business questions into data products, designing clear dashboard concepts and validating data with stakeholders. You know how to work with multiple data sources, set up and maintain data connections, and guide clients in choosing and using the right BI tools. You help clients not only get the right data in the right place, but also feel confident using it to steer their marketing, ecommerce and wider business performance. The BI Consultant will also actively contribute to the ongoing growth and success of the department and team.
The BI Consultant joining the expert team, will take on a portfolio of well known clients and manage multiple, diverse projects, from strategic advice, solution design to hands-on implementation.
KEY RESPONSIBILITIES
- Lead and facilitate discovery workshops with clients to understand their business model, stakeholders, KPIs and reporting needs;
- Translate business questions into clear BI requirements, data models and dashboard concepts;
- Design, prototype and build dashboards that serve both management and specialist users, ensuring they are intuitive, insightful and actionable;
- Set up, validate and maintain data integrations from multiple sources (e.g. marketing platforms, CRM, ecommerce, internal systems);
- Conduct audits of existing BI and reporting setups, assessing data quality, tooling, processes and overall data maturity;
- Collaborate closely with client- and in-house teams to guide them on best practices for data collection, modelling and visualisation;
- Enable and onboard clients on their dashboards and reports, ensuring stakeholders understand, adopt and use them to drive decisions;
- Continuously identify opportunities to improve and automate reporting, streamlining recurring analysis and freeing up time for insight-driven work.
WHAT WE ARE LOOKING FOR
- Relevant experience in a data-related role (e.g. BI Consultant, Data Analyst, Data Specialist, Marketing Analyst)
- Strong SQL expertise for data manipulation, transformation and data models (e.g. starschema’s).
- Strong experience in one or more reporting tools: PowerBI, Looker Studio, Looker, or Tableau
- Experience with data analysis and/or data analysis tools (e.g. Python, R, SPSS)
- An understanding of marketing data (e.g. campaign performance, attribution, website tracking)
- An analytical, independent and proactive profile with strong stakeholder management and communication skills, who feels at home in a client-facing environment.
WE OFFER
- A flexible, hybrid working policy (2 days from the office, depending on location).
- An excellent salary based on experience and equal pay policies
- Pension, free private healthcare, mental health support, and company sick pay scheme.
- 26 days paid holiday (plus UK Bank Holidays).
- Refreshments are provided in the office all week, as well as drinks at 4 pm on a Thursday.
- Help getting you to work with a season ticket loan and cycle to work scheme.
- Enhanced family friendly policies to support new parents.
- Social and Cultural Events, plenty of opportunities to connect with colleagues through organised activities and celebrations.
- Inspirational Talks, bringing the outside in with regular guest speakers and events.
- Learning and Development, supporting your growth with continuous opportunities to learn and advance.
- Buddy Programme: You will be paired with a ‘Buddy’ to help you through your first weeks’ at DEPT®.
- A reputation for doing good. DEPT® has been a Certified B Corp® since 2021 and named ‘Agency of the Year’ at both The Lovies and The Webby Awards.
- Awesome clients. Whether big or small, local or global — at DEPT® you’ll get
WHO ARE WE?
We are pioneers at heart. What does that mean? We are always looking forward, thinking of what we can create tomorrow that does not exist today. We were born digital and we are a new model of agency, with a deep skillset in tech and marketing. That’s why we hire curious, self-driven, talented people who never stop innovating.
Our culture is big enough to cope and small enough to care. Meaning, that with people across 30+ countries, we’re big enough to provide you with the best tools, global opportunities, and benefits that help you thrive. While acting small by investing in you, your growth, your team, and giving you the autonomy to solve our clients problems, no matter where you are in the world.
DIVERSITY, EQUITY & INCLUSION
At DEPT®, we take pride in creating an inclusive workplace where everyone has an equal opportunity to thrive. We actively seek to recruit, develop, nurture, and retain talented individuals from diverse backgrounds, with varying skills and perspectives.
Not sure you meet all qualifications? Apply, and let us decide! Research shows that women and members of underrepresented groups tend not to apply for jobs when they think they may not meet every requirement, when in fact they do. We believe in giving everyone a fair chance to shine.
We also encourage you to reach out to us and discuss any reasonable adjustments we can make to support you throughout the recruitment process and your time with us.
Want to know more about our dedication to diversity, equity, and inclusion? Check out our efforts here.
Similar jobs
Business Intelligence Consultant Budapest, hybrid This role is part of our Creative & Media team. Our team is a vibrant mix of talents, ranging from Creatives, Influencer Marketers, Brand & Content Strategists to…
Est. 65,000 EUR
Business Intelligence Consultant Amsterdam / Rotterdam, hybrid This role is part of our Creative & Media team based in Rotterdam and Amsterdam. Our team is a vibrant mix of talents, ranging from Creatives, Influencer…
Est. 80,000 GBP
AI Consultant Manchester, London, hybrid DEPT® is a Growth Invention company built to help the world's most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ specialists…
Est. 55,000 GBP
DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ specialists deliver growth invention services across…
Est. 45,000 GBP
Please note, this is a talent pool position, not a live role. If you are interested in future Account Management/Client Services opportunities at DEPT®, please submit an application and we will be in touch when a suitabl…
Est. 80,000 EUR
AI Consultant Amsterdam, Rotterdam, hybrid DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ specialist…
Est. 80,000 EUR
Account Director This role is an FTC running to the end of 2026 Berlin, hybrid This role is part of our Personalised Content team. We create emotive yet conversion-focused ideas, products and campaigns at scale and speed…
Est. 85,000 GBP
Associate Creative Director London, Hybrid This position sits in our Marketing & Technology service based in London. We combine data, technology, creative and paid media to crack brands’ business problems & drive…
This is a 6 month fixed term employee contract initially, with a likelihood of extension. Toronto, hybrid DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the…
This is a 6 month fixed term employee contract initially, with a likelihood of extension. Toronto, hybrid DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the…
Est. 80,000 EUR
Client Partner (d/f/m) DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ specialists deliver growth inv…
Est. 120,000 EUR
Client Director (d/f/m) Berlin, Hamburg hybrid DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ specia…
Est. 85,000 GBP
Design Director (AI&Tech) London / Manchester This position sits in our Marketing & Technology service based in London. We combine data, technology, creative and paid media to crack brands’ business problems &…
Est. 55,000 GBP
Manchester, hybrid DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ specialists deliver growth inventi…
Est. 85,000 GBP
DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ specialists deliver growth invention services across…
Please note, this is a talent pool position, not a live role. If you would like to be considered for any future Account Management/Client Services positions at DEPT®, please submit an application and we will be in touch…
Est. 55,000 GBP
This role is an FTC running to the end of 2026 DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ specia…
Est. 85,000 GBP
Associate Design Director London This position sits in our Marketing & Technology service based in London. We combine data, technology, creative and paid media to crack brands’ business problems & drive revenue t…
Est. 65,000 EUR
Digital Project Manager Dublin, hybrid DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ specialists de…
This is a 6 month fixed term employee contract initially, with a likelihood of extension. Toronto, hybrid DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the…
Est. 65,000 GBP
Senior Content Manager (Web & Acquisition)London, hybrid3 month FTC WHO ARE WE? DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of techno…
Est. 65,000 EUR
Amsterdam, Rotterdam, hybrid DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ specialists deliver grow…
Est. 120,000 EUR
Client Director (d/f/m) Berlin, Hamburg hybrid DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ specia…
Est. 35,000 GBP
Please note, this is a talent pool position, not a live role. If you would like to be considered for any future Design positions at DEPT®, please submit an application and we will be in touch when a suitable opportunity…
Est. 55,000 GBP
This is a fixed-term contract initially until 15th January 2027, with the potential for extension. DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the interse…
Est. 45,000 GBP
This is a fixed term contract until 31st December 2026 initially, with likelihood of extension. This role is part of our eBay Inhouse team, where you will be employed by DEPT® but embedded within eBay. JOB PURPOSE At eBa…
WHY DEPT®? We are a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, we create what is next by pioneering ideas, acting fast…
This is a 5-month fixed-term employment contract ending December 31, 2026, with the possibility of extension. DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at…
Est. 65,000 EUR
Digital Account ManagerAmsterdam/Rotterdam, hybrid DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at the intersection of technology and marketing, our 4,000+ sp…
This is a 6 month fixed term employee contract initially, with a likelihood of extension. Vancouver, remote DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. Operating at th…