Loyalty & Consumer Insights Analyst

Description : 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

Experience

Skills Technical :

Competencies :