Local GIS Data Analyst with Data Quality

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.