Geospatial ETL Architect (TS/SCI) | NiFi & SQL

Vantor (Maxar Intelligence); McLean (VA); On-site; USD 200,000 - 250,000; Full time

Benefits offered by this job

401(k) with company match

Mental health resources

Student loan repayment assistance

Adoption reimbursement

Pet insurance

Job summary

Vantor is seeking an experienced ETL Developer to design, build, and optimize data pipelines for a geospatial visualization platform. This on-site role in McLean, VA leverages NiFi, SQL, Python, PostgreSQL, and AWS to ensure reliable data flow and scalable processing.

This position requires an active TS/SCI clearance with polygraph and an ability to collaborate with analysts, developers, and data engineers on enterprise-grade data solutions.

Qualifications

• Bachelor’s degree with 8+ years of relevant experience, or Master’s with 7+ years, or Doctorate with 6+ years.
• Degree in Computer Science, Systems Engineering, Geography, or a related technical field.
• Active TS/SCI clearance with required polygraph.
• U.S. Citizenship required.
• Willingness to work onsite full-time.
• Willingness to develop NiFi flows using existing best practices.
• Strong understanding of ETL concepts and best practices.
• Strong experience with databases for data management.
• Proficiency in SQL for querying large datasets.
• Experience with API integration and data retrieval.
• Programmatic data manipulation.
• Containerized development proficiency.
• Competency to rapidly adopt AWS architecture proficiency.
• NiFi registry and Git for code management.

Responsibilities

• Design, develop and manage ETL workflows using Apache NiFi to support a geospatial visualization platform.
• Learn the NiFi system and AWS/PostgreSQL infrastructure to monitor and troubleshoot real-time issues.
• Understand existing NiFi flows with minimal support.
• Develop new NiFi flows that adopt best practices of existing flows.
• Take feedback on NiFi flows and implement requested changes.
• Communicate status via a ticketing system.
• Interface with analysts to understand future data flow needs and convert into actions.
• Work with a development cycle using containerized development environments and Git/NiFi Registry.
• Gain competency in geospatial database design and best practices for indexing and constraints.
• Handle data from multiple sources and transform programmatically.
• Query and analyze large datasets using SQL.
• Retrieve and process data from external systems via APIs.
• Support data quality, integrity and performance optimization.

Skills

ETL

NiFi

SQL

Python

AWS

PostgreSQL

APIs

Git

Containerization

Data modeling

Education

Bachelor’s degree in Computer Science, Systems Engineering, Geography, or related field

Tools

NiFi Registry

Git

Docker

Airflow

PostgreSQL

Job description

Vantor is seeking an experienced ETL Developer to design, build, and optimize data pipelines for a geospatial visualization platform. This on-site role in McLean, VA leverages NiFi, SQL, Python, PostgreSQL, and AWS to ensure reliable data flow and scalable processing.

This position requires an active TS/SCI clearance with polygraph and an ability to collaborate with analysts, developers, and data engineers on enterprise-grade data solutions.