Business Intelligence Consultant

DEPT®; Amsterdam; Hybrid; EUR 60,000 - 85,000; Full time

Benefits offered by this job

Hybrid working policy

Vacation days (24/year)

Learning Menu & Programs

Health & wellness benefits

NS Business Card

Job summary

DEPT® is seeking a Business Intelligence Consultant to translate business questions into data products and intuitive dashboards. You will work with multiple data sources, design dashboards, and guide clients in using BI tools to drive marketing, ecommerce and business performance.

You will join a collaborative Creative & Media team in Amsterdam/Rotterdam, contributing to strategic advice, solution design, and hands-on implementation for well-known clients.

Qualifications

• Experience in a data-related role (BI Consultant, Data Analyst, Data Specialist, Marketing Analyst)
• Strong SQL expertise for data manipulation, transformation and data models (starschema)
• Experience with reporting tools: PowerBI, Looker Studio, Looker, or Tableau
• Experience with data analysis tools (Python, R, SPSS)
• Understanding of marketing data (campaign performance, attribution, website tracking)
• Analytical, independent and proactive profile with stakeholder management and client-facing communication

Responsibilities

• Lead and facilitate discovery workshops with clients to understand business model, stakeholders, KPIs and reporting needs
• Translate business questions into BI requirements, data models and dashboard concepts
• Design, prototype and build dashboards for management and specialist users
• Set up, validate and maintain data integrations from multiple sources
• Audit existing BI and reporting setups, assess data quality and tooling
• Collaborate with client and in-house teams on data collection, modelling and visualisation
• Onboard clients on dashboards and reports, ensuring adoption and use to drive decisions
• Identify opportunities to automate reporting and streamline recurring analyses

Skills

SQL

Stakeholder management

Data modelling

Tools

Power BI

Looker Studio

Looker

Tableau

Python

Job description

Amsterdam / Rotterdam, hybrid

team based in Rotterdam and Amsterdam. Our team is a vibrant mix of talents, ranging from Creatives, Influencer Marketers, Brand & Content Strategists to Account Managers, Programmatic and Marketing Automation Consultants. Together, we blend imaginative storytelling and performance-driven strategies with cutting-edge technology to create engaging digital experiences that build lasting relationships with our clients like Netflix, Canva, Foot Locker, Philips & Biscoff.

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.

• 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;

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 Marketers, Brand & Content Strategists to Account Managers, Programmatic and Marketing Automation Consultants. Together, we blend imaginative storytelling and performance-driven strategies with cutting-edge technology to create engaging digital experiences that build lasting relationships with our clients like Netflix, Canva, Foot Locker, Philips & Biscoff.

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.

Nice to have

• Fluent Dutch

WE OFFER

• A flexible, hybrid working policy (2-3 days from the office, depending on location) and the opportunity to work from abroad for 13 weeks a year.
• 24 vacation days per year and the possibility to buy an unlimited number of extra vacation days.
• DEPT®/YOU Learning Menu and DEPT®/YOU Special Programs. Develop your skills with courses and programs tailored to your needs.
• Stay happy and healthy with a contribution to your health through the OpenUp platform, gym and wellness discounts, and healthy lunches at the office.
• Get a discount on your lease bike and ride in style. You can also enjoy hassle free-commutes with an NS Business Card.
• A reputation for doing good. DEPT® has been a Certified B Corp® since 2021, has been named a Great Place To Work since 2022 in the Netherlands and named ‘Agency of the Year’ at both The Lovies and The Webby Awards.
• Awesome clients. Whether big, small, local or global — at DEPT® you’ll get the opportunity to work with all of them. And we celebrate all of our successes together!
• You can discover even more employee benefits here.

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.

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.