Energy & Sustainability Data Analyst Ii

3 months ago


Ottawa, Canada BGIS Full time

**SUMMARY**

The Energy & Sustainability Data Analyst II is responsible for compiling and managing client data on GHG reduction initiatives and other defined Sustainability objectives as required. The Analyst is responsible for data reporting, insight development, recommendations to improve data quality and implementation of these as required. Communicating key insights and information succinctly in simple ways is required with many concerned parties throughout both BGIS and our client’s organization. Finally, the Analyst supports the reporting on Energy & Sustainability related client Key Performance Indicators (KPIs).

**KEY DUTIES AND RESPONSIBILITIES**

The Energy & Sustainability Data Analyst II will provide training and support to Energy & Sustainability Data Analysts for them to be able to perform their tasks adequately and meet key deadlines for various deliverables.

**Reporting and Analysis**
- Utilizes programming and analytical tools, including Microsoft Power BI, VBA, Tableau, or similar relational database tools to formulate models and/or extract insights. Well versed in knowledge of creating algorithms, identifying patterns and insights from structured and unstructured data sets utilizing graphs, trees and/or other data representation techniques as required.
- Performs trend analysis, insights, and outlier identification of energy-related data.
- Supports ongoing review of data from multiple energy, project, sustainability, operations, and environment team sources to ensure ongoing data integrity.
- Develops data structures and pipelines to organize, collect, cleanse, and standardize data to generate insights and addresses reporting needs.
- Supports the reporting on GHG-related client KPIs.
- Defines data requirements and gathers and validates information, using judgment and statistical tests.
- Identifies and troubleshoots data integration and integrity issues in cooperation with the appropriate business units.
- Performs ad-hoc, strategic analysis of structured and unstructured data across multiple data sources, reflecting project costs, GHG savings and utility related data.
- Organizes data and ongoing preparation and development of various sustainability focused reports as needed including but not limited to water, waste, and energy metrics.

**Teamwork and Collaboration**
- Works with internal BGIS team members & PSPC key contacts to coordinate data management, sharing and integration.
- Supports energy team members in the development and design of new tools, databases and process for energy and project management, specifically the Power BI Utility Dashboard.
- Supports operation teams in providing reports to fulfill project, compliance, and contractual requirements., Other Duties as Required.

**KNOWLEDGE AND SKILLS**
- University degree in computer science, math, engineering, data science, or related.
- Equivalent or similar college diploma with significant job experience will also be considered.
- 3 to 5 years of Data Analyst experience is mandatory.
- Management and organization of large data sets using Microsoft Excel based software.
- Ability to identify and troubleshoot data integration and integrity issues in cooperation with the appropriate business units.
- VBA knowledge, database and programming knowledge.
- Advanced to expert proficiency level with Microsoft Excel.
- Advanced skills with visualization software (Microsoft Power BI, Tableau) and use of DAX (Data Analysis Expressions).
- Strong communication and interpersonal skills with the ability to work independently and within a team environment.
- Strong administrative skills including documentation standards.
- Knowledge of facility management services would be beneficial.
- Demonstrated ability to function efficiently under pressure with constantly changing priorities and deadlines.

Licenses and/or Professional Accreditation

