Energy & Sustainability Data Analyst Ii

7 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, 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...


  • Ottawa, Canada Minto Group Full time

    **Job Title**: Sustainability Analyst **Location**: Ottawa **Business Unit**: Minto Properties Inc. Build your future at Minto! Since 1995, we’ve been proudly building better places for people to live, work and play, one home and one relationship at a time. To us, it’s all about special moments — like the thrill of a new apartment, the pride in...


  • Ottawa, Canada The Minto Group Full time

    **Job Title**:Sustainability Analyst** **Location: Ottawa** **B **usiness Unit: Minto Properties Inc.** **Build your future at Minto!** Since 1995, we’ve been proudly building better places for people to live, work and play, one home and one relationship at a time. To us, it’s all about special moments — like the thrill of a new apartment, the...

  • Energy Analyst

    7 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 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...


  • 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...


  • 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...


  • 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, Canada ICF Full time

    Description **Job Description**: **Building Energy Analyst** **Locations: Toronto, ON or Ottawa, ON (Remote)** - This position is fully remote and can only be performed from your home office within Ontario or Saskatchewan provinces. **Ready to make a difference?** Want to make a difference? Come work for ICF, where we combine passion for our work with...


  • Ottawa, Canada R.W. Tomlinson Limited Full time

    The Manager of Sustainability and Energy will be responsible for setting direction and leading the company-wide initiatives focused on energy and carbon footprint reduction through waste diversion, energy generation, and resource recovery. This role will involve creating carbon credits and offsets to drive sustainability efforts. **DUTIES AND...


  • Ottawa, Canada WSP Full time

    **WSP **is one of the world's leading professional services firms. Our purpose is to future proof our cities and environments. We have over 55,000 team members across the globe. In Canada, our 9,800+ people are involved in everything from environmental remediation to urban planning, from engineering iconic buildings to designing sustainable transportation...

  • Data Analyst Ii

    7 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, Canada Assent Full time

    Company Description Assent is the supply chain sustainability management solution for the world’s most responsible, sustainability-focused complex manufacturers. The #1 business risk for complex manufacturers is hidden. Most supply chains were never built with sustainability in mind, and most manufacturers do not have deep visibility into their supply...


  • Ottawa, Canada Assent Compliance Full time

    Company Description Assent is the supply chain sustainability management solution for the world’s most responsible, sustainability-focused complex manufacturers. The #1 business risk for complex manufacturers is hidden. Most supply chains were never built with sustainability in mind, and most manufacturers do not have deep visibility into their supply...


  • Ottawa, Canada Avenir Energy Full time

    Avenir Energy Ltd. is the second largest and fastest growing propane distribution company in Canada. We are a fast moving, customer facing, field-based business operating coast to coast, with a focus on excellence. We strive to be the undisputed propane leader in North America, and our 400+ team members are driving us consistently closer to that goal. **Job...

  • Marketing Data Analyst

    7 months ago


    Ottawa, Canada Assent Full time

    **Company Description** Summary** Assent is the leading solution for supply chain sustainability tailored for the world’s top-tier, sustainability-driven manufacturers. Hidden risks riddle supply chains, many of which weren't built with sustainability in mind. That's where we step in. With insights from experts, Assent is the tool manufacturers trust for...

  • Marketing Data Analyst

    7 months ago


    Ottawa, Canada Assent Compliance Full time

    Company Description Summary Assent is the leading solution for supply chain sustainability tailored for the world's top-tier, sustainability-driven manufacturers. Hidden risks riddle supply chains, many of which weren't built with sustainability in mind. That's where we step in. With insights from experts, Assent is the tool manufacturers trust for...


  • Ottawa, Ontario, Canada Stantec Full time

    Company Overview">Stantec Buildings is a leading integrated design practice committed to sustainable design and high-performance projects. Our team of architects, engineers, interior designers, and sustainability specialists work together to create innovative and collaborative solutions for clients.">About the Role">We are seeking a highly skilled Senior...


  • Ottawa, Ontario, Canada Sabic Americas, Inc. Full time

    About Sabic Americas, Inc.Sabic Americas, Inc. is a leading diversified chemical company that activates the power of human capital to address society's future challenges.Job SummaryWe are seeking an experienced Senior Environmental Sustainability Specialist to join our team in Ottawa, USA. This critical role is responsible for ensuring compliance with all...

  • Data Analyst

    7 months ago


    Ottawa, Canada BuzzClan LLC Full time

    **Hello Jobseekers** **We are currently hiring for the following position based in Ottawa** **Job Title: Senior Analyst, Operations Performance** **Location: Ottawa, ON** **Fulltime opportunity** **Must have good Understanding of French** **II. Position Summary** Reporting to the Manager, Program Innovation and Reporting, the Senior Analyst,...