ETL SOFTWARE DEVELOPER

SAIC - Chantilly, VA

Full-time

Onsite - Chantilly, VA

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The ETL Software Developer will be part of a data engineering team within SAIC's Space & Intel Business Group, focusing on developing software solutions for extracting, transforming, and loading data. This role involves close collaboration with operations officers, analysts, and external engineers to gather requirements and refine systems, ensuring the integrity and usability of data collected during operations. The position requires an active TS/SCI clearance with Polygraph and is based in Chantilly, VA, with no potential for remote work.

Responsibilities

• Develop software to extract, transform, and load data.
• Help architect and implement a framework for extraction, transformation, and loading data.
• Assess and validate system integration requirements across the organization.
• Provide Operations and Maintenance (O&M) for data related software systems.
• Finesse cyber data models.
• Maintain a network, records system, and other analytical applications to collect and analyze data.
• Improve the integrity and usability of its data collected during its day to day operation through the development of software systems.
• Develop and maintain software that extracts, transforms, and loads data from various data formats into data models.
• Maintain and implement a strategy for appropriately securing sensitive application, administrative and data.
• Address enterprise auditing requirements.
• Provide the appropriate documentation required for the Approval and Authorization (A&A) process.
• Ensure mission applications are available to utilize for investigations and assessments.
• Develop and prepare required artifacts for certifications and accreditations submissions in accordance with regulations.
• Use Risk Management Framework (RMF) to successfully obtain system accreditation.
• Utilize Sponsors XACTA software to adhere to accepted assessment methodologies and standards.
• Interpret Nessus vulnerability scans and remediate.
• Perform security analyses of network architecture and provide guidance in the development of functional requirements.
• Coordinate accreditation and certification activities with other stakeholders.
• Maintain baseline functional specifications and standards for deployed systems.
• Maintain baseline technical specifications and standards for deployed systems.
• Coordinate with stakeholders to ensure problem and issue resolution.
• Manage and update the master support schedule.
• Assess and validate development requirements across the organization.

Requirements

• Active TS/SCI with polygraph.
• Bachelors and 9 years or more experience; Masters 7 years or more experience.
• Demonstrated experience with identifying and validating requirements for Extract, Transform, and Load systems.
• Developing software in Python.
• Integrating new technology stacks into software systems.

Nice-to-haves

• Demonstrated experience with NiFi.
• Demonstrated experience with Kafka.
• Demonstrated experience with Logstash.
• Demonstrated experience with SQL.
• Experience building modular systems.
• Understanding of the Cyber Security domain.