Energy Data & BI Analyst — 12-Month Contract

J EllisDon Corporation; Mississauga; On-site; CAD 65,000 - 75,000; Full time

Job summary

EllisDon Corporation in Mississauga is seeking a Business Assurance & Transformation Coordinator for a 12-month contract to turn vast data into actionable reports. You will work with data from multiple sources, delivering clear insights for internal team and clients.

The role requires 2+ years in reporting and analytics, strong Excel, Google Sheets, Power BI, and Power Queries experience, plus a solid grasp of regression analysis.

Qualifications

• 2+ years of reporting and analytics experience.
• Strong analytical skills.
• Experience with Microsoft Excel, Google Sheets, Power BI, Power Queries.
• Strong understanding of regression analysis and ability to interpret and explain data.
• Self-driven and works well in a macro management environment.
• Strong computer skills and familiarity with MS Windows applications and financial management software.

Responsibilities

• Work with massive amounts of information to create reports using data from multiple sources.
• Perform tests to confirm reliability and functionality of system updates and improvements, evaluating processes and suggesting tailored solutions to enhance performance and efficiency of any system that captures data and is used for reporting.
• Provide solutions in written technical reports that meet contractual obligations with clients.
• Provide updates through quarterly and annual meetings to clients and stakeholders where report results are presented.
• Learn about energy metering infrastructure in multiple facilities and perform data auditing and follow-up until resolution.
• Collect data from multiple systems (BAS, BMS, EMS, etc.) to feed reports for external clients.
• Participate in discussions related to energy use and possible solutions to arising situations.
• Initiate and lead business intelligence initiatives to work with data and provide reporting-based solutions for executives.
• Support data collection and analysis for all quality requirements from clients.
• Support internal and external clients with analytic data and templates for recurring reports.

Skills

Reporting & analytics

Analytical thinking

Self-driven

MS Windows

Tools

Power BI

Power Queries

Google Sheets

MS Excel

Job description

EllisDon Corporation in Mississauga is seeking a Business Assurance & Transformation Coordinator for a 12-month contract to turn vast data into actionable reports. You will work with data from multiple sources, delivering clear insights for internal team and clients.

The role requires 2+ years in reporting and analytics, strong Excel, Google Sheets, Power BI, and Power Queries experience, plus a solid grasp of regression analysis.