This position serves as a critical data, research, and reporting resource for the Water Resources Service Center, helping transform information into insight, insight into action, and action into better public service. The Senior Management Analyst develops dashboards, reports, research products, and recommendations that support leadership decision-making, operational improvement, budget planning, accountability, and organizational performance. When assigned to major utility technology initiatives, including the AMI Smart Meter Project, the position also helps protect the accuracy and reliability of customer account, meter, and billing data, supporting one of the City’s most essential public services.
Bachelor's Degree in Business Administration, Public Administration, Data Analytics, Information Systems, Planning, or a closely related field; with four (4) years of management analysis, budget analysis, administrative analysis, utility operations support, data analytics, research, reporting, or community/urban planning experience that includes gathering, reviewing, validating, interpreting, and presenting complex data; using database or reporting software programs; preparing comprehensive written reports; and supporting operational or organizational decision-making; or any equivalent combination of education, training, and experience.
Preferred Qualifications:
- Experience supporting a public utility, water/wastewater/stormwater operation, customer billing operation, AMI/smart meter program, asset management program, or major technology implementation project.
- Experience using Microsoft Excel, Power BI or comparable business intelligence tools, GIS/spatial data, work order systems, utility billing systems, or other enterprise databases.
- Experience developing dashboards, performance measures, executive reports, process documentation, data quality reviews, and cross-departmental issue tracking tools.
Additional Requirements
Background investigation, including supervised drug screen, post-offer/pre-employment medical screen, and verification of education, certifications, and licenses required prior to employment.
- Knowledge of governmental budgeting, accounting, procurement, personnel, records management, and administrative practices.
- Knowledge of data collection, data validation, trend analysis, performance measurement, dashboard development, and report preparation methods.
- Knowledge of utility operations, utility customer account processes, meter-to-bill workflows, AMI/smart meter data, and utility billing database practices, or the ability to rapidly acquire such knowledge.
- Knowledge of computer hardware and software, database programs, business intelligence tools, spreadsheets, and automated system integration concepts.
- Knowledge of modern office practices and procedures, City personnel policies, City purchasing policies, and service center administrative processes.
- Skill in analyzing complex administrative, budgetary, operational, and data quality problems and developing practical recommendations.
- Skill in gathering, cleaning, reconciling, organizing, and interpreting data from multiple systems and presenting findings in clear written, oral, tabular, dashboard, or graphic formats.
- Skill in coordinating with internal departments, vendors, project teams, and leadership to resolve data, reporting, account, billing, and process issues.
- Skill in oral and written communication, including the preparation of executive summaries, reports, presentations, policies, procedures, and briefing materials.
- Ability to manage multiple priorities, maintain accuracy, protect sensitive information, meet deadlines, and exercise sound judgment with limited supervision.
MINIMUM STANDARDS:
SUPERVISORY CONTROLS: Work is performed under the limited supervision of the Water Resources Chief, or designee. The supervisor reviews completed work for compliance with procedures, accuracy, analytical quality, and the nature and propriety of final results.
GUIDELINES: Guidelines include City rules, regulations, policies, and procedures; standard operating procedures; budget and purchasing requirements; personnel policies; records retention requirements; utility billing and customer account procedures; AMI/smart meter project procedures; and policies and procedures for computer system usage. These guidelines require judgment, selection, and interpretation in application.
COMPLEXITY: The work consists of varied management, analytical, reporting, database, and project support duties. The position requires the application of a variety of procedures, policies, precedents, and analytical methods, as well as the ability to adapt standard methods to fit facts, conditions, and evolving operational needs.
SCOPE AND EFFECT: The purpose of this position is to support management of department budgets, records, data systems, reporting, and special projects; ensure accurate data used for customer accounts and service center decision-making; and recommend improvements to administrative and operational processes. Successful performance contributes to the efficiency, accuracy, accountability, and effectiveness of department and service center operations.
PERSONAL CONTACTS: Contacts are typically with co-workers, department staff, other City personnel, vendors, consultants, project team members, and the general public. The position may also have occasional contacts with officials at higher levels on matters requiring cooperation, explanation, coordination, or persuasion.
PURPOSE OF CONTACTS: Contacts are typically to give or exchange information, research and resolve problems, coordinate projects and reports, verify data, support customer account accuracy, and provide services.
PHYSICAL DEMANDS: The work is typically performed while intermittently sitting, standing, walking, or stooping. The employee occasionally lifts light objects. This is sedentary work requiring the exertion of up to 10 pounds of force occasionally.
WORK ENVIRONMENT: The work is typically performed in an office. The position may require occasional field visits, meetings, or site observations related to projects, data verification, or operational analysis. Absence of disagreeable conditions.
SUPERVISORY AND MANAGEMENT RESPONSIBILITY: None. The position may coordinate work products, data requests, reports, and project-related tasks with staff across departments, project teams, vendors, and consultants.
