Job Summary Our client, a leading Energy & Utilities provider, is seeking a Senior Palantir Foundry Data Engineer to join their team. This position is W-2 only. We do not work with third-party firms or C2C arrangements for this role.
Core Responsibilities
- Design and develop end-to-end scalable data pipelines, data products, and operational solutions using Palantir Foundry, PySpark, Python, and SQL
- Build and maintain Foundry Ontology models, including object types, properties, relationships, and actions
- Develop real-time and near-real-time streaming pipelines for operational and event-driven data
- Build business and integration logic using TypeScript and REST APIs alongside analytical workflows in Foundry Contour
- Convert complex SQL, stored procedures, triggers, ETL mappings, and business rules into scalable Foundry/PySpark solutions
- Implement data-quality checks, schema validation, lineage, metadata management, monitoring, and health checks
- Design reusable frameworks, optimize pipeline performance, and adhere to production-grade engineering practices (Git, CI/CD, unit/integration testing, and code reviews)
Required Skills/Experience (Must-Haves)
- Bachelor’s or Master’s degree in Computer Science, Engineering, MIS, or equivalent experience
- 10+ years of overall IT/data engineering experience, including 5+ years of hands-on data engineering and large-scale ETL/ELT experience
- Proven hands-on experience with Palantir Foundry core concepts, Foundry Ontology, and Foundry Contour
- Strong programming proficiency in PySpark, Python, SQL, and TypeScript
- Experience with Spark Streaming / real-time data processing and enterprise integrations via REST APIs
- Expertise in data modeling, data quality, metadata management, and lineage tracking
- Proficiency with Git, CI/CD pipelines, and production-grade software engineering and testing practices
Preferred Skills/Experience (Nice-to-Haves)
- Palantir Foundry Data Engineer Certification
- Energy & Utilities domain experience involving outage management, ADMS/OMS, grid operations, ETOR, PSPS, or customer communications
- Advanced experience with Ontology modeling, TypeScript, Contour, Foundry APIs, and streaming architectures
- Cloud and distributed data-processing experience, particularly with AWS
- Prior experience migrating legacy stored procedures and triggers into modern cloud data platforms
Key Competencies & Behaviors
- Cross-Functional Collaboration
- Architectural Mindset
- Quality & Rigor
- Adaptability & Time-Zone Alignment
Work Environment
- Location: San Francisco Bay Area, CA (PST hours required)
- Work Model: Hybrid, 1x onsite
Compensation & Benefits
- Pay Range: The approximate pay range for this position is between $50.00 and $78.00. Please note that the pay range provided is a good faith estimate. Final compensation may vary based on factors including but not limited to background, knowledge, skills, and location. We comply with local wage minimums.
- Medical, Dental, & Vision Insurance Plans
- Employee-Owned Profit Sharing (ESOP)
- 401K offered
About KellyMitchell
At KellyMitchell, our culture is world class. We’re movers and shakers! We don’t mind a bit of friendly competition, and we reward hard work with unlimited potential for growth. This is an exciting opportunity to join a company known for innovative solutions and unsurpassed customer service. We're passionate about helping companies solve their biggest IT staffing & project solutions challenges. As an employee-owned, women-led organization serving Fortune 500 companies nationwide, we deliver expert service at a moment's notice.