Utility Coordinator

Overview

Utility Coordinator role at Harvard University. This position provides primary support to the Utility Administration Group within Engineering and Utilities (E&U) and broader administrative support to all areas within E&U, including operations, engineering, and general administration.

Job Responsibilities

• This position is responsible for facilitating and overseeing a successful internal billing process each month for all utilities consumed by the University, including electricity, chilled water, hot water, steam, natural gas, water & sewer, and fuel oil.
• Directly responsible for compiling and reviewing usage data from nearly 1,000 internal utility meters and a dozen or so major utility vendor meters. Includes downloading most usage data as well as manually entering remaining, confirming all data accuracy, estimating missing / erroneous meter usage data, and alerting operations personnel to any anomalies.
• Administers the monthly internal chargeback process for all utilities. Executes processes in EnergyCAP billing system to allocate meter usage and calculate remainder meters. Verifies accuracy and completeness of data, then runs bill generation process to send cost recovery charges to the Harvard General Ledger application each month as part of the monthly University accounting close. Annually include charges for Utility Administration fees.
• Performs duties of EnergyCAP key user on monthly and annual basis as needed. Manages databases for rate plans, vendors, bill formats, accounting codes, custom fields, allocation percents, and chargeback formulas. Ensures other team members accurately manage accounts, organizations, buildings, and meters.
• Creates and maintains spreadsheet-based tools to supplement the input / output capabilities of EnergyCAP, including, reformatters for vendor-provided billing files, bill tracking tools, batch verification tools, monthly billing review reports, and remittance advices.
• Supports reporting needs of end users and E&U executives, enabling them to verify usage, cost and operations are within acceptable ranges. Supports E&U and other unit executives with financial analyses of vendor rate plan options. Assists in the development of future utility rate guidance provided to Harvard schools and units for internal budgeting purposes.
• Analyzes utility vendor rate plan proposals submitted to the Massachusetts Department of Public Utilities to determine impacts to EnergyCAP setup. Recommends and implements changes to EnergyCAP setup to accommodate new rate plans and billable charge types.
• Coordinates with other Harvard units, particularly Environmental Health & Safety and the Office for Sustainability, to provide them with the utility usage data they need to fulfill their mission and to satisfy government reporting requirements.
• Oversees and advises other billing team members as needed regarding use of EnergyCAP and associated tools, utility industry terminology and practices, and department processes. Participates in department cross-training to provide backup for all support staff functions in E&U.
• Successfully identifies, analyzes, and solves problems in a positive manner; willingly shares knowledge so that others may be cross trained; addresses problem issues head-on in a proactive manner. All communications and support must be done in a professional manner.
• Participates in the establishment and implementation of office policies and procedures required to meet departmental goals. This includes the review of existing processes and procedures, and the development and implementation of new processes and procedures. Provide records management functions on a variety of documents.
• All functions to be performed in full compliance with established policies and procedures and all work in an efficient and accurate manner such that the task is accomplished in the specified time frame and with the desired outcome / result.
• May participate and / or serve on Campus Services committees and task forces.
• Performs related job duties or other assignments as required or directed.

Working Conditions

Qualifications

Basic Qualifications

Additional Qualifications and Skills

Additional Information

Work Format Details

This position is based on-site at a Harvard campus location. Additional details will be discussed during the interview process. Certain visa types may limit work location. Individuals must meet work location sponsorship requirements prior to employment.

Salary

This position is salary grade level 056. Please visit Harvard\'s Salary Ranges to view the corresponding salary range and related information.

Benefits

EEO / Non-Discrimination Commitment

Harvard University is committed to equal opportunity and non-discrimination. We seek talent from all parts of society and the world, and we strive to ensure everyone at Harvard thrives. Our differences help our community advance Harvard\'s academic purposes.

J-18808-Ljbffr