Senior Analyst - Retention and Loyalty

Enercare Inc. is one of Canada’s largest home and commercial services companies servicing over one million customers across Ontario, Manitoba, Saskatchewan, Alberta, British Columbia, Quebec and New Brunswick. Enercare is the Experts at Home, operating under several brands including Enercare, HydroSolution, and Pioneer Plumbing & Heating.

A proudly Canadian-owned company, we are the Experts at what we do and deeply care about our customers. We value a diverse, collaborative culture, and take pride in our commitment to health and safety, and knowing our work serves and supports our communities every day. No matter your role, we invest in making sure you have opportunities to grow, learn, and become the Expert you want to be.

If you are ready to become one of our Experts, we would love to hear from you.

Role: Senior Analyst - Retention and Loyalty

Reports to: Senior Marketing Manager, National Acquisition

Location: 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

Enercare is an equal opportunity employer. We are committed to equal employment opportunity regardless of race, colour, ancestry, national origin, religion, sex, age, sexual orientation, gender identity, citizenship, marital status, disability, pregnancy, military status, protected veteran status or other characteristics protected by applicable law. Enercare’s recruitment process includes accommodation for applicants with disabilities in accordance with applicable provincial accessibility laws and regulations. All accommodations will take into account the applicant’s accessibility needs due to disability and are available upon request.

Our company leverages artificial intelligence (AI) tools as part of the candidate screening process to help review applications efficiently and fairly. These tools may assist in evaluating qualifications against job requirements. All decisions regarding hiring are ultimately made by our recruitment team. All roles posted are opportunities we’re actively recruiting for, unless stated otherwise.