Senior Analyst and Data Strategy and Analytics

Enercare Inc.; Markham; On-site; CAD 74,000 - 119,000; Full time

Job summary

A Canadian home services company is looking for a Data Strategy & Analytics expert with over 5 years of experience in databases and Power BI. This role emphasizes data quality and integrations using Azure tools. The ideal candidate possesses strong analytical and communication skills, with a proven track record in developing high-quality datasets and visualizations. Competitive compensation between $74,817 and $118,211 annually.

Qualifications

• At least 5 years of experience with databases and data lakes in Azure SQL DB.
• Proven experience with SQL language.
• 3-5 years using Microsoft Business Intelligence Stack with a focus on Power BI.
• Knowledge of DAX is a must.

Responsibilities

• Develop high-quality datasets and dashboards in Power BI.
• Optimize Power BI reports for performance.
• Develop scripts to automate resource deployment in Azure Databricks.

Skills

Advanced analytics experience

Excellent communication skills

Good business acumen

Change leadership

Tools

Power BI

SQL

Azure SQL DB

DAX

Logic Apps

Snowflake Schema

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. If you are ready to become one of our Experts, we would love to hear from you.

Summary

Reporting to Senior Manager, Data Strategy & Analytics, you will play a key role in a highly visible team within the organization to advance our business as we execute our data strategy. This is a great opportunity for an individual with a passion for using data to drive insights, presenting key learnings and delivering transformational outcomes to our business.

You are an inquisitive and intellectually curious individual with advanced analytics experience, excellent communications skills, good business acumen and effective change leadership. With an agile-mindset, you are obsessed with data quality and pragmatic algorithms, have a passion for understanding and integrating business semantics into technology solutions and enjoy learning our business and operations with a go-and-see mindset.

Accountabilities

• Develop high-quality datasets and visually stunning dashboards, reports and KPI Scorecards in Power BI
• Hands-on experience working with Calculation Groups, time intelligence functions, multidimensional models and core principles of Data Visualizations
• Knowledge of DAX, Power Query & Power Automate
• Experience developing Paginated Power BI reports
• Develop scripts to automate the deployment of resource stacks and associated configurations in Azure Databricks workspace; schedule daily jobs and store procedures
• Optimize Power BI reports and dashboards for performance and responsiveness considering large datasets and systems interdependencies
• Develop queries and data visualizations for ad-hoc, recurring, troubleshooting requests and projects. Create exploratory data analysis, reports, and dashboards in Power BI to surface data for different stakeholders/user groups
• Have an open mind and a knack to collaborate effectively across internal and external partners to further capitalize on data assets
• Have a passion for understanding and integrating business semantics into technology solutions

Qualifications

• At least 5 years hands on experience working with databases, warehouses and data lakes in Azure SQL DB
• At least 5 years proven experience working with SQL language
• 3-5 years hands on experience using Microsoft Business Intelligence Stack with primary focus on Power BI
• Working knowledge of Snowflake Schema and its usage in Power BI
• At least 2+ years of experience in developing integrations using Microsoft’s Azure Application Integration environment. Including utilization in Logic Apps, Function Apps, Functions, Service Bus, and API Management
• Knowledge of DAX is a must
• Experience in modelling and data visualization; working with different data schemas and BI implementation methodologies

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.

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.