Business Intelligence Consultant

London, Manchester, hybrid

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. Clients include Google, Lufthansa,

Meta, eBay, and OpenAI. We have been certified B Corp and Climate Neutral since 2021.

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.

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.

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.
26 days paid holiday (plus UK Bank Holidays).
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

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.

Not sure you meet all qualifications? Apply, and let us decide! 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. We believe in giving

everyone a fair chance to shine.

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.

Role

Business Intelligence Consultant

Tags for this job

Python SQL PowerBI Tableau

Similar Jobs

Senior Application Consultant - Salesforce Marketing Cloud

VML MAP

London•Posted: Jul 6•Deadline: Aug 16

WHO WE ARE WPP Enterprise Solutions designs, builds, and operates the growth systems that competitive businesses rely on. In a world where Al is reshaping how companies drive growth, we lead clients in business transformation and marketing modernization, connecting strategy directly to execution. Our 12,000 experts in engineering and platforms, commerce, consulting, content transformation, CRM, and CX work within a unified global operating unit across 40+ markets. WPP Enterprise Solutions works alongside best-in-class partners including Adobe, AWS, Braze, Google, Microsoft, Salesforce, and Shopify, as well as innovators in AI, to deliver growth solutions tailored to the needs of our clients’ businesses. Are you eager to learn about innovative technologies? Would you like to work with some of the awesome internal tools developed by the Catalyst team (MAP internal product team)? Then you might be just the Application Consultant we are looking for! WHAT WILL YOUR DAY LOOK LIKE? As our new Application Consultant, you will become part of our growing development team. Here, you will deal with lots of moving pieces and help us build the most effective way to launch marketing campaigns at scale for global brands – focusing on making the process as seamless and efficient as possible for marketers and operations specialists while also activating new technical capabilities. As an Application Consultant you will bridge the gap between technology and marketing strategies. They work closely with clients to understand their business objectives and translate them into technical requirements. They collaborate with developers to ensure the technical solutions align with the client's business goals. More specifically, your tasks include: * Collaborating effectively within a cross-functional team, partnering with operations and product teams to ensure seamless product delivery and client success. * Driving the successful adoption of Catalyst tools across our client base by leveraging your technical expertise to configure efficient and tailored end-to-end client experiences. * Streamlining client operations by configuring and implementing customized business rules and automations. * Bringing product visions to life by configuring and implementing new features according to provided specifications and designs. * Ensuring the quality and reliability of implementations by rigorously testing configurations and newly developed features. * Proactively identifying, troubleshooting, and resolving technical issues within existing applications, ensuring a seamless user experience. * Collect business requirements by engaging with marketers to translate them into technical specifications * Utilize tools to build data audiences and manage segments while understanding their quality and integrity * Contributing to a culture of continuous improvement by identifying and recommending opportunities to optimize the Catalyst platform and its features. WHO ARE YOU GOING TO WORK WITH? You will join a team of highly skilled developers, architects, data specialists, product managers and project managers who are passionate about building great products and customer experiences together. You will also get to work closely with experts from other technology, creative and client teams. WHAT DO YOU BRING TO THE TABLE? As a person, you have a team player mindset and an open-minded attitude. You can communicate ideas and technical topics honestly and clearly – also to non-experts – while respecting the views of others on the team. You are eager to understand and find solutions, allowing you to quickly adapt to changing situations and come up with new ideas. As a strategic thinker, you take into consideration the big picture, and critically assess the projects you're working on, consulting and advising when needed. At the same time, you solve problems in an analytical and pragmatic manner, both independently and as part of the team. Moreover, you have experience with: * Deep understanding of Marketing Operations: Proven understanding and implementation of advanced marketing automation setups, leveraging best practices for optimal performance. * Experience with Salesforce Marketing Cloud is mandatory * Customer Journey Expertise: experience crafting and optimizing customer journeys, lifecycle stages, and trigger-based marketing programs that drive engagement and conversions. * Client-Focused Approach: Adept at understanding and adapting to diverse client processes and ways of working, with a track record of delivering tailored technical solutions. * Technical Proficiency: Strong JavaScript programming or alike skills and experience developing client-specific solutions within a marketing automation platform. * Data Management: Experience querying, validating, understanding and using data for developing relevant audiences to communicate or report to A LEADER IN PERSONALIZED CUSTOMER EXPERIENCES VML MAP is a world-leading Centre of Excellence that helps businesses humanize the relationship between the brand and the customer through hyper personalization at scale, marketing automation and CRM. With the brain of a consultancy, the heart of an agency and the power of technology and data, we work with some of the world's most admired brands to help them on their transformation journey to becoming truly customer-centric. Together, we are 1000 + technology specialists, data scientists, strategic thinkers, consultants, operations experts, and creative minds from 55+ nationalities. A GLOBAL NETWORK We are part of the global VML network that encompasses more than 30,000 employees across 150+ offices in 60+ markets, each contributing to a culture that values connection, belonging, and the power of differences. #LI-EMEA About WPP WPP is the trusted growth partner for the world’s leading brands. We unite cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and expert strategic counsel in a single company – powered by exceptional talent and our agentic marketing platform, WPP Open, to help our clients navigate change, capture opportunity and deliver transformational growth. For more information, visit WPP.com. WPP (MAP/VML) is an equal opportunity employer and considers applicants for all positions without discrimination or regard to characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers. When you click “Apply now” below, your information is sent to MAP/VML. To learn more about how we process your personal data during when you apply for a role with us, on how you can update your information or have the information removed please read our Privacy policy. California residents should read our California Recruitment Privacy Notice.

