CRM Data Analyst (6 months contract, Flexible Locations)

Company Description

Publicis is an omni-channel communications agency with over 600 employees across our Canadian operations. The office is the largest in our industry in Canada and boasts talent across various disciplines of marketing and advertising expertise. Publicis carries a balanced split of Canadian, U.S. and Global clients for which we are Agency of Record.  Publicis supports a range of D&I actions through our Driving Change team as well as giving back to the community through a long-standing participation in the Out of the Cold Program. With a strong, active and familial culture, Pub United is the agency’s social club, hosting events as wide reaching as Curling, Trivia Nights and more.

Job Description

The CRM Data Analyst is an active member of the Publicis Data & Insights Team. The CRM Data Analyst will be responsible for aggregating, analyzing and providing insights that help monitor, optimize and deliver data driven recommendations to our clients on a regular (weekly, monthly, and quarterly) and ad-hoc basis. This candidate must strive to ensure that the data used in the analytics process is accurate and robust. Candidates must also think strategically to identify issues that need to be optimized or resolved. The CRM Data Analyst will always work proactively to prioritize resources in order to deliver on the tasks.

As CRM Analyst, you will:

• Contribute to analytics projects of varying sizes and complexity, including report automation, data visualization, tool implementation requirements gathering and documentation, split testing, and ad hoc analysis 
• Create and/or maintain dashboards within Qliksense, Data Studio
• Contribute and complete to regular reporting, scorecards, and dashboards (weekly, monthly, quarterly and ad-hoc requests)
• Create complex data models using Qliksense to meet client ad hoc requests
• Drive industry leading insights and recommendation on email, SMS, push campaigns
• Assist with efforts to optimize the client’s CRM business.

Qualifications

You are an ideal candidate for this role if you:

• Think strategically in everything you do
• Are intrinsically-driven and celebrate every success
• Enjoy a variety of work
• Are a logical thinker with creative problem-solving skills
• Set high quality standards for yourself and aim to get every detail right
• Do what it takes to deliver on your commitments
• Enjoy working in a fast-paced, challenging, and rewarding environment
• Welcome and volunteer constructive feedback
• Are able to work within both traditional and agile methodologies/processes
• Thrive in a collaborative work environment that has an “open door” policy since we literally have no doors in our office.
• Are able to maintain constant and effective communication within multidisciplinary project teams
• Believe in continuous learning and improvement

Desired Skills & Experience

• Experience in CRM analytics, ideally within an agency setting
• Experience in writing industry leading insights based on marketing campaign results
• Experience with SQL and structured datasets
• Experience with Braze and/or SFMC
• Experience with structured datasets using SQL, or Python
• Knowledge A/B or multivariate testing and analysis for CRM campaigns
• A big plus if you have had experience with Qliksense or similar data visualization tools.

Additional Information

Publicis Canada is committed to building a diverse workforce representative of our community. We encourage and are pleased to consider all qualified candidates, without regard to race, colour, citizenship, religion, sex, marital / family status, sexual orientation, gender identity, aboriginal status, age, disability or persons who may require an accommodation, to apply.  If you require a specific accommodation please contact Human Resource