CRM Data Analyst
Group Dynamite
Montréal, QC
Groupe Dynamite is a global fashion retailer with two brands at the heart of its success, Garage and Dynamite. We operate close to 400 stores in Canada and worldwide, and employ over 6,000 people. We have our roots planted firmly in the terrain of fashion’s retail landscape.

As Canadian leaders in the international retail landscape, the Garage and Dynamite banners continue to stand out in an increasingly saturated market. Our passionate team continues to lead the expansion of the business in new markets, including E-commerce, while always leveraging our shared values.

We are proud to hire and retain inspiring leaders, motivated by their desire to achieve great things and recognized for their entrepreneurial spirit.

JOB SUMMARY:
Reporting directly to the Senior Manager, Loyalty and CRM, the CRM Data Analyst will be responsible for the extraction and manipulation of customer data from various systems (Oracle database, SQL Server, Salesforce Marketing Cloud, Loyalty platform, Google Analytics, etc.) to get customer-level insight and influence business decisions. They will support the CRM team in the planning and execution of A/B testing campaigns, statistical analyses, as well as building propensity and forecasting models.

PRIMARY RESPONSIBILITIES:
Extract and manipulate data from various systems (Oracle database, SQL server, Salesforce Marketing Cloud and other Cloud Platforms, Google Analytics, Loyalty and Customer Platforms, etc.) using mainly SQL language;
Support the CRM team in A/B testing including sizing, testing strategy and results measurement:
Support in the establishment of test measurement and sizing processes.
Problem-solve impact sizing methodology and pull necessary data for high-level and test-specific sizing, segmentation, scaling, measurement, etc.
Run statistical analyses for test measurement and communicate impact/learnings of weekly results (statistical significance, pre/post trend analysis, test deep-dives, ad hoc analysis, churn analysis, cohort analysis, etc.).
Query and analyze data to inform ideation, strengthen test hypotheses, identify target segments, including sizing the impact of ideas for prioritization and understand test results.
Propose and execute analytics to identify new and prioritized tests for the backlog.
Provide statistical analyses, build relational models, as well as prediction/forecasting models;
Support with reporting and dashboard creation to automate and track metrics and results;
Visualize output when necessary (Power BI);
Provide support on special projects and analytics as needed.

QUALIFICATIONS:
Education
Bachelor's degree with a focus in statistics, computer science, mathematics or related quantitative field.
Experience
2-5 years experience;
Loyalty program/CRM experience an asset;
Retail experience an asset.
Technical Skills
SQL experience required;
Experience with statistical and data manipulation language (e.g., Python, R, SQL);
Experience working with large data sets to lead to actionable business insights;
Proficiency with Microsoft Office Suite required, including advanced Excel functions;
Power BI an asset.

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 and data mining skills;
Ability to work independently as well as part of a multidisciplinary team

Benefits:
You will be rewarded for your contribution and dedication with a competitive salary and a bonus plan. We also offer a registered retirement savings plan in Canada and a flexible group insurance plan that meets all your needs thanks to personalized coverage, as well as an employee discount in our stores.

Groupe Dynamite is committed to employment equity. Only those candidates who have been retained will be contacted for an interview.