The Energy Analyst works with an interdisciplinary team to manage utility accounts, energy and sustainability programs, and reporting and analytics for a diverse building and land portfolio.
Oversee the bill administration process for all utility accounts ensuring that consumption and spend are tracked accurately for the purposes of energy management and reporting.
o Act as a key contact to a third-party bill pay administrator and primary liaison with utility companies
Assist in the development of utility budgets and explain financial variances.
Develop new and maintain existing reports and handle data requests from internal and external stakeholders (examples of reports include utility consumption in common units and ekWh, annual Greenhouse Gas accounting, and portfolio benchmarking).
Present energy analytics and support training initiatives for internal and external clients
Engagement with building tenants via sustainability events and newsletters
Post-secondary degree/diploma in finance, engineering, mathematics, science or related fields
Advanced Excel skills experience with formulas and pivot tables
Energy and Sustainability experience (academic, professional/volunteer experience)
Excellent communication skills
Basic understanding of relation databases and SQL
Utility experience is an asset worked at a utility, energy market regulator, or energy consultant company
Familiarity with utility invoices (e.g. power factor, energy rate classes, etc.)
Working knowledge of Energy Star Portfolio Manager, International Performance Measurement and Verification Protocol (IPMVP) Framework, and either LEED or boma BEST
Accounting experience knowledge of accruals, budget/reforecast, and variance analysis
Experience with Tableau Prep Conductor or Power Query
Experience with Tableau Desktop or Microsoft PowerBI
Location/Region: Ames, IA