Job Information
State of Vermont AOT Data Analyst II - Asset Management in Barre, Vermont
This job was posted by https://www.vermontjoblink.com : For more information, please see: https://www.vermontjoblink.com/jobs/1358686
Overview
The Data Analyst II assists in managing 22 asset inventories and requires staff to actively work with various subject matter experts to refine inventories, costs and treatments within the Agency of Transportation\'s (AOT) Vermont Asset Management Information System. Duties include updating budget figures and qa/qc the data inventories to identify trends to work towards improving both the quality and the accuracy of the treatments recommended.
Field work and training with various partners across the agency will be necessary to help identify data quality issues, provide inventory support, program support, identify trends in data and work to improve the quality of the data available. In addition, continuous improvement of the data, analysis and management practices will be part of the work. Interactions with both field-level staff, and other Agency partners will be required.
Required technical skills:
Advance Data QA/QC skills with the ability to identify trends in data, manipulate and join data from a variety of inventory management systems.
Data cleaning, validation and transformation.
Data integration across a variety of systems.
Field data collection and verification, knowledge of inspection and management practices for transportation assets.
Familiarity of asset treatments and maintenance practices.
Collaboration with field staff and subject matter experts.
Technical writing and communication skills and the ability to present data and information at a variety of levels for technical documents, guidance materials, and verbal communication.
GIS skills to support both field data collection and required mapping and visualizations.
Ability to support users with GPS, phone, tablet and other survey tools.
Advance Microsoft Power Platform including Power BI, Excel, MS Access and other data analysis and database tools.
Environmental Factors
Duties are performed primarily in a standard office setting. Occasional travel may be required.