Senior Consultant - Data Insights

MAP•Toronto, ON

7d•CA$90,000 - CA$140,000

About The Position

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! 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.

Requirements

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.

Nice To Haves

Consulting experience
Agency experience
Marketing domain knowledge

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.