Back to search

Marketing Data Consultant

Toronto Permanent CA$80,000 - CA$90,000 per year View Job Description
This role partners with marketing teams to scope, design, and analyze data-driven campaigns, using SAS/SQL and Power BI to deliver targeted customer strategies. It combines hands-on data work, experimental design, and consulting to optimize campaign performance and drive business decisions.

This role uses AI-assisted tools to support initial screening. All assessments and decisions are made by a human reviewer.

  • Build advanced data skills in SQL/SAS, BI, and experimentation
  • Drive real business impact through data-driven customer insights

About Our Client

Canadian insurance company

Job Description

What you will do

  • Provide practical assistance in analytical data investigation, validation and implementation
  • Identify new data or process enhancement opportunities and contribute to the enhancement
  • Support the Supervisor of Marketing Analytics & Insights in quarterly request intake and project conversion process by clarifying and aligning on campaign objective and targeting criteria
  • Use statistically-proven campaign targeting and testing methodology in experimental design
  • Pull campaign lists by using SAS/SQL scripts and ensure waterfalls are signed off, lists are error-free and delivered on time
  • Develop robust and user-friendly Power BI reports and dashboards for campaign performance measurement
  • Monitor and analyze campaign variances and performance trends. Notify business of any significant changes and provide insights through data deep dives
  • Conduct post-campaign analysis to evaluate the effectiveness of marketing programs and initiatives and provide story-telling insights to facilitate decision making
  • Leverage both 1st and 3rd party data, various platforms and analytical tools and models to reveal demo-, geo-, psychographic and behavioural insights through customer profiling & opportunity analysis



Who You Are

  • Bachelor's degree in Mathematics, Statistics, Analytics, Engineering or Commerce
  • Highly collaborative with excellent communication and story-telling skills - a true bridge between data and business
  • 3+ years of analytics experience in database marketing, marketing analytics, campaign management, hypothesis testing and experimental design
  • 3+ years of SAS or SQL programming with enterprise-level database
  • 3+ years of BI reporting and visualization tools such as Microsoft Power BI or Tableau
  • SAS Certified Advanced Programmer (SAS 9) is an asset
  • Hands-on experience of SSMS (SQL Server Management Studio) and T-SQL is an asset
  • Hands-on experience of Environics Prizm and Envision is an asset

MPI does not discriminate on the basis of race, religion, sex, sexual orientation, gender identity or expression, age, disability, marital status, or based on an individual's status in any group or class otherwise protected under applicable human rights legislation. MPI encourages applications from minorities, women, the disabled and all other qualified applicants

The Successful Applicant

An experienced marketing analytics professional with 5+ years in SAS/SQL, campaign targeting, and customer insights who can translate complex data into actionable strategies. They are detail-oriented, collaborative, and comfortable advising stakeholders in a fast-paced environment.

What's on Offer

  • End-to-end ownership of campaign analytics and strategy influence
  • Advanced exposure to experimental design, customer profiling, and data integration
  • Opportunity to shape marketing decisions with measurable business impact
  • Continuous learning through new data sources, tools, and cross-team collaboration



Contact
Nicole Hua
Quote job ref
JN-062026-7033262

Job summary

Sector
Information Technology
Sub Sector
IT Data Analysis
Industry
Financial Services
Location
Toronto
Job Type:
Permanent
Consultant name
Nicole Hua
Job Reference
JN-062026-7033262