Lead Business Intelligence Consultant

About the role

DEPT's Data & AI practice is looking for a Lead Business Intelligence Consultant in Amsterdam. The role leads the BI capability across Europe, sets standards for how BI is delivered, delivers complex client solutions and grows the BI team. It combines deep BI expertise with business acumen and leadership skills, and works closely with clients to turn their business needs into usable dashboards.

Key responsibilities

• Lead the strategic development of the BI proposition and capabilities across Europe.
• Set standards and best practices for BI: methodology, data modelling, dashboard design, documentation and reusable components.
• Guide, coach and mentor BI consultants through development plans, feedback and performance conversations.
• Build and grow the BI team, owning hiring from defining the profile through to onboarding.
• Serve as senior authority on client engagements: lead discovery workshops, review data models and dashboard concepts, and advise clients on BI strategy, tooling and data maturity.
• Oversee reliable data integrations and data models serving management and specialist users.
• Work with the broader Data & AI practice and DEPT service teams across Europe to deliver integrated solutions.
• Support business development through BI expertise in client pitches, scoping and estimates, and grow BI work within existing accounts.
• Stay ahead of emerging tools and methodologies, and improve and automate how the team builds and runs reporting.

Required profile

• Extensive experience in a data-related role (e.g. BI Consultant, Data Analyst, Data Specialist, Marketing Analyst) with a proven track record of leading complex BI initiatives.
• Strong leadership experience guiding and developing a team of consultants.
• Excellent communication skills, able to explain complex data concepts to business stakeholders and hold their own in senior client conversations.
• Strategic thinking, with the ability to develop and execute a roadmap for the BI capability.
• Proven ability to mentor and develop talent.
• Comfortable working with colleagues and clients across multiple countries and time zones.
• Experience in an agency or consulting environment is highly advantageous.

Required skills

• Data modelling and transformation, with strong SQL (e.g. star schemas).
• Reporting tools: PowerBI, Looker Studio, Looker or Tableau.
• Data analysis tools such as Python, R or SPSS.
• Understanding of marketing data (campaign performance, attribution, website tracking).
• Grasp of data quality and governance.

What we offer

• Flexible hybrid working (2-3 days from the office, depending on location) and the option to work from abroad for 13 weeks a year.
• 24 vacation days per year, with the option to buy extra days.
• Learning menu and special programs, plus discounts on a lease bike and an NS Business Card.
• Health contributions, gym and wellness discounts, and healthy lunches at the office.