Business Analyst

Enercare Inc.; Markham; On-site; CAD 69,000 - 111,000; Full time

Job summary

Enercare Inc. is seeking a motivated Business & Data Analyst in Markham to support data-driven decision making. You will collect, analyze, and visualize data to uncover insights and drive operational efficiency, working with senior analysts and stakeholders.

The role emphasizes building dashboards in Power BI, SQL data handling in Azure SQL DB, and collaboration across teams to improve reporting, forecasting, and financial analyses. A strong analytical mindset and learning attitude are essential.

Qualifications

• 3–5 years hands-on experience using Microsoft BI stack with focus on Power BI.
• Working knowledge of SQL and Azure data platforms.
• Experience in modelling and data visualization; working with different schemas.
• Proficiency in Excel (pivot tables, formulas, charts).
• Strong attention to detail and analytical thinking; good communication.

Responsibilities

• Assist in gathering, validating, and organizing data from various sources including Azure SQL and Excel.
• Conduct basic data analysis to identify trends and anomalies in business operations.
• Ensure data accuracy in reports and dashboards.
• Develop and maintain SQL databases to support reporting requirements.
• Lead the development of dashboards and KPI scorecards using Power BI.
• Create user-friendly reports to communicate insights to business users.
• Help maintain reporting tools and templates; assist in financial/operational reports.

Skills

Attention to detail

Analytical thinking

Communication

Team collaboration

Eagerness to learn

Education

Post-secondary education in Business/Data Analytics/CS or related field

Tools

Power BI

SQL

Azure SQL DB

Excel

Logic Apps

Function Apps

API Management

DAX

Job description

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.

Role: Business Analyst
Status: Regular, Full Time
Reports to: Senior Manager, Business Markets Strategy and Analytic
Department: Builder Division
Location: Markham
Compensation: $69,136 - $110,618
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. Summary: We are seeking a motivated and detail-oriented Business & Data Analyst to join our team. This role is ideal for someone early in their analytics career who is eager to learn and contribute to data-driven decision-making, reporting, and process improvement initiatives. You will support senior analysts and business stakeholders by collecting, analyzing, and visualizing data to uncover insights and drive operational efficiency.

Responsibilities

• Assist in gathering, validating, and organizing data from various sources including Azure SQL databases and Excel
• Conduct basic data analysis to identify trends, patterns, and anomalies in business operations
• Ensure data accuracy and completeness in reports and dashboards
• Develop and maintain SQL databases to supporting reporting requirements
• Lead the development of dashboards and KPI scorecards using Power BI
• Create visually engaging and user-friendly reports to communicate insights to business users
• Help maintain and update existing reporting tools and templates
• Assist in preparing financial and operational reports, including cost analysis and forecasting
• Contribute to the development of simple financial models under guidance
• Participate in evaluating business needs and identifying opportunities for data-driven improvements
• Support preparation of month end deliverables to Finance and understanding the key business drivers to explain variances and anomalies
• Document current workflows and identify inefficiencies through data and stakeholder input
• Support small-scale process improvement initiatives and automation efforts
• Apply design-thinking and user-focused approaches to improve data usability and accessibility
• Communicate findings clearly to both technical and non-technical stakeholders
• Continuously develop skills in SQL, Power BI, and data modeling
• Learn from senior team members and participate in training and mentorship opportunities

Qualifications

• Post-secondary education in Business, Data Analytics, Computer Science, or a related field (or equivalent experience)
• 3-5 years hands on experience using Microsoft Business Intelligence Stack with primary focus on Power BI
• Working knowledge of SQL and experience working with databases, warehouses and data lakes in Azure SQL DB
• Integration environment, incl. utilization in Logic Apps, Function Apps, Functions, and API Management.
• Knowledge of DAX (Data Analysis Expressions) is a must.
• Experience in modelling and data visualization; working with different data schemas and BI implementation methodologies.
• Proficiency in Microsoft Excel (pivot tables, formulas, charts, graphs)
• Strong attention to detail and analytical thinking
• Good communication and collaboration skills
• Eagerness to learn and grow in a fast-paced, data-driven environment

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.