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 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 and/or or whatever the business requires.
This role will focus on 2 accounts, where B2C & B2B analysis experience is needed within large organizations. This candidate will work together with CRM Strategy and Client Services, using data to inform decision-making in program strategies.
This candidate must 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 work proactively to prioritize their tasks based on the client’s needs. 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 Strategy.
Responsibilities
- Optimize the client’s CRM business by providing strategic recommendations, based on the insights. You don’t simply provide the numbers but tell a data-driven story and will be required to present to clients.
- Be comfortable collaborating with and presenting to Senior clients across the organization. Being quick on your feet to answer any questions related to the data is key.
- Lead analytics projects of varying sizes and complexity, including report automation, data visualization, tool implementation requirements gathering and documentation, split testing, and ad hoc analysis, as required by the client. Outputs could include regular reporting, scorecards, and dashboards (weekly, monthly, quarterly and ad-hoc requests) based on the needs of the client.
- Create data models to meet client ad hoc requests.
- Create and/or maintain dashboards within Power BI or Tableau.
- Drive industry leading insights and recommendation on email campaigns.
Qualifications
- CRM analytics, ideally within an agency setting.
- Experience using insights to make recommendations to clients on how to optimize their business.
- In writing industry leading insights based on marketing campaign results.
- Working with SFMC (being certified is a bonus).
- Experience with SQL/ Python and structured datasets.
- Working with Data Visualization tools such as Power BI, or Tableau.
- Advanced Excel & PPT.
Knowledge A/B or multivariate testing and analysis for CRM campaigns
Additional information
AI Use
We use artificial intelligence (AI) tools to support parts of our hiring process, such as reviewing applications or analyzing resumes. These tools assist our recruitment team but never replace human decision-making. We believe in a human-first approach, where your experience and potential are recognized by people.
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.
