Secret Data Architect - Palantir Foundry

Insight Global; Ashburn (VA); On-site; USD 130,000 - 180,000; Full time

Job summary

Insight Global is seeking an experienced Data Architect with Army Vantage expertise to lead end-to-end data architecture for a DoD program. You will drive ingestion, modeling, governance, and production delivery, while leading a geographically distributed team and delivering scalable pipelines.

The role requires hands-on implementation, enterprise data strategies, and strong collaboration with military leadership and data owners to translate mission needs into architecture.

Qualifications

• Active Secret Clearance required.
• 7+ years in data architecture/engineering/analytics.
• Hands-on architect with production data/AI systems experience.
• Strong communication in fast-paced DoD environments.
• Experience with Databricks Lakehouse/Medallion architectures.
• Kimball dimensional modelling expertise.
• Data governance with metadata/catalog tools.

Responsibilities

• Own end-to-end architecture and hands-on implementation for Army Vantage/Palantir Foundry.
• Design conceptual, logical, and physical data models and semantic layers.
• Build scalable ETL/ELT pipelines and governed data layers using Python, PySpark, Spark SQL.
• Develop Foundry Ontologies, including objects, links, actions, functions, and KPIs.
• Develop Workshop apps, JS/TS functions, widgets, and OSDK integrations.
• Maintain data cleansing pipelines delivering authoritative data across layers.
• Enforce validation, de-duplication, formatting, and business rules in Foundry artifacts.
• Lead engineers, review code, and ensure architectural alignment.

Skills

Active Secret Clearance

Kimball modeling

Databricks Lakehouse

Python

PySpark

Spark SQL

Foundry governance

Leadership

Communication

React/TypeScript

Education

Bachelor's degree in CS/IS

Tools

Databricks

Delta Lake

Foundry Ontology

Collibra

Purview

OSDK

JavaScript/TypeScript

React

Job description

Job Description

Insight Global is looking for an experienced Data Architect with Army Vantage experience to support a key DoD program. The selected candidate will be a hands-on technical leader responsible for solutions spanning data ingestion, transformation, dimensional and semantic modeling, Foundry Ontology, Workshop applications, governance, and production delivery. The ability to translate mission needs into sound architecture while leading a technically diverse and geographically distributed engineering team is essential. Responsibilities include:

• Own the end-to-end architecture and hands-on implementation of enterprise data, analytics, and applications in Army Vantage/Palantir Foundry.
• Design and implement conceptual, logical, and physical data models using Kimball dimensional modeling, Databricks Lakehouse/Medallion patterns, semantic layers, and Foundry Ontology.
• Design, implement, test, deploy, and maintain scalable ETL/ELT pipelines and governed raw, clean, and curated data layers using Python, PySpark, Spark SQL, Foundry Code Repositories, Pipeline Builder, Databricks, and Delta Lake.
• Design and implement Foundry Ontologies containing governed objects, links, Actions, Functions, KPIs, and access controls.
• Design and build production Workshop applications, JavaScript and TypeScript Functions, custom widgets, and OSDK integrations.
• Develop, refine, and maintain data cleansing pipelines in Palantir Foundry, ensuring authoritative, accurate, and standardized data is delivered across raw, clean, and curated layers.
• Implement robust validation, de-duplication, formatting, and business rule enforcement within Foundry Code Repositories, Pipeline Builder, and Ontology Actions to guarantee high-quality, governed data ready for downstream analytics and applications.
• Implement document-processing pipelines, tool orchestration, evaluations, audit logging, data-freshness indicators, and controls against unsupported or unauthorized responses.
• Lead team’s engineers while personally developing critical components, reviewing code, resolving technical blockers, and maintaining architectural alignment.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [e-mail] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

• Active Secret Clearance
• College degree (B.S., M.S.) in Information Assurance, Computer Science, Management Information Systems, or a related discipline. Experience will be considered in lieu of education.
• Minimum of 7 years of related experience in data architecture, data engineering, software engineering, analytics, or AI/ML.
• Demonstrated experience as a hands-on architect or technical lead who has personally designed, implemented, deployed, and supported production enterprise data and AI systems.
• Strong communication skills and the ability to operate independently and collaboratively in a fast-paced DoD environment.
• Experience implementing Databricks Lakehouse and Medallion architectures using Apache Spark and Delta Lake, including incremental and historical processing.
• Advanced Kimball dimensional-modeling experience, including declaration of grain, fact and dimension design, conformed dimensions, slowly changing dimensions, and enterprise bus architecture.
• Advanced proficiency in data governance practices, including schema evolution, metadata management, cataloging, and automated data-quality enforcement using tools like Collibra, Amundsen, Purview, or Foundry governance features.
• Advanced Python, PySpark, Spark SQL, and SQL development experience.
• Expert production experience with Army Vantage or Palantir Foundry, including pipelines, Ontology, Workshop, and platform governance.
• Experience developing large-scale pipelines, governed semantic layers, data-quality controls, lineage, and production monitoring.
• Experience integrating sources such as enterprise databases and APIs.
• Experience translating customer requirements and business rules into architecture and executable development work.
• Experience leading developers, reviewing code and architecture, establishing standards, and briefing customers. Proficiency with JavaScript and TypeScript for Foundry Functions, custom Workshop development, or OSDK applications.
• Experience integrating sources such as SharePoint, Dataverse, Microsoft Lists, Office files, and scanned policy documents.
• Experience with Palantir AIP, Agent Studio, AIP Logic, OSDK, AI Flow, or Model Context Protocol.
• Experience with React and custom Foundry/Workshop user-interface development.
• Experience integrating Army Vantage, ADVANA, A365, or other DoD enterprise platforms.
• Experience with Army personnel, readiness, logistics, finance, force-structure, or policy data.
• Experience developing decision-support, optimization, simulation, forecasting, or recommendation capabilities.
• Experience working with data owners, data stewards, functional experts, and senior military leadership.