CRM & Loyalty Business Analytics Intern

Description : WHO YOU ARE :

Reporting to the Director, Loyalty, CRM & Customer Insights, the CRM & Loyalty Business Analytics Intern will support with the extraction, manipulation & visualization of business and customer data from our data warehouse and systems, as well as with loyalty and CRM tasks / initiatives.

Responsibilities include, but are not limited to :

• Extract, manipulate, validate & interpret data from our data warehouse and various systems (Google Big Query / SQL server, Microsoft Fabric, Power BI, Braze, Other Cloud Platforms, Google Analytics, Loyalty Platform, …) using mainly SQL language & Power BI to visualize
• Support with reporting and dashboard creation to automate and track metrics and results
• Support when necessary and act as back-up for our loyalty specialist & CRM specialist (campaign creation, QA and post campaign analytics)
• Support the team in A / B testing including pre-test analytics, sizing, and results measurement
• Support with customer level analytics & segmentation strategies
• Provide support on special projects and analytics as needed

WHAT YOU’LL NEED :