Senior Data Insights Consultant

VML MAP

London•Posted: Jul 6•Deadline: Aug 16

WHO WE ARE WPP Enterprise Solutions designs, builds, and operates the growth systems that competitive businesses rely on. In a world where Al is reshaping how companies drive growth, we lead clients in business transformation and marketing modernization, connecting strategy directly to execution. Our 12,000 experts in engineering and platforms, commerce, consulting, content transformation, CRM, and CX work within a unified global operating unit across 40+ markets. WPP Enterprise Solutions works alongside best-in-class partners including Adobe, AWS, Braze, Google, Microsoft, Salesforce, and Shopify, as well as innovators in AI, to deliver growth solutions tailored to the needs of our clients’ businesses. Do you have strong data and analytical skills, with a passion for shaping business strategy? Can you architect, build, and apply modern data models to deliver impactful marketing insights? Are you seeking an exciting role with significant opportunities for leadership and growth? Then you might be the Senior Data Insights Consultant we are looking for! What will your day look like? As our new Senior Data Insights Consultant, you will join our growing Technology and Data team. Here, you will be a key leader in helping our clients make data-driven decisions to enhance their digital communication on an enterprise scale. This entails designing, enabling, and delivering complex data solutions and integrations for various campaign platforms. More specifically, your tasks will include: * Architecting, building, and delivering value-adding insights solutions, serving as a key advisor to clients on how to leverage their data assets to optimize large-scale communication strategies. * Performing advanced analysis to uncover actionable patterns, trends, and opportunities that directly inform client strategy and decision-making. * Designing and running test-and-learn programs (A/B tests, incrementality, holdouts) across channels to measure impact and continuously optimize communication performance. * Partnering with senior stakeholders to define strategic business questions and translating them into robust analytical frameworks and data roadmaps. * Supporting or leading the data-stream on complex, large-scale projects with globally recognised brands, ensuring that data solutions and integrations are designed and delivered for scalability and business impact. * Driving ongoing proactive client ideation — identifying new opportunities, use cases, and data-driven initiatives that help clients grow their business. * Helping drive agentic AI adoption, exploring and embedding agentic solutions into our data and insights workflows to enhance efficiency and client value. * Providing answers and insights to business-related questions via automated reporting solutions as well as ad-hoc data analyses, including building reports and insights dashboards within marketing platforms such as Adobe and Salesforce. * Mentoring, reviewing, and advising less senior team members — elevating quality, fostering technical excellence, and supporting their professional growth. * Collaborating with highly skilled specialists including Account Managers, Architects, Developers, Creatives, Strategists, Data Scientists and Marketing Operations experts to service our clients coherently. Who are you going to work with? You will join a team of hands-on Data Insights Consultants, Data Scientists and Data Engineers who are passionate about bringing value and knowledge from data. We are all about unlocking insights from data through analytics and making that insight applicable in 1:1 data-driven communication and CRM. Your work will always be firmly anchored in data in a cross-disciplinary setting, collaborating closely with highly enthusiastic experts from Strategy or Creative backgrounds. What do you bring to the table? As a person, you possess a strong consultancy mindset, demonstrating resilience, curiosity, and an eager-to-learn attitude. You combine this with strong business acumen, allowing you to understand and anticipate client needs effectively. You are outgoing and love being part of interdisciplinary projects and solutions. You are eager to learn and quick to understand the complexity of high-tech dialogues and solutions. Furthermore, you have the drive, enthusiasm, and technical credibility to act as the primary data and insights advisor for senior client leadership, guiding them through complex challenges and inspiring them to grow their business. It's an advantage if you have consulting, agency experience or marketing domain knowledge, but it's not a requirement. In addition, you have: Technical skills * A minimum of 5 years of experience in a consultant/business liaison role related to data, BI, analytics or reporting solutions. Can independently design, build, and optimize modern analytics solutions that are scalable, maintainable, and ready for real-world production use. * Write, debug, and optimize complex SQL queries, ensuring clarity, efficiency, and production readiness. * Design and build scalable dimensional data models from raw source systems (fact/dimension structures, performance-aware design). Apply strong data modelling principles, governance standards and practices that ensure data accuracy, consistency, and security. * Develop and manage DBT transformations using layered architecture, including testing and documentation best practices. * Build production-ready Power BI semantic models and dashboards, including advanced DAX measures, performance optimization, and secure data access (RLS). * Work collaboratively using GitHub, following structured branching, pull request, and code review workflows. * Familiarity with or a strong interest in the application of AI and agentic frameworks, and machine learning principles to generate conversational analytics, predictive and advanced marketing insights. * Comfortable working in modern cloud data environments (e.g., Snowflake, BigQuery, Databricks, Fabric). * Understanding the data structures and reporting capabilities within major marketing and martech platforms (e.g., Adobe Campaign/AJO, Salesforce Marketing Cloud). Ability to build and deliver reports and insights dashboards natively within these tools is a strong advantage Interpersonal skills * Technical stakeholder management and influence: A proven ability to build trust and act as a strategic partner to senior-level clients and internal leaders. You can confidently navigate complex, technical stakeholder environments and influence decision-making through data-driven reasoning. * Communication and storytelling: Exceptional written and verbal communication skills in English, with the ability to articulate complex data concepts and insights into clear, compelling narratives for both technical and senior business audiences. * Consultative and solutions-oriented mindset: The ability to critically assess complex business challenges, ask probing questions to uncover root causes, and propose robust, data-driven solutions. * Leadership and mentorship: Proven experience in coaching and mentoring junior team members. You actively foster a culture of technical excellence, collaboration, and continuous learning within the team. * Autonomy and critical thinking: You are a self-starter who can think critically, identify issues and opportunities autonomously, and take the initiative to propose and implement corrective actions. A leader in personalized customer experiences VML MAP is a world-leading Centre of Excellence that helps businesses humanize the relationship between the brand and the customer through hyper personalization at scale, marketing automation and CRM. With the brain of a consultancy, the heart of an agency and the power of technology and data, we work with some of the world's most admired brands to help them on their transformation journey to becoming truly customer-centric. Together, we are 1000+ technology specialists, data scientists, strategic thinkers, consultants, operations experts, and creative minds from 55+ nationalities. A global network We are part of the global VML network that encompasses more than 30,000 employees across 150+ offices in 60+ markets, each contributing to a culture that values connection, belonging, and the power of differences. About WPP WPP is the trusted growth partner for the world’s leading brands. We unite cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and expert strategic counsel in a single company – powered by exceptional talent and our agentic marketing platform, WPP Open, to help our clients navigate change, capture opportunity and deliver transformational growth. For more information, visit WPP.com. WPP (MAP/VML) is an equal opportunity employer and considers applicants for all positions without discrimination or regard to characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers. When you click “Apply now” below, your information is sent to MAP/VML. To learn more about how we process your personal data during when you apply for a role with us, on how you can update your information or have the information removed please read our Privacy policy. California residents should read our California Recruitment Privacy Notice.

