GIS Developer: ArcGIS Enterprise, Data Pipelines & AI

Citation Oil & Gas Corp.; Houston (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

Citation Oil & Gas Corp. is seeking a skilled GIS Developer to build and manage data pipelines, ArcGIS Enterprise services, and custom web apps that drive land, well, and production data workflows.

You will develop ETL processes, administer GIS platforms, and implement advanced geospatial analytics with Python, SQL, and ArcGIS tools, including Experience Builder widgets and AI-assisted automation.

Qualifications

• 5+ years of professional experience in enterprise GIS administration, data engineering, and GIS development.
• Hands-on ArcGIS Enterprise administration, including upgrades, patching, Data Store management, backup and recovery, and performance tuning.
• Advanced Python (ArcPy, ArcGIS API for Python) and SQL (SQL Server; PostgreSQL a plus), and enterprise geodatabase administration.
• Experience building and scheduling ETL processes with FME (or ArcGIS Data Interoperability).
• Web development experience with JavaScript/TypeScript, React, and the ArcGIS Maps SDK for JavaScript, including custom Experience Builder widgets.
• Experience integrating third-party data sources (APIs, vendor data warehouses) and operational data such as SCADA.
• Ability to communicate clearly with technical and non-technical stakeholders across departments and to manage long-term projects alongside urgent requests.
• ArcGIS Monitor, WebGISDR, and Windows Server administration.
• DuckDB, Snowflake Cortex, or other AI and LLM tools applied to data workflows.
• Power Automate, Survey123, and Field Maps.

Responsibilities

• Data pipelines and foundational layers: Build, schedule, and maintain ETL processes using FME, Python, SQL, APIs, and DuckDB that pull and refresh internal, SCADA, and third-party data into SQL Server, enterprise geodatabases, and Portal.
• ArcGIS Enterprise technical leadership: Serve as the organization's go-to technical resource for ArcGIS Enterprise service management and best practices, guiding the publishing, configuration, optimization, versioning, and lifecycle management of all Portal services.
• Enterprise geodatabase administration: Administer SQL Server enterprise geodatabases, including user access and permissions, geodatabase compression, statistics, index maintenance, and database migrations. Evaluate database platform options such as PostgreSQL for cost and performance.
• Custom application development: Design, build, and maintain web applications, dashboards, and custom widgets using ArcGIS Experience Builder Developer Edition, JavaScript/TypeScript, React, and the ArcGIS Maps SDK for JavaScript.
• ArcGIS Enterprise administration: Administer Portal for ArcGIS, ArcGIS Server, ArcGIS Data Store (relational and object store), and Web Adaptor. Plan and execute version upgrades, patches, license updates, and data store migrations, and maintain a minimum of 90 percent platform uptime.
• Backup, recovery, and maintenance windows: Maintain backup and disaster recovery (WebGISDR) and perform upgrades, patching, and maintenance during scheduled windows outside normal business hours, including weekends, to avoid disrupting users.
• Documentation and continuity: Create and maintain documentation, runbooks, and handoff materials for every process, workflow, and solution developed or configured so other team members can operate, troubleshoot, and maintain them.
• Applied AI: Leverage AI tools such as Claude and ChatGPT to accelerate workflows, and evaluate and implement advanced AI capabilities, integrations, and automation to improve productivity and data insights.
• Monitoring and performance: Monitor platform health with ArcGIS Monitor and scripted reports (disk and data store capacity, service response times, application usage). Tune service configuration and resource use, and lead triage and recovery during outages.
• Infrastructure planning: Partner with I.T. on server and virtual machine architecture, capacity planning, imagery storage, and OS and SQL Server patching, and provide resource-consumption data to support infrastructure and budget decisions.
• Snowflake administration and data engineering: Administer the GIS Snowflake environment (roles, warehouses, access), configure and maintain data ingestion into Snowflake, and build pipelines and secure data shares that deliver Citation data to internal BI tools and to external partners.
• Imagery and GeoAI: Develop and deploy deep learning packages and GeoAI workflows in ArcGIS Image Server to support a broad range of imagery analysis needs, including object detection and change detection.
• Real-time SCADA integration and analytics: Develop IoT SCADA workflows using FME Flow, ArcGIS Velocity, and/or Snowflake, as appropriate, to process sensor telemetry, detect operational events, and generate automated alerts and reports.

Skills

ETL pipelines

ArcGIS Enterprise

Python

SQL

Web development

JavaScript/TypeScript

React

ArcGIS Maps SDK

Snowflake

AI tools

Education

Bachelor's degree in GIS

Geography or CS related field

Tools

FME

ArcGIS Monitor

SQL Server

PostgreSQL

Snowflake

ArcPy

ArcGIS API for Python

Git/GitHub

Experience Builder

JavaScript

Job description

Citation Oil & Gas Corp. is seeking a skilled GIS Developer to build and manage data pipelines, ArcGIS Enterprise services, and custom web apps that drive land, well, and production data workflows.

You will develop ETL processes, administer GIS platforms, and implement advanced geospatial analytics with Python, SQL, and ArcGIS tools, including Experience Builder widgets and AI-assisted automation.