GIS Data Engineer / FME ETL Engineer

Technologies / Skills: ETL Tools: FME Desktop / FME Server (Workbench) GIS Platforms: ArcGIS Pro / ArcGIS Enterprise (Utility Network – subnetworks, associations, connectivity) Programming: Python (pandas, GeoPandas, Shapely, ArcPy, pyproj) and SQL (PostgreSQL/PostGIS) Spatial Concepts: Coordinate systems, topology, geometry validation, and schema mapping Data Formats: Shapefile, GeoPackage, GeoJSON, GDB/FGDB, CSV, XML/JSON APIs Responsibilities: Data Engineering & Integration Design and develop ETL workflows using FME Desktop / FME Server for large-scale Electric and Gas network datasets. Integrate data from ArcGIS, PostGIS, CSV/Excel, APIs, and other sources into standardized enterprise schemas. Implement data validation, enrichment, and transformation rules aligned with ArcGIS Utility Network models. Manage coordinate transformations, geometry checks, topology validations, and schema mapping. Develop parameterized and reusable FME templates for consistent integration processes. Handle diverse spatial and tabular formats (Shapefile, GeoJSON, KML, DWG/DXF, CSV, Excel, GDB). Utility Network Data Handling Work with the ArcGIS Utility Network (UN) data model — asset data, connectivity, associations, and subnetworks. Support data migration, synchronization and QA for UN datasets ensuring schema compliance and topology integrity. Collaborate with GIS Modelers and UN Administrators to translate configuration needs into automated workflows. Extract and prepare network data for reporting, tracing, and analytics pipelines. Data Quality, Governance & Collaboration Establish and execute data validation and QA routines for geometric and attribute accuracy. Maintain data lineage, logging, and documentation through FME Server and supporting tools. Work closely with GIS Analysts, Utility Network Specialists, and Cloud Data Engineers to ensure system-wide consistency. Mentor junior team members and promote best practices in FME scripting, data governance, and geospatial data automation. Required Qualifications: 5–10 years of experience in GIS data engineering, FME development or spatial ETL automation. Strong hands-on experience with FME Desktop / FME Server (Workbench). Experience working with ArcGIS Utility Network data models (subnetworks, associations, connectivity). Proficiency in Python (pandas, GeoPandas, Shapely, ArcPy, pyproj) and SQL (PostgreSQL/PostGIS). Solid understanding of spatial data concepts like coordinate systems, topology rules, geometry validation etc. Exposure to Electric and Gas Utility datasets or network asset data management. Desired Qualifications: Experience deploying or automating geospatial workflows on AWS (S3, Glue, Lambda, Step Functions, Athena). Familiarity with data quality frameworks (Deequ). DevOps familiarity with Terraform, or GitHub Actions for workflow automation. Certifications (Preferred): Safe Software FME Certified Professional Esri ArcGIS Utility Network Associate + AWS Certified Data Engineer / Practitioner Education Qualifications G-Spatial Domains G-Spatial Related Domains PG-Spatial Domains PG-Spatial Related Domains Required Skills & Tools ArcGIS Pro QGIS ArcPy Scripting DB-Postgres-PostGIS Core Concepts GIS Fundamentals WebGIS