Job ID: NC-797724 (98690423)
Remote/Local GIS Data Analyst (12+) with Data Quality, ETL, SQL Server, Linear Referencing, ESRI Roads and Highways experience
Location: Raleigh, NC (NCDOT)
Duration: 12 Months
Skills:
Data QA/QC Required 7 Years
ETL Process creation and maintenance Required 7 Years
Direct SQL Server Database queries Required 7 Years
Progress Reporting Required 7 Years
Linear Referencing Required 7 Years
ESRI Roads and Highways Required 7 Years
Description:
Role requires 7+ years of relevant experience and expertise in enterprise database and linear referencing specific to datasets of this type including advanced database reporting, creation and execution of QA/QC processes and enterprise database query.
NCDIT-Transportation (NCDIT-T) GIS Team is seeking a Specialist – Expert that will support the long-term maintenance and enterprise integration of the NCDOT Hydrography Layer, a critical GIS dataset compiled by the NCDOT Environmental Analysis Unit over the past five years. The dataset has reached a maturity level requiring migration into the Enterprise GIS environment and ongoing operation support until ownership transitions to NC Department of Environmental Quality (NCDEQ).
The primary focus is to support the geometry, event and attribute changes to the GIS data with additional responsibilities of data QA/QC, progress reporting, direct SQL Server Database query, and Extract, Transfer, Load (ETL) process creation and maintenance during this period of management.
The complexity of these responsibilities are essential to ensure accurate, stable, and reliable management of the Hydrography Layer within the enterprise environment.