ETL Developer

Kepora • McLean, VA

1d • Onsite

About The Position

The ETL Developer will support a geospatial visualization platform for a government Sponsor, working onsite at a customer site in McLean, Virginia. The role involves designing, developing, and managing ETL workflows in Apache NiFi and learning the existing NiFi system and its related AWS and PostgreSQL infrastructure to monitor and troubleshoot real-time issues. The developer is expected to understand existing flows with minimal support and create new flows that follow established best practices.

The position works with analysts to understand future data-flow needs and translate general requirements into specific actions. The developer takes feedback and direction, communicates status through a ticketing system, and refines NiFi flows and application data layers based on analyst input. Development uses a local environment with containerized infrastructure, Git, and NiFi Registry. The role also builds competency in geospatial database design, including table creation, indexing, and unique constraints.

This is a full-time, onsite position, Monday through Friday. Applicants must be U.S. citizens and hold an active U.S. Government TS/SCI clearance with a required Full Scope Polygraph.

Requirements

• U.S. citizenship.
• Active U.S. Government TS/SCI security clearance with required polygraph.
• Bachelor’s degree in Computer Science, Systems Engineering, Geography, or a related technical field, or equivalent experience.
• At least 8 years of experience with a Bachelor’s degree, 7 years with a Master’s degree, or 6 years with a Doctorate.
• Experience 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.
• Ability to rapidly develop proficiency with containerized development.
• Ability to rapidly develop proficiency with AWS architecture.

Nice To Haves

• Creativity in experimenting with and recommending best-practice coding improvements.
• Drive to adopt and recommend AI in 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 repository actions and pull requests.
• Hands-on experience with Python for data manipulation and API interfacing.

Responsibilities

• Design, develop, and manage Apache NiFi ETL workflows for a geospatial visualization platform.
• Learn the existing NiFi system and related AWS and PostgreSQL infrastructure to monitor and troubleshoot real-time issues.
• Understand existing NiFi flows with minimal support and develop new flows using established best practices.
• Incorporate feedback and make requested changes to NiFi flows.
• Take direction and communicate status through a ticketing system.
• Work with analysts by email, chat, and in-person meetings to understand future data-flow needs and refine requirements into specific actions.
• Use a local development environment with containerized infrastructure, Git, and NiFi Registry.
• Develop competency in geospatial database design and apply best practices for table creation, indexing, and unique constraints.
• Use analyst feedback to support application data layers.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior