Raytheon Technologies - Herndon, VA
posted 3 months ago
Nightwing is seeking a Database Developer to support a multifaceted global software deployment project. This position is contingent upon funding, an open position, customer approval, completion of a favorable background investigation, and successful TS/SCI with Polygraph clearance crossover. The Database Developer will play a crucial role in the project, particularly in extract, transform, load (ETL) workflows. The work involves regular engagement with data scientists, analysts, and managers to ensure the successful implementation of data processes. The responsibilities of the Database Developer include loading large datasets into the client's on-premises and Cloud environments, developing and maintaining ingestion algorithms and schemas for large datasets, and analyzing new large-volume datasets to optimize the data ingest processes. The developer will also support the creation of Apache NiFi schemas for new data loads and develop software tools that efficiently preprocess, modify, aggregate, load, index, and archive large data collections into clusters in near real-time. Ensuring proper access controls are implemented and generating metrics to track data ingest statistics to maintain data integrity and provenance are also key responsibilities. Additionally, the developer will document the data-flows according to standards set by the Sponsor and work with multiple Database Management Systems (Oracle, SQL, Mongo, etc.). The ideal candidate will have a strong background in Computer Science, Computer Engineering, Systems Engineering, or a closely related discipline, along with professional experience in AWS cloud services, Databricks, SQL database structures, and Apache NiFi. The role requires a demonstrated ability to develop and deploy ETL processes for large data sets, create operating system level scripts for ETL operations, and implement multiprocessing data-flows to parallelize ingest operations. Strong coordination and collaboration skills are essential, as is the ability to communicate technical concepts to non-technical audiences. This position offers an exciting opportunity to contribute to the future of cybersecurity and intelligence services at Nightwing.