DWM Data/Reporting Analyst I (DC Office)

City of Atlanta•Atlanta, GA

About The Position

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.

Requirements

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 ambiguity.
Ability to review data and identify data trends and/or inconsistencies.
Ability to generally read and understand buried piping infrastructure schematics, drawings, and location maps.
Bachelor’s degree in business/public administration, accounting, finance, information technology, statistics, human resources, or a related field (Additional years of experience may be considered as a substitute for the required degree on an exceptional basis, with a minimum of seven (7) years of professional related experience in creation, reporting, and/or management of data).
Three (3) years of work experience in creation, reporting, and/or management of data or closely related tasks (including data entry).
No specific certifications or licensures required.

Nice To Haves

Four (4) years or more of experience in data analysis preferred.

Responsibilities

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 service 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