Public Works Operating Analyst

Description

Under the direction of the Public Works Director, the Operations Analyst position gathers data from multiple sources and analyzes and interprets data to recommend decisions. The position implements a wide variety of projects, services, and activities. The job requires extensive coordination and communication efforts and the ability to maintain a collaborative and cooperative working relationship with City employees, other organizations, businesses and the general public. The position is responsible for managing and auditing a variety of large data sets, including stormwater and solid waste data in billing software and public works infrastructure assets, materials inventories, and work orders in maintenance management software. The position requires a strong understanding of City ordinances and local, state, and federal regulations. Responsibilities include developing RFQs, RFPs, and Scopes of Work, overseeing financial activities for accurate invoicing and payment processing, and supporting capital planning and project management. This position is proficient in computer skills, which includes knowledge of various software systems such as billing and finance applications, computerized maintenance management systems (CMMS), Geographic Information Systems (GIS), pavement management software, Enterprise Resource Planning (ERP) systems, citizen portals, and the Microsoft suite of tools.

Example of Duties

• Configure and maintain refuse parcel designation, stormwater parcel designation, and associated billing data within financial billing software (VIP) to enable automated invoicing, accurate payment processing, and data analysis.
• Must thoroughly understand and apply the City’s ordinances, rules and regulations, and other applicable policies, ensuring all charges and fees are calculated and invoiced appropriately.
• Deliver excellent customer service to residential and business customers, personally responding to inquiries and complaints from the public. Must have the ability to educate customers on how the bill was calculated.
• Routinely manage and update public works asset (i.e. streets, playground structures, ROW, manholes, signs, traffic signals, fleet) inventory database for input into GIS (by contractor).
• Input asset preventative maintenance schedules, tasks, and asset conditions into work order management software (IWorqs).
• Organize and maintain paper and electronic records for the department, ensuring they are up-to-date and accessible.
• Collect, interpret, and analyze complex data using statistical methods. Analyze, retrieve, and manipulate data from various databases. Produce reports and dashboards that provide insights into department decision-making.
• Evaluate and support the implementation of new technology solutions, ensuring that data quality and consistency are maintained across platforms. Produce training guides and work alongside front-end users to successfully use various city software systems.
• Conduct field investigations for various programs, projects, and assessments and audit field data for accuracy and compliance with permits, codes, and regulations.
• Oversee financial activities related to public works, ensuring that financial, procurement, and budgeting practices are consistent, accurate, and compliant with applicable policies.
• Analyze asset and financial data to develop multi-year capital plans.
• Track various components of capital projects, including budget, scope, grants, state and federal requirements, schedule, communication, and outreach.
• Possess a blend of technical expertise and interpersonal skills to lead special projects as assigned.
  

Typical Qualifications

• Bachelor’s degree in finance, business management, public administration, environmental science, construction management, or a closely related field.
• Experience in utility billing, public works administration, or asset management, with a strong understanding of stormwater, solid waste, or related infrastructure systems.
• Strong project management skills, with the ability to manage multiple priorities and deliver projects on time.
• Proficiency with financial software, utility billing software, asset management software, or work order management systems (such as IWorqs) is a plus.
• an equivalent combination of education and experience sufficient to successfully perform the job's essential duties, such as those listed above.
  
  

Supplemental Information

Knowledge Of

• City organization, operation, policies, and procedures.
• Principles and practices associated with the maintenance of City streets, bridges, signs, traffic signals, guardrails, curbs, sidewalks, storm systems, parks, ground, and facilities.
• Pertinent federal, state, and local rules, regulations, and guidelines for utilities.
• Methods and techniques for inspecting public works and utility maintenance projects.
• Principles and practices of budget creation, monitoring, and administration
• Principles and practices of recordkeeping, customer service, office procedures, methods, and equipment, including computers, software, copiers, etc.
• Public Works’ equipment, fleet, facilities, materials, methods, policies, and procedures
• Contemporary research techniques and resources; data querying analysis, reporting, and presentation methods.
• Municipal permitting and municipal operations
• Capital project management.
• Data analysis and statistical techniques.
• Business process modeling and process improvement methodologies.
  
  

Skill In

• Reading, interpreting, understanding, and applying accounting standards and procedures, applicable Federal rules and regulations, and City policies and procedures.
• Analyze and interpret complex technical data. Correcting and updating financial records, work orders, and database systems.
• Operating a personal computer utilizing standard software, such as Microsoft Office, and specialized software.
• Analyzing and interpreting financial documents and calculations and preparing complex reports, and presenting information to both technical and non-technical audiences as needed.
• Using various statistical techniques to identify patterns, trends, and relationships in operational data.
• Working under pressure of deadlines.
• Using computerized databases, spreadsheets, and word-processing software
• Present complex data to the general public in a format that can be easily understood.
  
  

Ability To

• Work independently on multiple projects and exercise discretion and good judgment.
• Conduct research and compile comprehensive reports or recommendations on the application, development, and implementation of regulations, codes, standards, specifications, or other criteria.
• Troubleshoot and resolve issues.
• Communicate effectively both orally and in writing, including complex information of a technical nature in understandable and concise ways.
• Apply sound judgment under stressful situations to develop recommendations and make decisions.
• Manage time on multiple projects and issues simultaneously towards completion.
• Learn and keep up to date on various software and programs
• Understand relationships and workflows in Public Works and the City.
• Perform data entry and use word processing and spreadsheet programs.
• Diagnose and analyze problems and recommend and/or institute corrective action.
• Read and interpret maps, aerial photographs, mapping coordinates, survey documents, legal documents containing boundary information, right-of-way information, blueprints, and as-built documents.
• Conduct field data collection and inspection of as-is field conditions.
• Work independently in the absence of supervision while maintaining accuracy and attention to detail.
• Present oral communications and presentations to residents, management, leadership team, and/or City Council.
• Effectively work in an outdoor setting during various weather conditions.