GIS Data Analyst/Architect

Header Overview Applied Future Technologies (AFT) seeks a GIS Data Analyst/Architect with strong ETL, API integration, QA/QC, and GIS data modeling expertise to support federal transportation data modernization projects. This role focuses on enterprise geospatial data architecture, pipeline development, quality assurance automation, and integration of large-scale roadway datasets. The analyst/architect will design GIS schemas, build robust ETL processes, implement automated validation frameworks, manage data lineage, and support stakeholder reporting using national transportation data sources. Responsibilities • Design and implement enterprise GIS data models and geodatabase schemas for linear roadway networks and transportation features. • Develop ETL pipelines for ingesting, transforming, and loading transportation datasets (shapefiles, GeoJSON, CSV) into enterprise geodatabases. • Create comprehensive QA/QC frameworks with validation rules, automated error detection, reconciliation reports, and quality metrics dashboards. • Perform data profiling, anomaly detection, and completeness checks across multi-jurisdictional datasets with varying schemas. • Manage data lineage documentation, change tracking, audit trails, and metadata for regulatory compliance. • Build API integrations for data exchange between GIS platforms, external data hubs, and analytical systems. • Generate automated reporting and visualization of data quality metrics and pipeline performance. • Support data governance including standardization, schema governance, and transformation documentation. • Collaborate with GIS teams and stakeholders to validate business requirements and optimize workflows. Qualifications • 8+ years experience in GIS data engineering/architecture with ETL pipeline development. • Expert-level GIS data modeling and schema design for enterprise geodatabases and spatial networks. • Proficiency with GIS schema languages, domains, subtypes, relationship classes, and topology rules. • Expert Python programming for data processing, ArcPy automation, and API integration. • Strong ETL tools experience (FME, Talend, or equivalent) and geospatial data integration. • Proven QA/QC framework development for geospatial datasets including validation automation. • Experience with transportation datasets (road networks, LRS preferred) and SQL databases. • REST APIs, JSON processing, and web service integration experience. • Bachelor's degree in GIS, Computer Science, Data Science, Geography, or related field. • U.S. citizenship; ability to pass federal background check. Preferred Qualifications • ArcGIS Enterprise, ArcGIS Pro, and ArcGIS Data Reviewer expertise. • Federal government contracting experience (transportation/infrastructure preferred). • Esri Roads and Highways for linear network modeling. • Experience with FGDC/ISO metadata standards and data governance frameworks. • Section 508 compliance for geospatial visualizations and reports. Pay: $90,000.00 - $110,000.00 per year Work Location: Remote Apply tot his job Apply To this Job