Job Description:
Job Summary
The Loyalty Marketing Analyst supports the loyalty analytics team with data driven objectives to drive the growth of the loyalty customer. This role will work closely with the analytics team, but also provide analytical support to the merchandise, marketing, finance, and ecommerce teams. This incumbent will be responsible for the pulling, analyzing, and creating of loyalty reports as well as ad-hoc data pulls and reports from the support teams as needed.
Essential Duties and Responsibilities
Strong understanding of customer sales data and working with large datasets. Understanding of how to cleanse, filter, and query large databases. Required to pull data from Snowflake to support the analytics, marketing, and support teams.
Use a variety of software tools, such as spreadsheets, databases, reporting/analytical software, and graphics packages to assemble, manipulate and format data and reports.
Conduct analysis on customer and campaign data using analytical and statistical tools such as SQL/Python/Dataiku to uncover insights and program recommendations.
Develop and publish reports to measure the performance of the loyalty programs, with the support of the analytics team.
Update and send out top flyer offers & flyer analysis report.
Ability to write complex SQL queries to be able to extract scrubbed, cleaned, usable data to send to the merchandising, finance, marketing, and e-commerce teams.
Data cleansing by removing duplicates and inconsistencies within datasets. As well as transforming raw, unorganized data into accurate, consistent, reliable usable data for analysis.
Support with period end reporting for the business review, helping with data collection & cleansing of the data, including coupon redemptions and segmentation analysis. Help to identify any insights and trends within the data.
Preparing event analyses by gathering required event details from the merch/brand/e-commerce teams, transforming any unstructured raw data into structured data to be able to pull sales and customer metrics for analysis. As well as putting together structured presentation slides on PowerPoint.
Analyzing pet profile data by ensuring data is clean and accurate, scrubbing out any inconsistencies to be able to analyze and provide offer recommendations based on pet profile metrics.
Working with rich loyalty data ensuring data integrity, as well as helping identify any patterns or shifts within the customer segments. Identifying similar look-a-like customers to help with targeted marketing.
Identify data gaps and collaborate with IT and technical teams and make them accessible.
Assist in the development of success benchmarks for Loyalty promotions and develop assessment criteria to refine future promotions.
Ad hoc reports and analysis as needed by the business.
Experience, Education, Certifications
3-5+ years’ experience in corporate retail analyzing data.
B.A. in Business or Marketing.
Experienced and extremely comfortable working with large datasets, query building, scrubbing data, and report creation from various data sources.
Proficiency with SQL and a very strong understanding of databases.
Experience with promotional analytics preparation, pulling data from legacy systems.
Expert knowledge of MS Excel and advanced knowledge of PowerPoint.
Proficient in data analysis and reporting tools.
Understanding & experience with Python and Dataiku.
Experience in automation not but would be ideal.
Strong collaboration, interpersonal, verbal and written communications skills
Ability to work in a dynamic and fast paced environment.
Analytical, strong organization, time management, prioritization, and multi-tasking skills with a high attention to detail.
Knowledge of pet industry an asset