Mid-level Data Engineer; OBI Advanced Analytic Method Augmentation - OBIQUA

Overview

ANTICIPATED AWARD: December 2025/ January 2026
ANTICIPATED START: February/March 2026
PERIOD OF PERFORMANCE: 1 Base Year + 4 Option Years
LOCATION: DIA Facilities across the National Capital Region (NCR)

CLEARANCE REQUIREMENT: Active TS/SCI

Celestar, a proud Veteran-Owned company, offers highly competitive salaries and benefits. Our comprehensive benefits package includes company-paid employee and family dental insurance, employee health insurance, life insurance, and disability coverage. Additionally, we provide a 401(k)-retirement plan with company matching, paid holidays, and personal time off.

• This opportunity will support multiple DIA initiatives, including the Machine-Assisted Rapid-Repository System (MARS), Object Management Services (OMS), and Object-Based Intelligence (OBI).
• The Data Engineer (OBI Advanced Analytic Method Augmentation), designs, implements, and operates data management systems for intelligence needs.
• Designs how data will be stored, accessed, used, integrated, and managed by different data regimes and digital systems.
• Works with data users to determine, create, and populate optimal data architectures, structures, and systems.
• Plans, designs, and optimizes data throughput and query performance.
• Participates in the selection of backend database technologies (e.g. SQL, No
  
  SQL, HPC, etc.), their configuration and utilization, and the optimization of the full data pipeline infrastructure to support the actual content, volume, ETL, and periodicity of data to support the intended kinds of queries and analysis to match expected responsiveness.
• Manages complex, long term projects involving design, development, and installation of new information systems.
• Performs technical studies to ensure the design meets user requirements.
• Develops, integrates, and installs data management capabilities and databases.
• Collaborates with team members to develop or refine resilient and scalable extract, transform, load (ETL) pipelines using industry-standard tools and frameworks (e.g. Apache NiFi) to support and enable data acquisition, normalization, enrichment, and delivery across enterprise systems and platforms.
• Collaborates with team members to ensure ETL pipelines operate in accordance with security controls and rules, SLA requirements, and evolving data architecture needs.
• Collaborates with team members to develop, implement, and maintain Graph
  
  QL APIs to enable flexible and efficient access and aggregation of data across distributed sources.
• Designs data management capabilities, data integration solutions, and databases to ensure optimization, efficiency, and sustained operations.
• Performs systems analysis and feasibility studies to define concepts and design specifications for new or existing databases and content management solutions.
• Collaborates with team members to design, implement, and maintain scalable, performant relational and non-relational database solutions (e.g. Postgre
  
  SQL) to support ingestion, storage, retrieval, and analytics of data across enterprise systems.
• Conducts testing and promotes the integration of new databases within the existing IT infrastructure.
• Discovers sources of redundancy and designs solutions for efficiently integration or consolidating these sources in order to reduce costs of storage and maintenance, and to provide consistency to the enterprise.
• Creates test plans and scenarios and executes and documents database test activities (i.e. component, integration, systems, compatibility/interface, user acceptance, and performance/stress tests).
• Conducts operational readiness testing and transitional user support.
• Conducts monitor services and upgrades data services, content management systems, and databases.
• Produces technical data and reporting outlining the performance characteristics of specified databases and data services in the DIA infrastructure.
• Conducts analysis of database and system reports to ensure optimal performance.
• Develops disaster recovery planning to ensure data and access reliability and database integrity during crisis.
• Analyzes, evaluates and provides recommendations and associated artifacts (e.g. OV/SV- 1s, reference models, integration plans and patterns) on new, current, and planned data service, data management and database technologies and architecture based on performance, cost, and security requirements.
• Conducts assessments of current trends and determines the impact of emerging technologies upon the existing infrastructure.
• Analyzes, evaluates and provides recommendations for current and planned programmatic solutions and capabilities to manage, organize, and transform data outside of databases to ensure unstructured data integrity, security, access, and formats.
• Identify and leverage containerization capabilities (e.g. Docker, Kubernetes) and, infrastructure as code tools to manage and provision resources and ensure repeatability and automation.
• Independently designs, develops, tests, and implements unstructured data management…