Business Intelligence Analyst

Metergy Solutions provides submetering and utility billing services for multi-residential and commercial buildings. The Business Intelligence Analyst supports the Strategy and Analytics team by analyzing data and creating reports, dashboards, and visualizations to inform business decisions, while helping ensure data quality and integrity.

Responsibilities

Distill complex data and relationships into clear, concise charts and visualizations, support ad hoc data requests and analysis

Design data models to extract data from operational databases and transform the data to easily understood business views

Gather and process raw data at scale (including writing scripts, web scraping, calling API’s, writing SQL queries, etc.)

Process unstructured data into a form suitable for analysis- then do the analysis

Automate manual processes

Navigate CRM and other systems to build reporting, ensure consistency and compliance across the departments

Develop management monthly KPI’s/reports and BI dashboards for stakeholders across all business functions: technology, operations, field, billing etc

Perform in-depth analysis to identify key business risks and opportunities and make recommendations to improve overall profitability

Preferred

Experienced with BI Tools such as Power BI / Tableau / SAP (Power BI Preferred)

Creativity, relationship building skills and dedication are all highly desirable

Business Intelligence Tools

Tableau

SAP

Creativity

Relationship Building

Dedication

Benefits

Excellent health coverage and life insurance benefits – no waiting period!

Company-paid Long-Term Disability and Basic Life Coverage

Flexible Spending Account (FSA) options

401K plan with immediate company match

Generous Paid Time Off Plan plus 10 paid holidays

Summer hours to enjoy the weather

Regular Social events - happy hours, summer & holiday parties, & more

Hybrid work arrangement

Company

Full-service submetering provider for buildings

Markham, Ontario, CAN

https://www.metergysolutions.com/

Founded in 2005

201-500 employees

Qualifications

Bachelor's degree in Comp Sci/ MIS/ Data Analytics/ Math or Statistics (or any analytical/data driven discipline)

0-2 years of experience working within business intelligence (Co-op/Internships included)

High Proficiency in data modelling and analysis with demonstrated acumen using the following tools Excel, PowerBI, Python & SQL

Strong SQL experience is a must with knowledge of relational databases, and ability to build and maintain views

Meticulous attention to detail and commitment to accuracy

Data driven analytical skills, knowledge and/or experience related to financial analysis

Excellent problem-solving skills, with a proactive approach to addressing challenges

Ability to prioritize and adapt to changing demands and deadlines, are essential

Ability to conduct basic statistical and correlation analysis to identify patterns and trends

Excellent skills in Excel, R/Python, SQL

Experienced with BI Tools such as Power BI / Tableau / SAP (Power BI Preferred)

Creativity, relationship building skills and dedication are all highly desirable

Required skills

SQL, Power BI, Excel, Python, Data Modeling, Financial Analysis, Statistical Analysis, Relational Databases, Tableau, SAP

Experience

Entry level