Business Intelligence Consultant

DEPT®; Manchester; Hybrid; GBP 50,000 - 70,000; Full time

Benefits offered by this job

Flexible working policy

Pension

Free private healthcare

Mental health support

26 days paid holiday

Buddy programme for new employees

Learning and development opportunities

Job summary

DEPT® is hiring a Business Intelligence Consultant based in Manchester. In this role, you will lead clients in transforming complex data into actionable insights by designing and implementing user-friendly BI solutions. The position requires strong SQL skills and experience with leading reporting tools.

We offer a flexible working policy, competitive salary, and numerous benefits including private healthcare, generous holidays, and personal development opportunities. Join us in making data intuitive and actionable for our clients.

Qualifications

• Relevant experience in a data‑related role.
• Strong expertise in SQL for data manipulation.
• Experience with reporting tools like Power BI or Tableau.

Responsibilities

• Lead discovery workshops with clients.
• Translate business questions into BI requirements.
• Design and build intuitive dashboards.

Skills

SQL expertise

Reporting tools expertise (Power BI, Tableau)

Data-related role experience

Stakeholder management skills

Understanding of marketing data

Tools

Power BI

Looker Studio

Tableau

Python

R

SPSS

Job description

London, Manchester, hybrid

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.

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.

Qualifications

• 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: Power BI, Looker Studio, Looker, or Tableau.
• Experience with analytics tools (e.g., Python, R, SPSS).
• Understanding of marketing data (e.g., campaign performance, attribution, website tracking).
• Proactive profile with strong stakeholder management and communication skills, comfortable in client‑facing environments.

Benefits

• A flexible, hybrid working policy (2 days from the office, depending on location).
• Competitive 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, and drinks at 4 pm on a Thursday.
• Season ticket loan and cycle‑to‑work scheme.
• Enhanced family‑friendly policies to support new parents.
• Social and cultural events, opportunities to connect with colleagues through organised activities and celebrations.
• Inspirational talks with guest speakers and events.
• Learning and development opportunities for continuous growth.
• Buddy programme to support early integration.
• Certified B Corp and Agency of the Year recognitions.

Diversity, Equity & Inclusion

Not sure you meet all qualifications? Apply, and let us decide!

We encourage you to reach out to us to discuss any reasonable adjustments we can make to support you throughout the recruitment process and your time with us.