None required.



  • Ottawa, Ontario, Canada Federation of Canadian Municipalities Full time

    Sustainability Energy Analyst at the Federation of Canadian Municipalities, this position focuses on promoting energy efficiency and sustainability initiatives within Canadian municipalities. This role is ideal for candidates with a Bachelor's Degree in fields such as mechanical engineering or building sciences. The Federation of Canadian Municipalities...


  • Ottawa, Ontario, Canada Federation of Canadian Municipalities Full time

    Job Overview: Sustainability Energy Analyst at Federation of Canadian Municipalities focuses on enhancing energy efficiency initiatives within municipal frameworks. This position is designed for candidates located in Hybrid work in Ottawa, ON , Canada, and requires a minimum educational qualification of a Bachelor’s Degree . Key Responsibilities: ...


  • Ottawa, Canada BGIS Full time

    **Who We Are** **SUMMARY** The Energy & Sustainability Manager is responsible for the strategic development and management of energy & sustainability information system processes, analytical activities, day-to-day performance reporting, and the continuing development of Sustainability metrics. Within the current setting of heightened environmental...

  • Lead Energy Analyst

    1 month ago


    Ottawa, Ontario, Canada Stantec Full time

    Lead Energy Analyst Overview: At Stantec, our commitment to enhancing the built environment is driven by a deep understanding of the communities we serve. We believe that the spaces we create should not only be functional but also resonate with the people who inhabit them. Role Summary: As a Lead Energy Analyst, you will play a pivotal role in our energy...


  • Ottawa, Canada Ottawa Community Housing Full time

    **Who we are**: Ottawa Community Housing Corporation (OCHC) is the largest community housing provider in Ottawa and the second largest in Ontario. We are a non-profit organization providing social and affordable housing to more than 32,000 tenants within various communities. We aim to be a leader at providing safe and affordable homes to tenants in our...

  • Energy Analyst

    3 months ago


    Ottawa, Canada BGIS Full time

    **SUMMARY** The Energy Analyst is an entry level post responsible for providing reporting and analytical support encompassing utility management, energy & sustainability reporting metrics and client key performance indicators. **KEY DUTIES & RESPONSIBILITIES** Energy & Sustainability Reporting - Prepares standard energy and sustainability reporting and...


  • Ottawa, Canada Morguard Full time

    Morguard is looking for a Analyst, Sustainability to join our team at the Ottawa Regional Office. This position will support the Regional Manager, Environmental, Health & Safety, and Security, and work directly with the Property Management teams on sustainability data analytics, initiatives, performance reporting, program implementation, special projects,...


  • Ottawa, Ontario, Canada Natural Resources Canada (NRCan) Full time

    Job Title: Director of Sustainability and EnergyAt Natural Resources Canada (NRCan), we are seeking a highly skilled and experienced professional to lead our efforts in sustainability and energy management. As the Director of Sustainability and Energy, you will be responsible for directing the work of multi-disciplinary research teams targeting different...


  • Ottawa, Ontario, Canada Natural Resources Canada (NRCan) Full time

    Job Title: Director of Sustainability and EnergyAt Natural Resources Canada (NRCan), we are seeking a highly skilled and experienced professional to lead our efforts in sustainability and energy management. As the Director of Sustainability and Energy, you will be responsible for directing the work of multi-disciplinary research teams targeting different...


  • Ottawa, Ontario, Canada Employment and Social Development Canada Full time

    Job Title: Director - Environmental Sustainability and EnergyEmployment and Social Development Canada is seeking a highly skilled and experienced professional to fill the role of Director - Environmental Sustainability and Energy. This position is a key part of our organization's commitment to sustainability and energy efficiency.About the Role:The Director...


  • Ottawa, Ontario, Canada Employment and Social Development Canada Full time

    Job Title: Director - Environmental Sustainability and EnergyEmployment and Social Development Canada is seeking a highly skilled and experienced professional to fill the role of Director - Environmental Sustainability and Energy. This position is a key part of our organization's commitment to sustainability and energy efficiency.About the Role:The Director...


  • Ottawa, Ontario, Canada Employment and Social Development Canada Full time

    Job Title: Director - Environmental Sustainability and EnergyEmployment and Social Development Canada is seeking a highly skilled and experienced professional to fill the role of Director - Environmental Sustainability and Energy. This position is a key part of our organization's commitment to sustainability and energy efficiency.About the Role:The Director...


  • Ottawa, Ontario, Canada Employment and Social Development Canada Full time

    Job Title: Director - Environmental Sustainability and EnergyEmployment and Social Development Canada is seeking a highly skilled and experienced professional to fill the role of Director - Environmental Sustainability and Energy. This position is a key part of our organization's commitment to sustainability and energy efficiency.About the Role:The Director...


  • Ottawa, Ontario, Canada Royal Architectural Institute of Canada Full time $26

    About the RoleWe are seeking a highly motivated and experienced Sustainability Architect to join our team at the Royal Architectural Institute of Canada. As a key member of our team, you will play a critical role in helping us achieve our goal of reducing carbon emissions and promoting sustainable development.Key ResponsibilitiesAssist the project manager in...


  • Ottawa, Ontario, Canada Royal Architectural Institute of Canada Full time $26

    About the RoleWe are seeking a highly motivated and experienced Sustainability Architect to join our team at the Royal Architectural Institute of Canada. As a key member of our team, you will play a critical role in helping us achieve our goal of reducing carbon emissions and promoting sustainable development.Key ResponsibilitiesAssist the project manager in...


  • Ottawa, Ontario, Canada J.L. Richards & Associates Limited Full time

    Are you ready to make a difference? Key Qualifications: A degree in mechanical engineering, sustainable energy, electrical engineering, engineering physics, or architectural conservation and sustainability engineering. A strong commitment to advancing Canada's low-carbon future. Experience in leading and mentoring diverse teams to deliver...

  • Data Analyst Ii

    4 months ago


    Ottawa, Canada Fullscript Full time

    Fullscript is making optimal care easy for everyone. Through our care delivery platform, health practitioners can seamlessly design personalized health plans, provide support and education tools, and effortlessly prescribe and manage the use of healthcare's best supplements — all in one place. Since 2011, Fullscript has enabled over 90,000 practitioners...


  • Ottawa, Ontario, Canada Employment and Social Development Canada Full time

    Job Title: Director, Carbon Management TechnologiesJoin Employment and Social Development Canada as we seek a highly skilled Director, Carbon Management Technologies to lead our efforts in identifying, developing, and implementing technologies that promote the sustainability of Canada's energy and carbon-intensive industries.About the RoleThe Director,...


  • Ottawa, Ontario, Canada Employment and Social Development Canada Full time

    Job Title: Director, Carbon Management TechnologiesJoin Employment and Social Development Canada as we seek a highly skilled Director, Carbon Management Technologies to lead our efforts in identifying, developing, and implementing technologies that promote the sustainability of Canada's energy and carbon-intensive industries.About the RoleThe Director,...


  • Ottawa, Ontario, Canada Natural Resources Canada (NRCan) Full time

    About the RoleAs the Director of Environmental Sustainability and Energy at Natural Resources Canada (NRCan), you will play a key role in driving the country's clean energy agenda. You will lead a team of experts in developing and implementing technologies that promote the sustainability of Canada's energy and carbon-intensive industries.Key...