Highway Maintenance Data Technician III - Aurora

State of Colorado•Denver, CO

1d•Hybrid

About The Position

This position is within CDOT's Highway Maintenance Section 5 Support Unit located in Aurora. This work unit provides technical support and training; establishes standards and procedures; and collects, compiles, and disseminates information within the Maintenance Section pertaining to Maintenance Level of Service (MLOS) budget in the following areas: Plant Maintenance (PM), SAP work orders, purchase requisitions, Equipment Management System (EMS), Maintenance Decision Support System (MDSS), SAP timesheets, Buildings and Property, adoption of miles, and regulations. This unit also assists in the maintenance and operations for all nine Major Program Areas (MPAs) to include equipment, materials, and personnel. As the Technician III, you will support the Maintenance Section by diagnosing and resolving issues related systems and programs collecting data regarding highway maintenance activities. You will administer training to supervisors and maintenance personnel regarding these systems and programs to ensure accurate data collection. You will collect, compile, and disseminate information for such programs as: work orders and timesheet population, MLOS, Property and Buildings, Noxious Weed Program, Road Weather Information System (RWIS), Maintenance Decision Support System (MDSS), Consumable Inventory, Storage Tanks, MS4 Stormwater Permits, Water Quality and Well Monitoring Permits, and Computer Support.

Requirements

Three (3) years of full-time work experience where the primary job duties include all of the following: Working with computer software and applications (e.g., MS Excel, SAP, Google Applications).
Using software to track a large volume of data, such as documents, equipment, financial, or other.
Applying rules and procedures for the entry, quality assurance, analysis, resolution of issues, and reporting and manipulating data.
Providing on-going customer service in person, on the phone, and/or via email to internal and external customers.
A current valid driver’s license is required.

Nice To Haves

Demonstrated success with the duties listed in the Description of the Job section
Years of State service experience related to the duties of this position
Highest work/personal ethics and integrity
Experience in reconciling data and ensuring data accuracy
Experience troubleshooting issues with data accuracy and finding resolution
Experience pulling reports from data sources
Experience purchasing goods and services and monitoring budgets
Ability to work under tight deadlines and be adaptable to changing assignments
Ability to take initiative to solve problems in an innovative manner
Ability to work with a variety of stakeholders with sensitivity to their needs, priorities, promises made and commitments
Effective interpersonal and relationship-building skills
Strong time and project management skills, including prioritization and multi-tasking ability
Excellent reasoning, investigative, analytical, and problem-solving ability
Excellent facilitation, presentation, and communication skills, both written and oral
Strong attention to technical detail and accuracy
Passion for safety
Fluency in Microsoft Office Suite (Word, Excel, PowerPoint), Gmail and Google Applications, SAP, and the ability to quickly learn other software systems.

Responsibilities

Assist in the management of the SAP Plant Maintenance module.
Work with field maintenance personnel, region Business Office, and other CDOT staff to ensure regionwide and statewide consistency of data collection methods and proper operations of the system.
Assist the MLOS Coordinator and SAP Coordinator by inputting, correcting, and finalizing all data such as T-code work orders and timesheet population.
Monitor total expenditures (including overhead) for all MPAs, projects, building funds, Noxious Weed Program, and maintenance activities.
Recommend how to fix allocated funds that are over- or underspent.
Ensure accuracy of data input for these programs as well as set and maintain material costs.
Assist with the training of approximately 250 employees on SAP system process and changes and new software program changes.
Assist in creating a variety of reports using historical and current data from several different CDOT systems.
Create queries, table joins, dashboards, and writing scripts to produce reports that meet requested specifications.
Recommend and modify expenditure reporting and budget development tools; Track regional controlled and deferred maintenance funds and provide recommendations regarding the yearly plan.
Track property and gaming project expenditures and initiate contracts.
Participate in building and grounds inspections and maintenance asset inventories.
Create purchase requisitions and follow-up to ensure purchase orders are created and properly coded.
Work with the Business Office and Purchasing regarding contracts, maintenance agreements, etc.
Track purchase orders, contracts, and agreements and notify managers regarding renewals and funding levels.
Provide support to the snow desk by monitoring radios and phones during snow events, other weather-related events, and road closures as needed; working an 8-12 hour shift during these emergency events.