Interval Export

Summary Description:
Under direction, performs utility bill payments and analysis for MCPS with the objective of accurate bill payment and minimizing annual utility costs. The Utility Analyst is responsible for the financial oversight, data integrity, and consumption analysis of the school system?s multi-million-dollar utility portfolio. This portfolio includes electricity, natural gas, solar, heating fuels, water, and sewer services across all district facilities. Procurement duties include serving as a technical expert in the procurement of complex, deregulated utility supplies; monitoring legal and financial requirements for Request for Proposals and contracts with attorneys who represent both MCPS and vendors. Serves as MCPS representative at meetings of various load aggregation groups; prepares information on historic utility use of MCPS facilities for aggregation analysis; manages utility bids and administers contracts. Monitors markets and advises on locking in utility rates at favorable levels to manage risk. Budgeting and accounting duties include technical support of the utility database, with integrated electronic bill submittal and payment systems; management of updates and problems resulting from deregulation and changing suppliers; review and resolution of questionable bills; authorization of service start or stop at individual facilities; set up of new accounts in the database; preparation of annual budgets and monthly tracking reports; and continuous coordination of rate forecasts with the Interagency Group on Energy and Utility Management. Operating duties include development and production of periodic energy reports; monitoring and coordinating investigation of high-usage alerts; management of delivery problems; and publication of related procedural flyers. Participates in department strategic planning and develops and maintains related energy performance measures. Physical Demands: None. Special Requirements: None.

Knowledge Skills Abilities:
Skill in analyzing Requests For Proposals and bid quotations and in making recommendations concerning the awarding of contracts. Excellent ability to write and review Request for Proposal (RFP) bid specifications for utility services to enhance competition, and to evaluate and analyze all offerings submitted by suppliers to ensure bid specifications and objectives are met. Ability to express ideas well, orally and in writing. Excellent interpersonal skills are needed to present oneself effectively and professionally when dealing with supplier representatives, Montgomery County Public Schools employees, and other governmental agencies. Expert user of LAN, email systems, and Microsoft Office applications, especially database, spreadsheet, and internet applications. Possesses the ability and willingness to continuously learn new skills and technology. Must possess the knowledge, thoroughness, and diligence of character necessary to maintain database integrity for a complex utility accounting system. Requires fluency in relational database manipulation and development, including creation of custom queries, new reports, and the import/export of data from spreadsheets. Detailed knowledge of deregulated commercial utility bill formats and information. Practical knowledge of energy performance measurement and indices for schools. Skill at detecting and investigating unusual utility usage in facilities. Skill at strategic planning and the continuous improvement of business processes. Advanced proficiency in Microsoft Excel (VLOOKUPs, Pivot Tables, advanced formulas) and experience working with utility/energy management databases. Proficient in enterprise content management systems, with hands-on experience publishing content within Optimizely (formerly Episerver) CMS. Requires knowledge of the EPA Energy Star Portfolio Manager to assist in benchmarking school buildings to target energy efficiency. Knowledge of utility interval data monitoring programs and investigative tools. Exceptional eye for detail; ability to spot patterns, anomalies, and errors in dense financial and volumetric data. Must be an excellent manager of time, with the capability to define priorities. Knowledge of and the ability to meet the seven core competencies of the Supporting Services Professional Growth System (SSPGS).
Education, Training, Experience:
Bachelor's degree required with a major in Business Administration, Finance, Accounting, Computer Science, Statistics, Data Analytics, or a related field. Extensive training in computers, office automation, and database management preferred. Specific experience with the Energy CAP utility bill payment system is preferred. Minimum of one year of experience in procurement of deregulated natural gas or electricity. Minimum of two years? experience detecting, investigating and reducing high-energy use alarms in facilities. Other combinations of applicable education, training, and experience that provide the knowledge, abilities, and skills necessary to perform effectively in the position may be considered.Certificate License: None