Business Analyst

Enercare Inc.; Markham; On-site; CAD 70,000 - 90,000; Full time

Job summary

A Canadian service provider in Markham is seeking a motivated Business Analyst to support data-driven decision-making. The ideal candidate has 3-5 years of experience using Power BI and SQL, with a strong analytical mindset. Responsibilities include data collection, analysis, and reporting, collaborating with teams to improve business processes. This full-time position offers a path for career growth in a dynamic environment.

Qualifications

• 3-5 years experience with Microsoft Business Intelligence Stack focused on Power BI.
• Working knowledge of SQL and databases.
• Experience in data visualization and modeling.

Responsibilities

• Assist in data collection and analysis from various sources.
• Lead the development of dashboards and KPI scorecards.
• Support financial reporting and forecasting.
• Document workflows and identify process inefficiencies.
• Collaborate with business teams on data needs.
• Continuously develop skills in SQL, Power BI, and data modeling.

Skills

Data Analysis

Power BI

SQL

Microsoft Excel

Communication

Education

Post-secondary education in Business, Data Analytics, Computer Science

Tools

Power BI

Azure SQL DB

Excel

Job description

Proudly Canadian-owned, Enercare is committed to providing the best services, solutions and advice to make customer’s homes as comfortable as they can be. With Enercare Advantage, we provide affordable clean air and water solutions for homes and workplaces. We are committed to operating in an environmentally responsible way, including keeping as much waste out of landfills as possible, and giving back to the communities where we live and work. Enercare is about putting people first by listening to our customers, continuous improvement and making our organization a destination for building people’s careers.

Role: Business Analyst
Status: Full Time, Regular
Reports to: Senior Manager, Business Markets Strategy and Analytics
Department: Builder Division
Location: Markham

Overview

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.

Key Responsibilities

• Data Collection & Analysis: 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

• Reporting & Visualization: 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

• Business & Financial Support: 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

• Process Improvement & Optimization: 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

• Stakeholder Collaboration: Work closely with business teams to understand reporting and data needs; Communicate findings clearly to both technical and non-technical stakeholders; Help promote the use of data and Power BI tools across the organization

• Learning & Development: Continuously develop skills in SQL, Power BI, and data modeling; Stay informed about new tools and best practices in data analysis and visualization; 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.