Utilities Business Analyst
The Utilities Business Analyst, under the supervision of the Utilities Business Solutions Manager, performs a variety of technical and professional-level work involving the analysis of department budgets, expenses, revenues, and utilities rates and fees. The Business Analyst will be responsible for developing, modifying and monitoring performance measurement tools to inform the Utilities Department long-term financial strategy.
Reporting Relationships :
Reports to : Manager Business Solutions
Direct Reports : None
Key Competencies :
Performance of the essential functions of this position requires :
- Expert knowledge of database applications, spreadsheets and data management protocols
- Ability to develop and implement quality assurance / quality control measures to minimize the potential for errors
- Excellent verbal and written communications skills
- Ability to present key information to plant management for decision-making
- Experience utilizing the following MS Office Applications : Word, Excel, PowerPoint
- Ability to create high-quality presentation materials and data visualizations, including figures, tables, and diagrams.
- Ability to make rational decisions through sound logic and deductive reasoning
- Ability to work independently and manage time effectively, determine priorities, recall directions and details, and to follow-through to complete performance of essential functions
- Ability to effectively prioritize project assignments, track and report project status for multiple projects
- Ability to support an ethical, non-discriminatory and safe work environment
Duties and Responsibilities :
This position works in collaboration with Manager and Deputy Director to oversee the execution of utility financial needs for the water and sewer utility, specifically :
Assists in the overall management of business functions of the utility including supporting the administration and monitoring of department budgets and cost of service modelingPerforms financial and statistical analysis for utility rates, revenue collection, metering and performance managementPrepares and reviews quarterly financial fund reports including analysis and interpretation of performanceTracks capital project funding, monitors expenses and prepares financial summary reports, including those related to stormwater utility servicesWork in conjunction with the Utilities Manager Business Solutions, Utilities Deputy Director Business Solutions, and Finance department on securing funds from common debt funding sources including :Water Infrastructure Financing Innovation ActState Revolving FundMunicipal Bond MarketIdentifies recommendations to improve operational controls, procedures and document managementMonitors and guides training in division's financial processes ensuring financial transactions are in accordance with City policies and proceduresMonitors legislative changes for impacts to the delivery of servicesAssists in preparation of an annual budget and long-term financial planning documentationNotifies departments of potential budget over-runs and makes recommendations for alternative funding sources and budget amendments, including those related to stormwater utility servicesDevelops analytical tools for making financial projections and recommendationsAssembles relevant historical revenue and expenditure information for financial trend monitoringMonitors grant opportunities and prepares applications for the Utilities DepartmentMaintenance of Water and Sewer rate and fee modelsAbility to describe rate design process to multiple audiencesIdentification of rate structure types and relative impacts on customersReview and tracking of financial provisions in Utility agreementsAdditional responsibilities include :
Effectively build formal and informal relationship networks inside and outside the organizationManaging and analyzing the Utilities department agreements including :Sanitary Sewer Connector District agreementsWater Supply agreementsOperation and Maintenance AgreementsEvaluating, prioritizing, and communicating critical projects and administrative tasks, including those related to stormwater utility servicesGaining the confidence and trust of others through honesty, integrity, and authenticityEnsuring programs, policies, and procedures are understood and followed by all Business Solutions personnelAttending and participating in professional group meetings; maintaining awareness of new trends and innovations related to the Business Solutions DivisionCoordinating and monitoring the work of external contractors and ensuring compliance with specifications and standardsOther duties as assignedPreparation and Training :
Education :
Bachelor's degree minimum; Advanced degree in Business Administration, or Finance desired.Work Experience :
Minimum of 8 years increasingly responsible experience in Business Administration or Finance in the Utility Sector; Water and Sewer utility finance experience preferred.Extensive knowledge in the development and utilization of Microsoft Office suite and advanced proficiency in Excel and database software requiredSalary Range :
$66,966 - $100,448 / Annual Salary
Working Conditions and Physical Requirements :
Work is performed in an office environment and in an industrial environment. May work near moving mechanical parts; exposed to fumes, pathogens, airborne particles and various chemicals, some of which may be toxic. The employee is exposed to various conditions including noisy, hot and cold conditions.
Application Deadline :
Open Until Filled