ETL Developer

Vantor is forging the new frontier of spatial intelligence, helping decision makers and operators navigate what’s happening now and shape what’s coming next.  Vantor is a place for problem solvers, changemakers, and go-getters—where people are working together to help our customers see the world differently, and in doing so, be seen differently. Come be part of a mission, not just a job, where you can:
Shape your own future, build the next big thing, and change the world.

To be eligible for this position, you must be a U.S. Citizen. This position requires an active U.S. Government security clearance, applicants who do not currently hold the required clearance will not be eligible for consideration. Employment for cleared roles is contingent upon verification of clearance status.

Export Control/ITAR:
Certain roles may be subject to U.S. export control laws, requiring U.S. person status as defined by 8 U.S.C. 1324b(a)(3).Please review the job details below.

This position requires an active U.S. Government Security Clearance at the TS/SCI clearance with required Polygraph.

We are seeking an experienced ETL Developer to provide onsite support for a geospatial visualization platform. This role focuses on developing, maintaining, and optimizing data pipelines to ensure reliable data flow into a PostgreSQL database. The ideal candidate will have strong experience in ETL processes, data integration, and working with large, complex datasets, including geospatial data.

Responsibilities:
Design, develop and manage ETL workflows using Apache NiFi to support a geospatial visualization platform

Learn the nuances of the existing NiFi system and the related AWS and PostgreSQL infrastructure in order to monitor and troubleshoot real time issues

Obtain an understanding of existing NiFi flows with minimal support from others

Develop new NiFi flows that adopt best practices of existing NiFi flows

Take feedback on NiFi flows and develop requested changes

Take direction and communicate status via a ticketing system

Interface with analysts via email, chat, and in person meetings to comprehend future data flow needs and refine general requirements into specific actions

Interface with a development cycle using a local development environment of containerized infrastructure and version control via Git and NiFi Registry Gain competency in geospatial database design and employ best practices for table creation, indexing, and unique constraints

Take feedback from analysts on nuances to support application data layers

Programmatically manipulate and transform data from multiple sources

Query and analyze large datasets using SQLRetrieve and process data from external systems via APIsSupport data quality, integrity, and performance optimization efforts

Understand Python and data science frameworks while differentiating between experimental prototypes and enterprise level software requirements

Develop Python in support of data science related efforts or ETL prototypes

Minimum Qualifications:

Experience:

Bachelor’s degree with 8+ years of relevant experience, ORMaster’s degree with 7+ years of experience, OR Doctorate with 6+ years of experience

Degree in Computer Science, Systems Engineering, Geography, or a related technical field

Active TS/SCI clearance with required polygraphU.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

Demonstrated experience with programmatic data manipulation

Competency to rapidly adopt containerized development proficiency

Competency to…