Junior CRM Data Analyst

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.

Overview

The Junior CRM Data Analyst is an active member of the Publicis Data & Insights Team. The Junior 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 Analyst will always work proactively to prioritize resources to deliver on the tasks. In addition, it is important for the CRM Analyst to have attention to detail and to validate data that is questionable for accuracy and to help address “the why” to support any recommendations to clients, in collaboration with the CRM Analytics Manager and Director.

Responsibilities

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 data visualization tools such as Data Studio, Tableau, Amplitude.  

Contribute and complete to regular reporting, scorecards, and dashboards (weekly, monthly, quarterly and ad-hoc requests) based on the needs of the client.  

Support industry leading insights and recommendation on email, SMS, and Push campaigns.  

Assist with efforts to optimize the client’s business by providing strategic recommendations, based on the insights. You don’t simply provide the numbers but tell a data-driven story.

Qualifications

You are an ideal candidate for this role if you: 

• You’re an excellent communicator regarding the status of your reports with the Project Managers. 
• You have attention to detail in your analysis and will question numbers from the data source and take initiative to validate through internal resources. You will thoroughly QA your work before sending your reports to other team members or the client and will seek guidance on any areas that seek clarification.  
• Having a can-do attitude (being a roll up your sleeves kind of person) and bringing positivity to the workplace is of great importance to our team. We pride ourselves on being positive and having a growth mindset and it’s important for team members to embody those qualities for the success of the department.  
• 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 

• Candidate has 1-year experience and/or can demonstrate the following skills through project work having managed CRM analytics, ideally within an agency setting.  
• Experience writing insights based on marketing campaign results.  
• Worked on a project/conducted an analysis having used platforms such as: SFMC, MoEngage or Amplitude.  
• Basic understanding of structured datasets – i.e. SQL and programming languages like Python.  
• Experience working with Data Visualization tools such as Google Studio or Tableau. 
• Knowledge A/B or multivariate testing and analysis for CRM campaigns.  
• Undergraduate Degree (Marketing, Business, Statistics, Analysis, or other related degrees considered an asset).  

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