Senior Analyst - Retention and Loyalty

Role: Senior Analyst - Retention and Loyalty Reports to: Manager, Marketing AnalyticsLocation: Markham, ON (Hybrid – 4 days in office)Employment Type: Full-Time Compensation:  $74,817 - $118,211  Please note that the compensation range listed includes base salary and potential incentive pay. Incentives such as bonuses are not guaranteed and depend on individual performance and company results. Actual compensation within the range will be determined based on skills, experience, and qualifications.   Job Summary We are seeking a Senior Analyst - Retention and Loyalty to drive data-driven strategies that maximize customer lifetime value and minimize churn. You will partner closely with Product and Marketing teams to deliver actionable insights, trusted reporting, and advanced performance metrics on customer behavior. The ideal candidate is detail-oriented, technically strong, and experienced in transforming complex data into clear insights through robust reporting solutions.   Key Responsibilities Analyze customer retention, churn, and loyalty program performance to identify growth opportunities. Develop, maintain, and automate recurring reports and dashboards to support marketing, product teams, and a broader stakeholder audience Translate business and reporting requirements into well-structured analytical datasets and metrics Use SQL and Python to extract, transform, and analyze large datasets Leverage Excel, Power Query, and Power Pivot for advanced analytics and ad hoc reporting Build and optimize Power BI reports and dashboards for performance, usability, and scalability Perform data validation, reconciliation, and quality checks to ensure data accuracy and consistency Design and maintain efficient data models that follow best practices Document definitions, assumptions, and reporting logic to enable transparency and reuse Partner with cross‑functional teams to drive improvements in data pipelines, reporting foundations, and overall analytics enablement   Skills & Technical Requirements Bachelor’s degree in Data Analytics, Computer Science, Statistics, Business, or a related field 3+ years of experience in an enterprise data analyst, business intelligence, or analytics role Strong SQL proficiency supporting ETL workflows for querying, transforming, validating, and ensuring data quality across pipelines Advanced Excel skills, including Power Query and Power Pivot Python/PySpark experience for data analysis, automation, and analytics workflows Hands-on experience with Power BI or similar applications Understanding of data modeling methodologies (e.g., star schema, snowflake, fact/dimension modeling) Familiarity with enterprise reporting standards and KPI frameworks Ability to communicate insights effectively to both technical and non-technical stakeholders High attention to detail and data accuracy Ability to manage competing priorities in a fast-paced environment   Nice-to-Have Qualifications Experience with Microsoft Fabric environment Experience supporting retention, loyalty, or customer lifecycle analytics Understanding of AI‑ready data modeling concepts to support automation, advanced analytics, and future AI initiatives