The GIS Developer builds and runs the systems that move Citation's land, well, production, operational, and vendor data into ArcGIS Enterprise, SQL Server, and Snowflake; administers the ArcGIS Enterprise platform; and develops the custom applications, automations, and alerts that put that data to work for multiple business units.
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 (e.g., S&P Global, Enverus, LandVantage) 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. Ensure automated processes run under service accounts with shared alerting.
- 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 (DLPKs) 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.
Qualifications:Required5+ 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.
Preferred10+ years of professional experience in enterprise GIS administration, data engineering, and GIS development.
Proficiency with Git/GitHub source control.
Experience administering Snowflake and building data pipelines and data shares.
Oil and gas data experience: well headers, production, land and lease records, and legal descriptions (PLSS, Texas abstract/survey, metes and bounds).
Imagery and remote sensing: drone imagery processing (e.g., Drone2Map), mosaic datasets, and satellite imagery analysis.
GeoAI and deep learning for object and change detection.
Experience working with SCADA platforms and emissions monitoring data.
Education:Bachelor's degree in GIS, Computer Science, Geography, or a related field, or equivalent professional experience.
Physical Requirements:Extended periods of computer work requiring close visual attention to code, data, maps, and imagery. Sustained concentration for troubleshooting and development work. Physical demands are those of a general office setting.
