Senior Analyst - Retention and Loyalty

Enercare • Markham, ON

13h • Hybrid

About The Position

Enercare Inc. is seeking a Senior Analyst - Retention and Loyalty to drive data-driven strategies that maximize customer lifetime value and minimize churn. This role involves partnering closely with Product and Marketing teams to deliver actionable insights, trusted reporting, and advanced performance metrics on customer behavior. The ideal candidate will be detail-oriented, technically strong, and experienced in transforming complex data into clear insights through robust reporting solutions.

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 Haves

• 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.

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.

Benefits

• Potential incentive pay
• Opportunities to grow, learn, and become the Expert you want to be
• Accommodation for applicants with disabilities in accordance with applicable provincial accessibility laws and regulations

What This Job Offers

• Job Type: Full-time
• Career Level: Senior