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

The base salary for this position at the time of this posting may range between the values at the bottom of this posting. Individual compensation varies based on job-related factors, including location, business needs, level of responsibility, experience, and qualifications.

$90,000-$140,000 CAD