System & Data-Modeling Design Overview
- See why Palantir design is about governed models of messy data, not raw scale
- Learn the two design rounds and the mid-round escalation both are built around
- Meet the five worked designs, from the Ontology through governance to lineage
Walk into most system design rounds and the first move is a capacity estimate: reads per second, storage per day, how many machines. Palantir starts somewhere else. You are usually handed a vague, high-stakes, real-world situation with messy data behind it, and the graded skill is turning that mess into a model someone can act on. A field commander needs to see where every asset is. An agency wants a knowledge graph over people, places, and events. A hospital wants to fold a dozen record systems into one view that flags readmission risk. The scale that matters is the number of sources you have to reconcile and the rules that govern who can see what.
The two rounds where design shows up
Design signal at Palantir is split across two onsite rounds, and neither is a stock whiteboard exercise. The first is the Decomposition round, which nearly every candidate gets and which many loops turn on. You are given an open-ended problem with no defined scope, no listed inputs, and no obvious solution. Your job is to structure it: clarify the constraints, name the entities and data, decompose it into components, propose a model, and defend the tradeoffs. There is usually little or no code. It is meant to feel like a forward-deployed engineer walking into a customer site for the first time. The second is the System Design round, closer to a conventional high-level design but Palantir-flavored: integrate the sources, model the entities, enforce policy-driven access, and support a real operational decision.
Both rounds share a defining habit, so expect it before you sit down. The interviewer starts you deliberately under-specified, then piles constraints on mid-conversation to watch you adapt. Now it is air-gapped. Now the feed arrives seven days late with new columns. Now these rows are classified and only cleared users may see them. Now un-merge the two entities you just resolved. The round is built to grow, so a design that only works in its first, tidy form falls apart the moment the escalation lands. Each of these rounds also carries roughly twenty minutes of embedded behavioral, since Palantir has no standalone values round and threads mission and ownership questions through the technical work instead.
- Decomposition round: The signature. About 60 minutes, usually on a shared drawing surface, little or no code. A vague real-world prompt you break into entities, data, components, and tradeoffs. Nearly every candidate gets it, and it is where a large share of loops are decided. Jumping to a solution before scoping the ambiguity is the cardinal mistake.
- System Design round: Palantir-flavored HLD. About 45 to 60 minutes. Integrate heterogeneous data, model the entities, enforce policy-driven access, support an operational decision. Correctness, security, auditability, and fault tolerance are graded first-class, not as extras you mention at the end.
- The escalation: Constraints mid-round. Both rounds start under-specified on purpose, then the interviewer adds constraints live: air-gapped, late data with schema drift, newly classified rows, an entity to un-merge. Your design has to grow under pressure rather than break.
- Embedded behavioral: About 20 min per round. There is no separate values round. Mission fit, ownership, and stakeholder judgment are woven into each technical round, so the design conversation shares its time with a real behavioral thread.
Whether you get the System Design round depends on the role and how the loop is composed. Candidates draw three of four rounds from a fixed menu instead of sitting all of them. The Decomposition round is the near-constant. Forward-deployed candidates, who deploy the platforms on a customer's real data, lean hardest on data-wrangling and modeling under ambiguity; platform software engineers, who build the products, see more conventional design depth. The shapes below recur across both.
The shapes you will be asked to model
Palantir does not publish a question list, so read the chart below as an ordering of where prep pays off, not as measured rates. What holds steady is the family of shapes. They cluster tightly around the same idea: take messy data from many places, give it a shared meaning, and govern every step.
What the round rewards
The clearest way to score well is to structure the ambiguity before you draw anything. Name the data sources and how messy each one is. Name the users and the decision they are trying to make. Name the sensitivity levels and the legal or operational constraints. Only then start decomposing into components. Candidates who leap straight to boxes and arrows read as skipping the part Palantir cares about most, because in a real deployment the scoping is where the value is. From there, the differentiator is treating governance and provenance as cross-cutting from the first box, not as a slide you add at the end.
What lands
- Clarifies the sources, users, decisions, and sensitivity before drawing anything, then scopes a defensible first version
- Models the domain as objects, typed links, and actions, and resolves duplicate entities so one real-world thing is one object
- Bakes access control and provenance into ingestion, the model, search, and export from the start, not as an afterthought
- Grows the design when the interviewer escalates: air-gapped, late data with schema drift, newly classified rows, an entity to un-merge
- Treats correctness, auditability, and fault tolerance as first-class, and can answer where any derived number came from
What stalls the round
- Opens with a capacity estimate and box diagram before scoping what the system is even for
- Stores the data but never models it, leaving one real-world entity scattered across five duplicate records
- Adds a WHERE clause for access control and lets hidden rows leak through search facets, counts, or exports
- Designs only the tidy first version and has no answer when a constraint lands mid-round
- Maxes throughput while hand-waving security, lineage, and consistency, the axes Palantir grades hardest
A prompt you might get
Here is a representative shape, close to the multi-source integration prompt that leads the chart. Read how little is specified on purpose.
Design a platform that ingests data from many enterprise sources with different schemas and normalizes it. It resolves records that describe the same real-world entity and makes them queryable for operational decisions in near real-time. Assume the feed can arrive up to seven days late and its schema drifts without warning.
A strong opening does not start drawing. It asks what the sources are and how they arrive, and who queries the result for what decision. It asks how sensitive the data is, who is cleared to see it, and how fresh the answers need to be. Then it scopes a defensible first version and names what it is leaving out. Expect the interviewer to escalate once you have that footing: now it is air-gapped, so which parts of your design depend on a managed service that will not be there. Now two source systems disagree about the same person, so how does entity resolution decide, and can you reverse the merge later. The point of the round is to watch the design bend without breaking, so build it to grow.
The worked designs
Five designs follow, one per distinct shape from the chart, each built to carry the integration, modeling, governance, and provenance signature so the set reads unmistakably as Palantir. Start with the Ontology, since it is the concept the other four keep pointing back to.
Design an Ontology
The flagship. Model a domain as object types with properties, typed links between them, and action types that change state with validation. Sit it on top of canonical datasets, resolve entities so one real-world thing is one object, and treat security as a property of the object. The clearest place to show you understand Palantir's core concept.
Design a Data Integration Pipeline
The raw-to-canonical-to-ontology flow. Batch and streaming ingest of messy sources, a normalization layer, entity resolution with reversible merges, an incremental transform DAG with dataset versioning, and handling for schema drift, late arrivals, and backfills. The forward-deployed engineer's home turf.
Design Fine-Grained Access Control
Row, column, and cell-level permissions that are mandatory and propagate with lineage. Markings, classification-based and purpose-based controls, read-time enforcement across search results, facets, and exports so hidden rows never leak through an aggregate, and instant revocation on deprovisioning. Government-grade, and unlike any generic role-based scheme.
Design Search Over Entities
Cross-entity search over a large multi-source graph. An inverted index for text, a graph store for relationship traversal, and a geospatial index for location, all filtered by the user's clearances at read time and entity-resolved so one person is one node. The Gotham link-and-map shape, not a generic typeahead.
Design Data Lineage
Provenance and audit as first-class guarantees. Immutable append-only logs, a transform DAG as the lineage backbone, per-fact source and confidence, replayability so any output can be re-derived, and marking propagation as a lineage-driven rule. It is what makes governance enforceable and answers where any number came from.
Each design assumes the fundamentals from the System Design course. That means the scaling playbook for read and write paths, and the toolbox for when to reach for a log, a store, an index, or a queue. These pages stay on the Palantir-flavored modeling and governance and leave the general mechanics to those. Some decomposition prompts carry no fixed architecture at all, like modeling a chess game or a parking garage from scratch. Those live in the coding section alongside the Decomposition round, since they are object-modeling exercises more than distributed-systems designs.
Key Takeaways
- ✓Palantir design work is about turning messy, heterogeneous data into a governed, semantic model people can act on. Integration, modeling, access control, and provenance carry the round, not requests per second.
- ✓Design shows up in two rounds: the Decomposition round nearly everyone gets, where you structure an open-ended real-world problem with little code, and a Palantir-flavored System Design round. Both escalate constraints mid-conversation, so build designs that grow.
- ✓Score by clarifying the sources, users, decisions, and sensitivity before drawing, then baking governance and provenance in from the first box. Markings are mandatory and propagate with lineage, and the system may run air-gapped.
- ✓The Ontology is the concept no other company owns: object types, typed links, and action types over integrated data, with security as a property of the object. It is the flagship design and the one the other four point back to.
Palantir interview guideKnow what Palantir asks before you walk in.
20 coding · 6 system design · 17 behavioral questions
Get their questions first.
InterviewLegend is independent and not affiliated with or endorsed by any company it covers.