Analytics Engineer

BCB Group

London•Posted: Jul 14•Deadline: Aug 16

THE ROLE - WHAT WILL YOU BE DOING? We are seeking a highly motivated and detail-oriented Data Engineer to join our dynamic Data and Analytics team. Reporting to the Head of Data and Analytics, you will play a pivotal role in transforming raw data into actionable insights that drive strategic business decisions. This position requires a strong analytical mindset, exceptional problem-solving skills, and the ability to effectively communicate complex technical concepts to non-technical stakeholders. The position is more than just a "warehouse developer" role. You will work cross-functionally with various departments—to understand their workflows, model their data, and build the "connective tissue" that makes the business move faster. You will be responsible for the end-to-end lifecycle of a data product: from identifying a business need to building the dbt models and ensuring that transformed data is accessible where it's needed most. KEY RESPONSIBILITIES OWNERSHIP OF THE MODERN DATA STACK (DBT & BIGQUERY) * Act as a lead developer for our dbt project. * Build performant, modular, and well-tested models that turn data into a reliable "Source of Truth." * Apply software engineering rigor to the data stack: version control (Git), documentation, unit testing, and CI/CD. CROSS-FUNCTIONAL AUTOMATION & INTELLIGENCE * Partner with business leads across the company to identify manual processes that can be streamlined through data automation. * Bridge the gap between the warehouse and the business by "closing the loop"—ensuring data isn't just sitting in a dashboard but is actively driving operational tools and decision-making. * AI Integration: Leverage AI tools and LLMs to accelerate development cycles, automate documentation, and explore new ways to enhance data quality. STAKEHOLDER ENGAGEMENT * Act as a consultant to business leads. Don't just "take tickets"—understand the underlying business logic and propose better ways to structure data. * Translate loosely defined business requirements into robust, automated technical solutions. * Data Quality Advocacy: Work closely with stakeholders to define data quality standards and establish feedback loops that ensure data captured in upstream systems is accurate, complete, and fit for purpose. What are we looking for Essential Skills and Experience * 3+ years of experience in a high-growth data environment (Analytics Engineer, Data Engineer, or Technical Data Analyst). * Modern Data Stack Specialist: Deep, practical knowledge of dbt and cloud warehouses (we use BigQuery, but the experience is very transferrable). * Expert-level SQL: You write complex, clean, and performant queries. * Python Literacy: Not a software developer, but you must be comfortable reading code, writing scripts for data manipulation, and handling API. * AI Comfort: You are an "AI-first" builder who is comfortable using AI tools (e.g., Cursor, GitHub Copilot, LLMs) to write code faster, debug, and stay ahead of the curve. * Ownership Mindset: You are comfortable working independently, managing your own roadmap, and taking accountability for the entire warehouse architecture. * Exceptional Communication: You can walk into a room with a non-technical team, understand their pain points, and explain your technical solution in plain English. Desired Skills and Experience: * Workflow Automation: Experience with tools like n8n, Zapier, or similar automation platforms. * BI/Semantic Platforms: Experience with Looker, Thoughtspot, or similar. * Industry Context: Experience in Payments, FinTech, Banking, or Cryptocurrency. * Reverse ETL: Familiarity with moving data from the warehouse back into SaaS tools. SO, WHAT’S IN IT FOR YOU? Our people are constantly striving to be the best through operational excellence. The professional development and learning opportunities create an agile, hardworking, conscientious, and knowledgeable team. The opportunities for personal growth are exponential. You grow as the business grows. The roles and responsibilities are broad and ever-changing, and the dynamism of BCB keeps you engaged and highly motivated. At BCB, you don’t just work for your manager; they work for you too. We believe in empowering individuals to create a culture of personal growth, together. We focus on driving empowerment from the bottom up, up-skilling every individual at every level. This means our team has a sense of commonality and belonging, driven by a shared belief in our mission. We’re passionate about our business, our people, and providing 360-degree support for success. * The chance to operate at the forefront of our industry * You can talk to anyone in the business as there are no barriers and everyone is accessible * You will be collaborating with teams on a hybrid working arrangement * We value team success where every individual can grow and prosper * 30 days annual leave each year, excluding bank holidays * 4 wellbeing days per year to prioritise your mental health * 1 company volunteering day per year * Strong benefits package including; Private Healthcare, Pension, Income Protection (long-term absence), Life Insurance, Menopause Policy, and an enhanced Parental Leave policy BCB GROUP BCB Group is a leading provider of regulated payment and trading services in crypto and fiat for the digital asset economy. We provide accounts, cryptocurrency and foreign exchange market liquidity for some of the world’s largest, crypto-engaged businesses, including crypto exchanges, liquidity providers, market makers, investment firms, custodians, payment processors and wallet providers. Our end-to-end suite of products are accessible through our Client Console UI and API. We offer more than 40 fiat and cryptocurrencies, deep trading liquidity, 24/7 instant payments through our instant settlements network, BLINC, and secure crypto services. Our strong focus on compliance matches our technical and business expertise, and we are regulated by some of the world’s most respected regulators. Authorised in the UK, France and Switzerland, we place the utmost importance on our regulatory-first institutional principles. Our leadership team boasts years of relevant, high-level experience at globally-renowned institutions. They combine finance, law, regulatory and technology skills in traditional and crypto financial services with a deep understanding of the new digital asset economy. Our mission is to create the trusted platform to pay, store, trade and earn fiat and digital assets, globally 24/7 www.bcbgroup.com