Overview Energ… including Enercare, HydroSolution, and Pioneer Plumbing & Heating. Company Culture A proudly Canadian-owned company … grow, learn, 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 Manager, Marketing Analytics Location Markham, ON (Hybrid – 4 days in office) Employment Type Full-Time Compensation $74,817 - $118,211 (base salary plus potential incentive pay) 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. Equal Employment Opportunity Statement 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. #J-18808-Ljbffr