Data-Driven Business Analyst | Power BI & SQL

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

Job summary

A leading home and commercial services company is seeking a detail-oriented Business Analyst to support data-driven decision-making processes. The ideal candidate will assist in gathering and analyzing data from various sources, develop dashboards using Power BI, and maintain SQL databases. Candidates should have 3-5 years of experience with a strong focus on Power BI and SQL. This is a full-time role based in Markham, offering competitive compensation between $69,136 and $110,618.

Qualifications

• 3-5 years hands-on experience using Microsoft Business Intelligence Stack.
• Working knowledge of SQL and experience with Azure SQL databases.
• Strong proficiency in Microsoft Excel, including pivot tables and formulas.

Responsibilities

• Assist in gathering, validating, and organizing data from various sources.
• Conduct data analysis to identify trends and anomalies.
• Develop dashboards and KPI scorecards using Power BI.

Skills

Microsoft Business Intelligence Stack

Power BI

SQL

Excel

Data Analysis Expressions (DAX)

Analytical thinking

Communication skills

Collaboration skills

Education

Post-secondary education in Business or Data Analytics

Tools

Azure SQL

Power BI

Job description

A leading home and commercial services company is seeking a detail-oriented Business Analyst to support data-driven decision-making processes. The ideal candidate will assist in gathering and analyzing data from various sources, develop dashboards using Power BI, and maintain SQL databases. Candidates should have 3-5 years of experience with a strong focus on Power BI and SQL. This is a full-time role based in Markham, offering competitive compensation between $69,136 and $110,618.