DeveloperJobs.io
← Back to all jobs

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.

Similar Jobs