Senior Data Engineer

Data Engineer

The Data Engineer will be writing code that moves data through a pipeline, fixing data pipeline issues, optimizing data systems, and collaborating with stakeholders, day to day.

The Capital Software Project is building a data fabric system. The data fabric system includes a data pipeline that will be moving a complex mix of data types and formats to a data lake and a series of databases, allowing mission engineering analysts to conduct data analysis from authoritative sources of truth.

The Data Engineer will be working with the Systems Engineering and Dev Sec Ops  teams to ensure that datasets are properly converted, transformed, routed and stored. Create ETL/ELT code to ingest, transform, and load data from a variety of sources into the data lake and scale. Primary data sources will be mission engineering data and physics‑based simulation results.

As a Data Engineer you will be working with the Systems Engineering and Dev Sec Ops  teams to ensure that datasets are properly converted, transformed, routed and stored, as designed. You will also bring your experience in harvesting metadata from datasets and in multi‑source and cross‑domain data integration.

Build and maintain data pipelines to:

• Write or update ETL/ELT code that ingests data from APIs, databases, or files.
• Implement transformations to clean, standardize, or enrich data.
• Optimize pipeline performance and improve reliability.
• Hands‑on experience with AI and ML pipelines, MLOps workflows, and data processing methodologies.
• Implement methods for data traceability and lineage.

Monitor pipelines and data quality to:

• Check automated alerts and logs for failed jobs or data anomalies.
• Troubleshoot issues such as schema changes, missing data, or performance bottlenecks.
• Validate data accuracy and consistency across systems. Leverage your expertise in semantic modeling.

Collaborate with engineering teams to:

• Meet with project teams to understand new data requirements.
• Work with backend engineers or Dev Sec Ops  to align pipeline changes with system updates.
• Support stakeholders by providing data extracts or explanations of data structure.

Design and improve data architecture:

• Plan new data models or schemas for analytics or application use cases.
• Incorporate metadata strategies tailored fit for the use case.
• Help shape the data warehouse/lake structure.
• Evaluate new tools or cloud services to improve scalability and maintainability.

Write code and documentation:

• Build reusable application containers in Python, SQL, or other languages used in the stack.
• Document pipeline logic, data contracts, and system diagrams.
• Participate in code reviews to ensure quality and best practices.

Due to the security classification for this project, work will be performed in‑office, 5‑days a week.

• You have a passion for technology.
• You bring a forward‑looking mindset, anticipating needs and designing scalable, future‑ready data structures.
• You approach complexity with innovation and drive, identify and resolve challenges quickly.
• You rigorously deliver high‑quality, actionable solutions that enhance mission execution.
• You understand the Department of Defense reference and compliance architectures.
• You are passionate about continuous learning and growth, and seek opportunities to challenge yourself.
• You have excellent communication skills.

• Develop and maintain ETL/ELT pipelines to ingest, transform, and load data from a variety of sources into our data warehouse or data lake.
• Design scalable and reliable data architectures, including schemas, workflows, and integration layers.
• Optimize data models, ensuring alignment with analytics and operational needs.
• Collaborate cross‑functionally to understand data requirements and provide technical solutions.
• Monitor pipeline performance, troubleshoot data issues, and implement continuous improvements.
• Ensure data quality, integrity, and security throughout the entire data lifecycle.
• Automate data workflows using scripting, orchestration tools, and CI/CD practices.
• Maintain documentation related to data processes, standards,…