Marketing Database Analyst

**About Us**:
We are looking for a Consultant Marketing Analytics & Insights to join our Marketing Analytics and Insights team for a period of 15 months. This role will provide campaign and consulting services to serve marketing lines of business (LOB) and other functional areas achieve their business objectives including acquisition, retention, sales, customer engagement. We regret that those without SAS and SQL experience will not be considered for the role.

**Who we are**:
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 two-million Members requires high performing, forward thinking, and innovative people who work collaboratively to keep propelling our business forward. Life at CAA Club Group is fast paced, performance-driven and rewarding. We value our Associates' career growth and ongoing professional development
- and we regularly recognize their achievements and outstanding results. CAA Club Group (CCG) is known for providing stellar emergency roadside assistance to our motoring Members and non-Members. We work hard and play hard. We're about doing what's right and feeling good about it.

**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 Unit Manager 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 Unit Manager to partner with various analytics teams across the organization and stay abreast of latest data trends.

**Who You Are**:

- Bachelor’s degree in Mathematics, Statistics, Analytics, Engineering or Commerce.
- 5+ years of analytics experience in database marketing, marketing data governance, campaign management, hypothesis testing and experimental design.
- 5+ years of marketing analytics experience in retail, travel, insurance, CRM or loyalty.
- SAS Certified Advanced Programmer (SAS 9).
- 5+ years of SAS/SQL programming with large database.
- Highly collaborative with excellent communication and story-telling skills - a true bridge between data and business.
- 5+ years of BI reporting and visualization tools such as Microsoft Power BI or Tableau.
- Knowledge of predictive modeling 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.