ETL Developer

Grvty•McLean, VA

1d•$150,000 - $250,000

About The Position

GRVTY is seeking an ETL Developer with an active TS/SCI with Polygraph clearance to join a project in McLean, Virginia. The role focuses on developing, maintaining, and optimizing data pipelines that reliably feed a PostgreSQL database, including pipelines for a geospatial visualization platform. The developer will work with Apache NiFi, AWS, PostgreSQL, containerized infrastructure, Git, and NiFi Registry, and will collaborate with analysts to translate data-flow needs into implementation tasks. The role also involves querying and transforming large, complex datasets, retrieving data from external systems through APIs, and supporting data quality, integrity, and performance. The developer will build understanding of geospatial database design and data science frameworks, and may develop Python code for data science efforts or ETL prototypes. The position requires substantial relevant experience and a qualifying technical degree or equivalent experience. GRVTY describes its work as supporting national security missions and offers competitive compensation, benefits, and opportunities for professional growth. The listed Virginia pay range is $150,000–$250,000.

Requirements

Active TS/SCI with Polygraph clearance.
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 adopt proficiency with containerized development.
Ability to rapidly adopt proficiency with AWS architecture.
Ability to rapidly adopt NiFi Registry and Git for code management.

Nice To Haves

Creativity to experiment with and recommend 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.
Experience working with geospatial data and related tools.
Understanding of basic data science concepts and tools.

Responsibilities

Design, develop, and manage Apache NiFi ETL workflows for a geospatial visualization platform.
Learn and monitor the existing NiFi system and related AWS and PostgreSQL infrastructure, and troubleshoot real-time issues.
Understand existing NiFi flows with minimal support and develop new flows following established best practices.
Incorporate feedback and requested changes to NiFi flows.
Take direction and communicate status through a ticketing system.
Meet with analysts by email, chat, and in person to understand future data-flow needs and turn general requirements into specific actions.
Work in a local development environment using containerized infrastructure, Git, and NiFi Registry.
Develop competency in geospatial database design and apply best practices for table creation, indexing, and unique constraints.
Incorporate analyst feedback about application data layers.
Programmatically manipulate and transform data from multiple sources.
Query and analyze large datasets using SQL.
Retrieve and process data from external systems through APIs.
Support data quality, integrity, and performance optimization.
Distinguish experimental data science prototypes from enterprise-level software requirements.
Develop Python code in support of data science efforts or ETL prototypes.

Benefits

Robust medical, dental, and vision coverage.
Health Savings Account with company contribution.
Annual paid time off and paid holidays.
Paid parental leave.
401(k) with company match.
Training and development opportunities.
Award programs.
Company-sponsored events.
Competitive compensation and opportunities for professional growth.
Benefits supporting healthcare, financial wellness, retirement planning, family assistance, continued education, and paid time off.