dreamwork_
Home · Kepora · ETL Developer

🔒 Clearance & Citizenship Requirements

This position requires U.S. Citizenship and an active TS/SCI security clearance with Full Scope Polygraph. Candidates who do not currently hold these credentials will not be considered.

The scope of this effort is to provide the Sponsor with one (1) ETL Developer to support in an onsite capacity.

This position requires an active U.S. Government Security Clearance at the TS/SCI level with required polygraph. Our team has an immediate need for an experienced ETL Developer to join our team at a customer-site in McLean, VA.

What you'll do:

  • 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

Full-time and on-site, Monday to Friday.

---

Required:

  • Active U.S. Government Security Clearance at the TS/SCI level with required polygraph.

  • U.S. citizenship required.

  • Bachelor’s degree in Computer Science, Systems Engineering, Geography, or a related technical field (or equivalent experience).

  • Senior Labor Category: Minimum 8 years of experience with a Bachelor’s degree; or 7 years of experience with a Masters degree; or 6 years of experience with a Doctorate.

  • Experience in developing 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 rapidly adopt AWS architecture proficiency.

Nice to have:

  • Creativity to experiment and recommend best practice coding improvements.

  • Drive to adopt and recommend AI into development processes.

  • Ability to design and develop custom NiFi processors using Java.

  • Experience with AWS cloud services for data ingestion and processing.

  • Strong experience with PostgreSQL for data management.

  • Hands-on experience with Apache Airflow.

  • Hands-on experience with Apache NiFi.

  • Hands-on experience with NiFi registry and Git.

  • Hands-on experience with Git and repository actions and pull requests.

  • Hands-on experience in Python for data manipulation and API interfacing.

Level: Senior or higher.

Clearance: active TS/SCI with polygraph.