Marketing Database Analyst

1 month ago


Thornhill, Canada CAA Club Group Full time

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



  • Thornhill, Canada Partners in Credit Inc Full time

    **Primary Objectives** **Specific Responsibilities** - Developing SQL queries, SSIS/ETL Reporting. - Error handling in SQL Server - Responsible for data Imports from one platform to another and data exports - Research internal data issues and questions - Proven experience in conducting analytical support in large data warehouses - Creating advanced SQL...

  • Marketing Coordinator

    1 month ago


    Thornhill, Canada Aaron One Realty Inc Full time

    Education: College/CEGEP - Experience: 1 year to less than 2 years **Tasks**: - Plan development projects - Respond to enquiries from members of the business community concerning development opportunities - Conduct comparative research on marketing strategies for industrial and commercial products - Advise clients on advertising or sales promotion...


  • Thornhill, Canada Sora Clothing Full time

    Education: College/CEGEP - Experience: 1 year to less than 2 years - or equivalent experience **Tasks**: - Assist in the preparation of brochures, reports, newsletters and other material - Develop and organize workshops, meetings, ceremonies and other events for publicity, fundraising and information purposes - Develop, implement and evaluate communication...


  • Thornhill, Canada AECOM Full time

    Company Description At AECOM, we’re delivering a better world. We believe infrastructure creates opportunity for everyone. Whether it’s improving your commute, keeping the lights on, providing access to clean water or transforming skylines, our work helps people and communities thrive. Our clients trust us to bring together the best people, ideas,...


  • Thornhill, Canada AECOM Full time

    Company Description **At AECOM, we’re delivering a better world.** We believe infrastructure creates opportunity for everyone. Whether it’s improving your commute, keeping the lights on, providing access to clean water or transforming skylines, our work helps people and communities thrive. Our clients trust us to bring together the best people, ideas,...

  • Jd Edwards

    4 weeks ago


    Thornhill, Canada Black & McDonald Limited Full time

    **Position **:JDE Analyst **Location **:Markham, ON **Work Structure **:Permanent, full-time hours, hybrid (3 days in office, 2 days at home) **Position Summary** The JD Edwards Analyst provides analytical and technical expertise in implementing, designing, developing, supporting and/or analyzing solutions for customers through business and technical...


  • Thornhill, Canada Accencis Group Full time

    The Accencis Group is a collection of successful and well-established dining establishments located in major cities across Canada, including: The Captain’s Boil, %Arabica, Midori, and Dear Saigon. We differentiate ourselves from other restaurant groups by our commitment to offering unique and innovative dining experiences to our guests. We have a diverse...

  • Social Media Manager

    1 month ago


    Thornhill, Canada Sora Clothing Full time

    Education: College/CEGEP - Experience: 1 year to less than 2 years - Communication, general - Graphic design - Marketing, other - or equivalent experience **Tasks**: - Develop promotional materials - Market business services - Assist in product development and direct and evaluate the marketing strategies of establishments - Plan, direct and evaluate the...


  • Thornhill, Canada Clearoute Inc. Full time

    Education: Bachelor's degree - Experience: 2 years to less than 3 years - or equivalent experience **Asset languages**: - Arabic **Work setting**: - Consulting firm - Advertising, marketing and public relations agency **Tasks**: - Conduct online marketing, E-commerce and Website promotions - Develop marketing strategies - Identify and assess potential...

  • Retail Buyer

    2 days ago


    Thornhill, Canada Sapere Aude Inc. Full time

    Work Term: Permanent - Work Language: English - Hours: 30 to 44 hours per week - Education: Bachelor's degree - Experience: 7 months to less than 1 year - or equivalent experience **Work setting**: - Retail business **Tasks**: - Study market reports, trade periodicals and sales promotion materials - Arrange product according to planogram - Establish and...


  • Thornhill, Canada CAA Club Group Full time

    **About Us**: CCG is looking for an experience IT Development Manager with 10+ years’ experience. **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...


  • Thornhill, Canada Grainger Canada Full time

    : **KEY DUTIES AND RESPONSIBILITIES**: - Collaborate with suppliers and internal partners to identify and implement opportunities to effectively resolve issues and maintain healthy product flow into Grainger's network and direct to customer - Mitigate risk to Grainger's business and customers by quickly identifying and effectively acting to resolve Supply...


  • Thornhill, Canada Grainger Canada Full time

    : **KEY DUTIES AND RESPONSIBILITIES**: - Collaborate with suppliers and internal partners to identify and implement opportunities to effectively resolve issues and maintain healthy product flow into Grainger's network and direct to customer - Mitigate risk to Grainger's business and customers by quickly identifying and effectively acting to resolve Supply...


  • Thornhill, Canada Bank of China(Canada) Full time

    **Job Summary**: Assist Internal Control and Compliance manager for the 1st defence line duty, handle information technology related duty, and business management function. **Key Responsibilities**: 1. Responsible for leading and driving the digitalization of financial market business, including but not limited to trading system upgrades and transformation...

  • Compliance Analyst

    1 week ago


    Thornhill, Canada Bank of China(Canada) Full time

    apply**Job Summary**: Assist Internal Control and Compliance manager for the 1st defence line duty, handle information technology-related duty, and business management function. **Key Responsibilities**: - Manage RCM program planning, execution, reviewing, conducting, testing, reporting and documentation; - Perform gap analysis to new/amended regulations,...


  • Thornhill, Canada Clearoute Inc Full time

    **About Us** Clearoute Inc. is a professional services company that helps businesses grow through various offerings, including branding, marketing, web development, and consulting. We have been in the industry for over 25 years, establishing ourselves as a trusted growth partner. We pride ourselves on innovative solutioning, effective communication, and...

  • Manager, Investments

    1 month ago


    Thornhill, Canada CAA Club Group Full time

    **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.4M+ Members requires high-performing, forward-thinking, and innovative people who work collaboratively to keep propelling our business forward. Reporting...


  • Thornhill, Canada ACCES Employment Full time

    **Employment Consultant** **Program: Employment Services** **(2 vacancies)** **Location: Mainly in Markham with possible 1x week responsibilities in Newmarket** **Contract length: 1-Year Contract with Opportunities for Extension** **ACCES Employment** is a leader in connecting qualified jobseekers from diverse backgrounds with employers across the Greater...


  • Thornhill, Canada Galderma Full time

    With a unique legacy in dermatology as well as decades of cutting-edge innovation, Galderma is the pure-play dermatology category leader, present in approximately 90 countries. We deliver an innovative, science-based portfolio of premium flagship brands and services that spans the full spectrum of the fast-growing dermatology market through Injectable...

  • Customer Data Analyst

    5 hours ago


    Thornhill, Canada Grainger Full time

    **Please note: This is a hybrid position with 3 days a week in the office in Thornhill, Ontario (Canada)** **Position Objective**: The primary purpose of this position is to analyze Customer Pricing Contracts and product files, initiate contract renewals and provide suggested pricing for new business opportunities. This role will impact the decisions made...