Loyalty & Consumer Insights Analyst

WHO YOU ARE:

Reporting to the Loyalty & CRM Director, the Loyalty & Consumer Insights Analyst will be responsible for the extraction, manipulation & interpretation of customer data from our data warehouse as well as various systems (Oracle database, SQL Server, Salesforce Marketing Cloud, Loyalty platform, Google Analytics, …). They will be critical in helping to build a customer and data centric culture, with the objective of delivering actionable customer-level insights (customer journey, lifecycle & LTV, churn / retention, segmentation/clustering, …) to improve business decisions and increase customer lifetime value.

Responsibilities include, but are not limited to:

• Extract, manipulate & interpret data from our data warehouse and various systems (Oracle database, SQL server, Salesforce marketing cloud, Other Cloud Platforms, Google Analytics, Loyalty Platform, …) using mainly SQL language
• Ideate, plan, execute, analyze & present (storytelling) insights from customer level analytics to our internal stakeholders: acquisition, customer lifecycle, retention/ churn analysis, cohort analysis, customer journeys, segmentation / clusters, geographical analysis, store / online shopper, etc…
• Support with reporting and dashboard creation to automate, track and visualize metrics and results
• Support with additional business analytics and insights including loyalty program performance, digital performance, consumer survey results, etc …
• Ongoing QA & validation of the data being used in reports and analyses (with source systems), as well as the insights being derived to ensure accuracy and reliability
• Participate in the ongoing maintenance and improvement of the data warehouse, including data cleansing and ensuring data accuracy (collaborate with IT/3rd party when necessary)
• Provide support on special projects and analytics as needed

WHAT YOU’LL NEED:

Education

• Bachelors degree with a focus in statistics, computer science, or mathematics or related quantitative field

Experience

• 2-5 years experience as an analyst (analysis, data extraction/manipulation, insights)
• Loyalty program / customer insights experience an asset
• Retail experience an asset

Skills Technical:

• Experience with statistical and data manipulation language (strong SQL required)
• Experience working with and analyzing large data sets to deliver actionable business insights
• Proficiency with Microsoft Office Suite required, including advanced Excel functions
• Experience translating data and insights into a simple and visualized story/presentation (Google data studio, slides, powerpoint)

Competencies:

• Bilingual (French and English)
• Strong understanding of database structures
• Adept and proactive problem solver
• Strong organizational skills
• High attention to detail and commitment to high quality work
• Strong analytical & data mining skills
• Strong communication skills (presenting + visualizing)
• Ability to work independently as well as part of a multi-disciplinary team