Business Intelligence Consultant

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, e-commerce and wider business performance. The BI Consultant will also actively contribute to the ongoing growth and success of the department and team.

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, e-commerce, 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. star-schemas)
• 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
• 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 exciting projects and exposure to industry leaders.

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.

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.

• 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. star-schemas)
• 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.

• 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
• 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 exciting projects and exposure to industry leaders.

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.