Marketing Database Analyst

CAA Club Group; Vaughan; On-site; CAD 70,000 - 90,000; Full time

Benefits offered by this job

Holistic wellness program

Continuous learning opportunities

Travel incentives

Competitive benefits

Job summary

CAA Club Group is looking for a Marketing Database Analyst to join their Marketing Analytics and Insights team. The successful candidate will support marketing lines of business by providing campaign and analytics services essential for achieving business objectives like customer acquisition and retention.

Key responsibilities include data investigation, supporting project processes, and developing Power BI reports. Candidates should have a bachelor's degree and over 3 years of experience in relevant analytics practices.

This role is based in York Region, Vaughan, and offers a commitment to employee wellness and support.

Qualifications

• 3+ years of analytics experience in database marketing and campaign management.
• 3+ years of SAS or SQL programming with enterprise-level database.
• Highly collaborative with excellent communication and story-telling skills.

Responsibilities

• Provide practical assistance in analytical data investigation and validation.
• Monitor and analyze campaign variances and performance trends.
• Develop robust and user-friendly Power BI reports for campaign performance.

Skills

Analytical skills

Communication skills

SAS programming

SQL programming

Power BI

Education

Bachelor’s degree in Mathematics, Statistics, Analytics, Engineering, or Commerce

Tools

SAS

SQL Server Management Studio (SSMS)

Power BI

Tableau

Job description

About Us

At CAA Club Group, we are passionate about keeping our Members safe — whether they are on the road, at home, or travelling abroad. As a trusted member‑based organization, we provide products and services essential to Members’ safety and peace of mind. With over 2.6 million Members across Ontario and Manitoba, we advocate on issues such as road safety, infrastructure, the environment, seniors’ mobility, and consumer protection. Associates share in each other’s successes, drive change, and support one another while cultivating a great working environment to deliver on what is best for our Members. CAA SCO Systems & Services Inc. is a member of the CAA Club Group of Companies.

Who We Are

Are you ready to join an award‑winning, purpose‑driven culture? Welcome to the CAA Club Group of Companies (CCG), where purpose leads to passion!

• At CCG, we are committed to delivering an exceptional Associate experience. We offer:
• Work‑life harmony with access to an award‑winning holistic wellness program,
• Continuous learning through our robust corporate curriculum and education reimbursement program,
• Incredible rewards, travel incentives, and product and service discounts,
• Pay‑for‑performance and best‑in‑class recognition programs,
• Competitive benefits that include a defined contribution plan, personal spending account, and so much more.

Position Details

We are looking for a Marketing Database Analyst to join our Marketing Analytics and Insights team. This role will provide campaign and analytics services to support marketing lines of business (LOBs) and other functional areas in the organization to achieve their business objectives including customer acquisition, retention, product sales, and customer engagement. Candidates without hands‑on SAS or SQL experience will not be considered.

Salary range is not inclusive of total compensation. The expected salary range will be impacted by factors such as the successful candidate’s skills, experience, working location, and the specific position’s business line, scope, and level.

What You Will Do

• Provide practical assistance in analytical data investigation, validation, and implementation.
• Identify new data or process enhancement opportunities and contribute to their enhancement.
• Support the Supervisor of Marketing Analytics & Insights in quarterly request intake and project conversion processes by clarifying and aligning on campaign objectives and targeting criteria.
• Use statistically proven campaign targeting and testing methodology in experimental design.
• Pull campaign lists 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 first‑ and third‑party data, various platforms and analytical tools, and models to reveal demographic, geographic, psychographic, and behavioural insights through customer profiling and 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 with SSMS (SQL Server Management Studio) and T‑SQL is an asset.
• Hands‑on experience with Environics Prizm and Envision is an asset.

Internal applicants are asked to formally express their interest by applying online no later than ten business days from the posting of the position.

We may use AI tools to help us through the recruitment process.

Our Commitment

We are an equal opportunity employer and are committed to providing employment accommodation in accordance with all applicable Provincial Human Rights and Accessibility Legislation. CCG will provide accommodations to job applicants with disabilities throughout the recruitment process. If you require an accommodation, please notify us and we will work with you to meet your needs.