Marketing Database Analyst

Michael Page; Toronto; On-site; CAD 65,000 - 95,000; Full time

Job summary

Michael Page is seeking a Marketing Analytics professional in Toronto to support data extraction, campaign targeting, and performance measurement using SAS/SQL and Power BI. You will build dashboards, analyze results, and deliver insights to improve customer acquisition and engagement.

The role requires 3+ years in analytics, SAS/SQL programming, and BI reporting, with a strong ability to translate data into actionable business decisions.

Qualifications

• Bachelor's degree in Mathematics, Statistics, Analytics, Engineering or Commerce.
• 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 Power BI or Tableau
• SAS Certified Advanced Programmer (SAS 9) is an asset
• Hands-on experience with SSMS and T-SQL is an asset
• Hands-on experience of Environics Prizm and Envision is an asset

Responsibilities

• 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 significant changes and provide insights.
• Conduct post-campaign analysis to evaluate the effectiveness of marketing programs and provide story-telling insights to facilitate decision making.
• Leverage data from 1st and 3rd party sources to reveal insights through profiling and opportunity analysis

Skills

SAS/SQL programming

BI reporting

Data analytics

Storytelling

Education

Bachelor's degree in Mathematics/Statistics/Analytics/Engineering/Commerce

Tools

Power BI

Tableau

SSMS / T-SQL

Environics Prizm

Envision

Job description

This role focuses on using SAS/SQL and analytics tools to support marketing campaigns through data extraction, targeting, and performance measurement. It involves building dashboards, analyzing campaign results, and delivering insights to improve customer acquisition, engagement, and overall marketing effectiveness.

Canadian insurance company

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

Profile

The successful candidate is a detail-oriented and analytical professional with strong SAS/SQL expertise and experience in marketing data analysis. They are proactive, skilled in translating data into actionable insights, and able to collaborate with stakeholders to drive effective, data-driven marketing decisions.

Job Offer

• Exposure to end-to-end marketing analytics and high-impact campaigns
• Strong skill-building in SAS/SQL, Power BI, and experimental design
• Opportunity to influence business decisions with data-driven insights
• Cross-functional collaboration with marketing and analytics leaders
• Career growth in a data-driven, insights-focused environment

Client Details

Canadian insurance company

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