Geospatial Data Analyst

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.

• 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.

• 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 (Arc Py, 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.

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

• 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.

USD 115, per year.