Senior Data Insights Consultant

VML MAP•Toronto, ON

About The Position

WPP is seeking a Senior Data Insights Consultant to join their growing Technology and Data team. This role involves being a key leader in helping clients make data-driven decisions to enhance their digital communication on an enterprise scale. The position requires designing, enabling, and delivering complex data solutions and integrations for various campaign platforms. The consultant will architect, build, and deliver value-adding insights solutions, advise clients on leveraging data assets, perform advanced analysis, design test-and-learn programs, partner with senior stakeholders to define strategic business questions, support data streams on large-scale projects, drive proactive client ideation, help drive agentic AI adoption, provide insights via automated reporting and ad-hoc analysis, mentor junior team members, and collaborate with various specialists.

Requirements

A minimum of 5 years of experience in a consultant/business liaison role related to data, BI, analytics or reporting solutions.
Ability to independently design, build, and optimize modern analytics solutions that are scalable, maintainable, and ready for real-world production use.
Ability to write, debug, and optimize complex SQL queries, ensuring clarity, efficiency, and production readiness.
Ability to design and build scalable dimensional data models from raw source systems (fact/dimension structures, performance-aware design).
Ability to apply strong data modelling principles, governance standards and practices that ensure data accuracy, consistency, and security.
Ability to develop and manage DBT transformations using layered architecture, including testing and documentation best practices.
Ability to build production-ready Power BI semantic models and dashboards, including advanced DAX measures, performance optimization, and secure data access (RLS).
Experience working 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).
Technical stakeholder management and influence: A proven ability to build trust and act as a strategic partner to senior-level clients and internal leaders.
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.
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.

Nice To Haves

Ability to build and deliver reports and insights dashboards natively within marketing platforms such as Adobe and Salesforce is a strong advantage.
Consulting, agency experience or marketing domain knowledge is an advantage, but not a requirement.

Responsibilities

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.