Geospatial Data Analyst

Organizational Development Resource Group; Arlington (VA); On-site; USD 115,000 - 125,000; Full time

Job summary

Organizational Development Resource Group seeks a seasoned Geospatial Data Analyst to support CISA in undersea cable and network analysis. You will design, build, and maintain the IDS data layer and the infrastructure mapping tool (IMT).

The role requires enterprise geodatabase expertise, data lifecycle management, and collaboration with government teams on-site in Arlington, VA, with Top Secret clearance eligibility.

Qualifications

• Education and experience requirements include a Bachelor’s degree plus 12 years or a Master’s degree plus 10 years, or 16 years of specialized experience in lieu of a degree.
• Experience designing, implementing, operating, maintaining, and repairing DHS geospatial databases.
• Ability to monitor geospatial database performance and capacity and implement efficiency and security measures.
• Experience with enterprise geodatabases on SQL Server, PostgreSQL/PostGIS, or Oracle; knowledge of schema design and backup/recovery.

Responsibilities

• Produce and maintain the IDS Design Description including data schema, data dictionary, and Data Management Plan.
• Develop and test datasets within designated CISA IT infrastructure and align with data requirements.
• Ensure data lifecycle, validation, and testing per CISA IT enterprise standards.
• Maintain IDS data through semi-annual updates and annual normalization.
• Design, operate, secure, and optimize the geospatial database supporting the IMT; coordinate with teams.

Skills

Geospatial databases

Data management

ETL

Python

ArcGIS

Education

Bachelor's degree + 12 years experience

Master's degree + 10 years

16 years of experience in lieu of a degree

Tools

ArcGIS Pro

ArcGIS Data Interoperability/FME

ArcPy

SQL Server

PostgreSQL/PostGIS

Job description

The Geospatial Data Analyst will support CISA’s undersea cable and network analysis program by designing, building, and maintaining communications infrastructure datasets that power an Infrastructure Mapping Tool (IMT). This role owns the data layer (IDS), spanning schema definition, validation, dataset releases, and operation of the supporting geospatial database.

Primary Responsibilities

• Produce and maintain the IDS Design Description, including the data schema, data system architecture, data dictionary, and Data Management Plan, and provide dataset design and specifications prior to any production dataset update.
• Develop and test datasets within designated CISA IT infrastructure, including storage of raw datasets and source feeds on CISA enterprise infrastructure, while ensuring alignment with CISA data architecture and schema requirements.
• Ensure dataset development, integration, validation, and testing follow CISA IT enterprise data lifecycle requirements.
• Acquire, update, validate, and maintain Federal Government telecommunications usage and capacity data at least semi-annually for use in the IMT.
• Integrate new telecommunications resource data into the IDS as it becomes available.
• Provide complete documentation and annotated source code for all IMT data, including data dictionaries and frameworks.
• Deliver recurring IDS outputs, including monthly IDS documentation and Infrastructure Data Integration Assessments and Validation, quarterly IDS layer updates, and an annual full normalization update.
• Design, operate, tune, and secure the geospatial database supporting the IMT; monitor performance and capacity and coordinate configuration with system, software, and security teams.
• Maintain interconnections between the IDS database, the IMT and related applications, and other enterprise data systems.
• Support data handoff during transition, including integrating the IDS onto Government or successor equipment.

Required Qualifications

• Education and experience: Bachelor’s degree plus 12 years of specialized experience, or Master’s degree plus 10 years, or 16 years of specialized experience in lieu of a degree (GTSS BPA Geospatial Database Administrator (Sr) minimums).
• Experience designing, implementing, operating, maintaining, and repairing DHS geospatial databases.
• Ability to monitor geospatial database performance and capacity and implement measures to improve efficiency and security.
• Experience configuring hardware and software in coordination with system, software, and security teams.
• Capability to design geospatial database structure to meet emerging mission requirements, strengthen security posture, and improve information handling and sharing.
• Ability to maintain network interconnections between the database, systems and applications, and other databases and systems.
• Enterprise geospatial database design and administration experience, including enterprise geodatabases on SQL Server, PostgreSQL/PostGIS, or Oracle, with knowledge of schema design, indexing, performance tuning, and backup and recovery.
• Data management discipline, including data dictionaries, Data Management Plans, data lifecycle, metadata, and versioned dataset releases.
• ETL and data validation experience using ArcGIS tools (ArcGIS Pro, ArcGIS Data Interoperability/FME) and Python (ArcPy, ArcGIS API for Python, SQL).
• Background in a telecommunications discipline, with experience handling network or communications infrastructure data.
• Working knowledge of cybersecurity and IT security as applied to databases, including access control, hardening, and NIST SP 800-53 controls.
• Intermediate or better proficiency with the Esri ArcGIS product suite.
• Strong technical writing for design descriptions and data documentation.
• Personable, client-facing communication skills and ability to build rapport with Government customers and teammates, with effective collaboration on a small team.
• Active Top Secret clearance and eligibility for SCI access at time of hire.

Technologies

• ArcGIS Pro
• ArcGIS Data Interoperability/FME
• ArcPy
• ArcGIS API for Python
• Python
• SQL
• SQL Server
• PostgreSQL
• PostGIS
• Oracle
• Esri ArcGIS
• NIST SP 800-53

Location and Clearance

• Work location: Classified (TS/SCI) work on-site in Arlington, VA 22201 and the NRCC as directed.
• Clearance: Active Top Secret clearance and eligible for SCI access at time of hire.

Compensation

USD 115,000 - 125,000 per year.