Job description:

About Us

As Canada's largest automobile association, we are passionate about keeping our Members safe - whether they are on the road, at home, or travelling abroad. Meeting the diverse needs of our 2.5M+ Members requires high performing, forward thinking, and innovative people who work collaboratively to keep propelling our business forward.

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.

Join our growing team where everyone belongs!

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 serve marketing lines of business (LOBs) and other functional areas in the organization to achieve their business objectives including customer acquisition, retention, product sales, customer engagement, etc.  We regret that those without hands-on SAS or SQL experience will not be considered for the role.

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.

Our Commitment

We are an equal opportunity employer and are committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005 (AODA). CAA 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.