Marketing Database Analyst

CAA South Central Ontario; Vaughan; On-site; CAD 80,000 - 110,000; Full time

Job summary

CAA Club Group is seeking a Marketing Analytics professional in Canada to provide data-driven insights and support to the Marketing Analytics & Insights team. You will develop Power BI dashboards, perform campaign targeting analyses, and collaborate with stakeholders to improve campaign performance across various data sources.

Ideal candidates have 3+ years of analytics experience, strong SQL skills, and proficiency in BI tools like Power BI or Tableau.

Qualifications

• Bachelor's degree in Mathematics, Statistics, Analytics, Engineering or Commerce.
• 3+ years of analytics in database marketing and campaign management.
• 3+ years of SQL programming with enterprise databases.
• 3+ years of BI reporting with Power BI or Tableau.
• SSMS and T-SQL experience is a plus.
• Environics Prizm and Envision experience is a plus.

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.
• Develop robust and user-friendly Power BI reports and dashboards for campaign performance measurement.
• Monitor and analyze campaign variances and performance trends, and provide insights through data deep dives.
• Conduct post-campaign analysis to evaluate the effectiveness of marketing programs.

Skills

Analytical data investigation

SQL

Power BI

Tableau

SSMS

T-SQL

Environics Prizm

Envision

Education

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

Tools

Power BI

Tableau

Job description

Select how often (in days) to receive an alert:

At CAA Club Group, we are passionate about keeping our Memberssafe - whether they are on the road, at home, or travelling abroad.As atrusted Member-based organization, we provide products and services that are essential to Members’ safety and peace of mind. With over 2.6 million Members across Ontario and Manitoba, we advocate on issues such road safety and infrastructure, the environment, seniors’ mobility, and consumer protection. Associates share in each other’s successes, drive change and support each other while cultivating a great working environment to deliver on what is best for our Members. CAA Club Group 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, and
• Competitive benefits that include a defined contribution plan, personal spending account, and so much more.

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

Please note, salary range is not inclusive of total compensation. The expected salary range for this position will be impacted by factors such as the successful candidate’s skills, experience and working location, as well as the specific position’s business line, scope and level. Candidates with salary expectations outside of the range are encouraged to apply.

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 SQL programming with enterprise-level database.
• 3+ years of BI reporting and visualization tools such as Microsoft Power BI or Tableau.
• 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.

Please note that internal applicants are asked to formally express their interest by applying online no later than 10 business days of the position being posted.

Please note that 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.