At a Glance
- Tasks: Transform complex data into actionable insights and create user-friendly BI solutions.
- Company: Join DEPT®, a leading Growth Invention company at the tech-marketing intersection.
- Benefits: Enjoy a competitive salary, private healthcare, 26 days holiday, and flexible hybrid working.
- Other info: Be part of a diverse team with excellent growth opportunities and a supportive culture.
- Why this job: Make a real impact by helping clients leverage data for smarter business decisions.
- Qualifications: Experience in data roles, strong SQL skills, and familiarity with BI tools like PowerBI or Tableau.
The predicted salary is between 49500 - 60500 £ per year.
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.
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.
- 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;
- 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;
- Continuously identify opportunities to improve and automate reporting, streamlining recurring analysis and freeing up time for insight-driven work.
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).
Experience with 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).
A flexible, hybrid working policy (2 days from the office, depending on location).
We offer 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 in the office all week, 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, learning and development opportunities, and a Buddy Programme.
Whether big or small, local or global — at DEPT® you’ll get the best tools, global opportunities, and benefits that help you thrive.
DIVERSITY, EQUITY & INCLUSION: 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. Want to know more about our dedication to diversity, equity, and inclusion?
Business Intelligence Consultants employer: DEPT®
DEPT® is an exceptional employer that fosters a dynamic and inclusive work culture in Greater London, where creativity and collaboration thrive. With a strong focus on employee growth, we offer flexible hybrid working arrangements, comprehensive benefits including a company pension and healthcare options, and generous holiday allowances to ensure a healthy work-life balance. Join us to be part of a forward-thinking team that values diverse perspectives and drives meaningful impact in the world of Paid Media.
