DWM Data/Reporting Analyst I (OLIO - Operations)

Posting expires: December 16, 2025

Salary range: $44,369 - $59,232

General Description and Classification Standards:

Performs daily data input and analysis in the City’s Computerized Maintenance Management System (CMMS) for the Office of Linear Infrastructure Operations (OLIO). Major functions include initiation, creation, updating, maintenance and close out of service requests and work orders as directed. Performs reporting and analysis work in support of departmental research, performance reporting, operations management, and departmental operations as directed. Designs and prepares reports and reporting formats by accessing databases or by consolidating data from multiple sources and provides summary as needed. Employees with this position classification may also perform other related administrative or operations tasks within the organization provided they have a similar level of professional challenge. Other duties may include direct communication with customers and other stakeholders under the direction of a manager or area superintendent regarding the status of specific work orders, scheduling coordination for work crews, utility locate coordination, etc.

Supervision Received:

Performs work under general supervision with review and advice from manager or a senior level professional. May work independently or with other workers with responsibility for completion of assigned tasks.

Essential Duties and Responsibilities:

These are typical responsibilities for this position and should not be construed as exclusive or all inclusive.

• Performs data entry and analysis on a consistent basis; sources of data may be enterprise CMMS systems, complex spreadsheets, databases, maps, etc. requiring specialized expertise or training.

• Assumes responsibility for maintaining accuracy of data input/data entry assigned for updates in the operating records and/or databases.

• Identifies processes or reporting functions that do not provide the necessary level of completeness, detail, or accuracy.

• Designs standard report formats based on organizational needs for information.

• Retrieves and summarizes data from various information systems for inclusion into research or operating reports.

• Reviews monthly operating statistics generated from data input/data entry and prepares operating reports.

• Generates reports, presentations, graphics, forms, and other documents to demonstrate information flow from field personnel up to the Data Reporting Analyst.

• May make presentations of periodic reports or special projects to organizational management.

• Tracks specific project processes, procedures, and other performance measures necessary to meet the needs of managed projects and department objectives.

• Reviews daily project journals for comparison to internal daily journals for accuracy and congruency.

• Coordinates and communicates with internal and external stakeholders as assigned.

• May coordinate with the State underground utility notification authority to apply for utility locating services to support the work functions on the division.

• May assist the Area Superintendent and/or Manager with the coordination of administrative activities pertaining to operating and maintaining specific OLIO infrastructure programs and/or OLIO working facilities or substations.

• May perform other duties as assigned

The above statements reflect the general duties, responsibilities and competencies considered necessary to perform the essential duties and responsibilities of the job and should not be considered as a detailed description of all the work requirements of the position. COA may change the specific job duties with or without prior notice based on the needs of the organization.

Knowledge Skills and Abilities:

This is a partial listing of necessary knowledge, skills, and abilities required to perform the job successfully, it is not an exhaustive list.

• Ability to interact with field staff, Area Superintendents, Managers, and the OLIO management team as required to perform daily job assignments.

• Skill in operation of computers to retrieve data to prepare reports and presentations.

• General skills in the utilization of a Computerized Maintenance Management System (CMMS) and Microsoft Excel and other database software to forecast information and produce various reports.

• Ability to manage time and workload effectively which includes planning, organizing, and prioritizing a variety of tasks.

• Ability to work well with others and comfortably adapt to changes in a fast-paced work environment with a strong work ethic.

• Ability to work well under pressure and exhibit good judgement, tolerance of