Marketing Database Analyst

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

Position Details

What you will do

• Maintain the Marketing Analytics Datamart including data daily refresh and monthly rollups. Ensure data accuracy and data integrity.
• Identify data/process issues, notify the impacts to both internal team members and external clients in a timely manner and assist problem solving.
• Develop and maintain robust and user-friendly Power BI reports/dashboards for marketing data performance tracking.
• Participate in User Acceptance Test and data QA. On behalf of Marketing, act as the Subject Matter Expert in data, system and platform new launch and/or upgrade.
• Ensure all campaign data transfers follow the standards. Identify opportunities of streamlining and automating data transfers to improve efficiency.
• Assist the Supervisor of Marketing Data & Analytics in data exploration, preparation, interpretation and integration of both internal and external data to meet ever-growing business needs.
• Facilitate marketing LOBs in the adoption and implementation of customer segmentation, marketing predictive models and analytical tools built by the team. Being an advocator and facilitator of the member-centric strategy.
• Assist the Supervisor to partner with various analytics teams across the organization and stay abreast of latest data trends.

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 detail-oriented, with strong data literacy and an eye for identifying data issues.
• Highly collaborative with excellent communication and story-telling skills - a true bridge between data and business.
• 3+ years of analytics experience in marketing data governance, database marketing, campaign management, hypothesis testing and experimental design.
• 3+ years of SQL/SAS 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.

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.

#LI-Hybrid

#LI-DL1