DataEngineer

**_Job Family_ :** Data Engineering & Architecture Consulting ** _Travel Required_ :** Up to 25% **_Clearance Required_ :** Active Secret Guidehouse seeks a Data Engineer to support the Department of Defense (DoD) by designing, building, and operating data pipelines and analytics solutions on the Advana platform, leveraging Databricks and Palantir Foundry to enable authoritative, decision-grade financial and operational insights. The ideal candidate will have strong hands-on experience engineering scalable data solutions in secure federal cloud environments and working with financial, budgetary, and execution data. _**What You Will Do:**_ * Design, develop, and maintain end-to-end data pipelines using Databricks (Spark, PySpark, SQL) to ingest, transform, and curate structured and semi-structured data from authoritative DoD source systems. * Engineer and optimize data models, Delta tables, and curated datasets to support financial reporting, PPBE workflows, auditability, and mission analytics within Advana and downstream Foundry use cases. * Develop, maintain, and deploy Foundry pipelines, transforms, and data products, enabling traceability, lineage, and repeatable analytics workflows for DoD stakeholders. * Implement and manage CI/CD and version-controlled data engineering workflows using Git-based repositories and automated deployment patterns aligned with DoD security and ATO requirements. * Build and deploy cloud-native solutions in secure AWS and Azure environments, supporting IL4/IL5 architectures as applicable, and leveraging containerization where approved. * Partner with functional SMEs, financial analysts, platform engineers, and governance teams to ensure data pipelines conform to DoD financial data standards, business rules, and controls. * Implement robust data quality, reconciliation, validation, and monitoring capabilities to support financial accuracy, audit readiness, and confidence in reported metrics. * Support data integration, modernization, an