GIS Database Specialist (Data QA/QC, SQL Server query, and ETL) - REMOTE
Posted 3 days ago by Chandra Technologies, Inc.
Negotiable
Undetermined
Remote
Remote
Summary: The GIS Database Specialist role requires over 7 years of experience in enterprise database management and linear referencing, focusing on the maintenance and integration of the NCDOT Hydrography Layer. The position involves data QA/QC, SQL Server database queries, and ETL process management. The specialist will ensure the accuracy and reliability of GIS data during its transition to the Enterprise GIS environment. This role is critical for supporting the ongoing operations until the dataset ownership is transferred to the NC Department of Environmental Quality.
Key Responsibilities:
- Support the long-term maintenance and enterprise integration of the NCDOT Hydrography Layer.
- Manage geometry, event, and attribute changes to GIS data.
- Conduct data QA/QC and progress reporting.
- Create and maintain ETL processes.
- Execute direct SQL Server database queries.
Key Skills:
- Data QA/QC
- ETL Process creation and maintenance
- Direct SQL Server Database queries
- Progress Reporting
- Linear Referencing
- ESRI Roads and Highways
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: Other
Job Description:
***Crop to Crop resumes are accepted
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.
Required Skills:
Data QA/QC |
ETL Process creation and maintenance |
Direct SQL Server Database queries |
Progress Reporting |
Linear Referencing |
ESRI Roads and Highways |