Senior Palantir Foundry Data Engineer
Big Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Database
Databases
ETL
Foundry Ecosystem
Informatica
Information Technology (IT)
Palantir Foundry
Palantir Ontology
Programming
Programming Language
Programming Languages
Reporting and Analytics
Software Development
Spark Streaming
SQL
Job Description
Pivot Point Solutions is hiring a Senior Palantir Foundry Data Engineer for a hybrid contract role based in Oakland, CA (1 day onsite per week). If you enjoy building reliable, production-grade data pipelines and operational solutions, this role focuses on real-time and near-real-time processing, robust ontology modeling, and integrations that help teams modernize how data moves across the enterprise.
Contract details: 24 months+ contract length, $53-$80/hr, Senior level.
What you’ll do
- Design, develop, and maintain enterprise data pipelines using Palantir Foundry, PySpark, Python, and SQL.
- Build and enhance Foundry Ontology models, including object types, properties, relationships, and actions.
- Create real-time and near-real-time pipelines with Spark Streaming and event-driven processing technologies.
- Develop application and integration logic using TypeScript, REST APIs, and Foundry integration capabilities.
- Implement analytical workflows, data exploration solutions, and operational reporting using Foundry Contour.
- Translate SQL queries, stored procedures, triggers, ETL mappings, and business rules into scalable Foundry and PySpark solutions.
- Establish reusable data engineering frameworks to support consistent processing and integration patterns.
- Implement data quality checks, schema validation, metadata management, lineage tracking, and pipeline monitoring.
- Optimize pipelines for performance, scalability, reliability, and operational efficiency.
- Develop and maintain integrations between Foundry, enterprise applications, databases, and external data sources.
- Apply production-grade software engineering practices, including Git, CI/CD, automated testing, and code reviews.
- Troubleshoot complex pipeline failures, data inconsistencies, and processing performance issues.
- Collaborate with business stakeholders and technical teams to turn operational requirements into scalable data solutions.
- Participate in Agile/Scrum activities, architecture reviews, and technical planning.
- Support enterprise data modernization and continuous improvement initiatives.
What you bring
- 10+ years overall IT or data engineering experience, including at least 5 years hands-on data engineering or ETL development.
- Direct experience developing and supporting production data pipelines using Palantir Foundry.
- Hands-on experience with Foundry Ontology, including object modeling, relationships, and actions.
- Advanced development experience with PySpark, Python, and SQL for large-scale processing and ETL/ELT.
- Experience with TypeScript, REST APIs, and Foundry integration capabilities for enterprise data solutions.
- Experience building analytical workflows with Foundry Contour and implementing real-time or streaming pipelines.
- Experience with data modeling, data quality, metadata management, lineage, and production pipeline monitoring.
- Experience with Git, CI/CD, automated testing, and distributed or cloud-based data processing environments.
Technologies you’ll work with
- Palantir Foundry, PySpark, Python, SQL
- Foundry Ontology, TypeScript, REST APIs, Foundry Contour
- Spark Streaming, Git, CI/CD
You’ll stand out if you have
- Palantir Foundry Data Engineer Certification.
- Experience building advanced Ontology models, Foundry APIs, and real-time operational data products.
- Experience with AWS or other enterprise cloud data platforms.
- Experience in the energy and utility industry, especially outage management, ADMS/OMS, grid operations, ETOR, PSPS, or customer communications.