Guidehouse

Guidehouse

Data Engineer

McLean, Virginia, USA · full-time

No sponsorship$85k-$141kDetected 37 days ago
PythonGitSQLPostgreSQLDatabricksAWSAzureCloud PlatformsCI/CDSparkData EngineeringAgileFinancial AnalysisCommunicationFinancial Reporting

About the role

  • Experience working with relational and analytical data stores (e.g., Databricks, Oracle, Postgres, SQL Server) and applying sound data modeling principles.
  • Familiarity with Git-based version control, CI/CD concepts, and Agile delivery methodologies in secure environments.

Responsibilities

  • 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, and migration efforts, including onboarding legacy financial systems and transitioning workloads to Databricks and Foundry within Advana.
  • Document data flows, engineering designs, and operational procedures to support compliance, knowledge transfer, and platform accreditation.
  • Experience building or supporting data solutions using Palantir Foundry, including pipelines, transforms, datasets, and data lineage.

Requirements

  • 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.
  • ship is required.
  • Must have an ACTIVE and MAINTAINED "SECRET" Federal or DoD security clearance with the ability to meet all client security and access requirements.
  • Bachelor?s degree obtained Minimum FIVE (5) years of experience in data engineering, analytics engineering, or software development, preferably in regulated or federal environments.
  • Strong proficiency in Python, SQL, PySpark, and Spark-based data processing.
  • Demonstrated hands-on experience with Databricks, including Delta Lake, notebook development, performance tuning, and production pipelines
  • Ability to operate independently in a fast-paced, mission-focused environment.
  • Strong analytical, troubleshooting, and communication skills, including the ability to translate complex technical concepts for both technical and non-technical audiences.
  • What You Will Need: ship is required.

Nice to have

  • Bachelor's degree in computer science, Information Systems, Engineering, or a related field (or equivalent practical experience).
  • Direct experience supporting DoD financial, PPBE, comptroller, or audit-related programs.
  • Prior experience working directly within the Advana ecosystem or adjacent DoD enterprise analytics platforms.
  • Advanced Palantir Foundry experience, including operationalizing analytics for large user communities.
  • Cloud certifications (AWS, Azure, Databricks).
  • Familiarity with data governance, metadata management, lineage, and access controls in classified or controlled unclassified environments.
  • Understanding of DoD data, security, and compliance frameworks (e.g., RMF, ATO processes).
  • Previous consulting experience supporting federal or defense clients.

Compensation

  • $85k-$141k

Benefits

  • Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.
  • Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event.
  • Benefits include:

Equal opportunity

  • All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

Visa & Work Authorization

  • Must have an ACTIVE and MAINTAINED "SECRET" Federal or DoD security clearance with the ability to meet all client security and access requirements
Apply directly at Guidehouse →Create a free account for alerts like thisView Guidehouse immigration profile

This listing is sourced directly from Guidehouse's careers page and normalized into a canonical job model.