Senior Data Engineer

Pivot Point Solutions; Oakland (CA); Hybrid; USD 52.000 - 90.000; Vollzeit

Zusammenfassung

Pivot Point Solutions in California is seeking a Senior Data Engineer to design, build, and maintain enterprise data pipelines and analytics applications. You will work with Palantir Foundry and related tools to deliver scalable data solutions for utility and infrastructure clients.

The role requires 5+ years in data engineering, strong SQL, Python, PySpark, and experience with data modeling, dashboards, and production systems; hybrid work in Oakland and a 12-month contract.

Qualifikationen

• Bachelor's degree in Computer Science, Engineering or related field or equivalent experience.
• 5+ years hands-on data engineering with production pipelines.
• Proficiency in SQL, Python and PySpark for large datasets.
• Experience with Palantir Foundry data modeling, pipelines and app development.
• Experience building analytics applications, dashboards or reporting solutions.
• Strong problem-solving and cross-functional collaboration.

Aufgaben

• Design, build and maintain scalable data pipelines for analytics and operations.
• End-to-end data solutions from ingestion to delivery.
• Develop data models and ontology objects in Palantir Foundry.
• Use Python, PySpark and SQL to transform and analyze large datasets.
• Develop operational apps with Palantir Foundry tools (Workshop, Quiver, Slate).
• Create dashboards and visualizations with Tableau/Power BI.
• Collaborate with stakeholders to turn requirements into data solutions.
• Monitor pipeline performance and data quality.
• Troubleshoot data processing issues and optimize workflows.
• Mentor junior data engineers and contribute to standards.

Kenntnisse

SQL

Python

PySpark

Data modeling

Ausbildung

Bachelor's degree in Computer Science or related field

Tools

Palantir Foundry

Palantir Workshop

Palantir Quiver

Palantir Contour

Palantir Slate

Tableau

Power BI

Jobbeschreibung

Pivot Point Solutions is a California-based consulting firm that delivers experienced field professionals to construction and utility organizations across the state. We partner with contractors, program owners, and utility clients to provide skilled inspection, construction management, and field support personnel who keep infrastructure projects safe, compliant, and on schedule.

Our team understands the demands of active construction environments, from underground gas and electric infrastructure to large-scale utility programs. By pairing deep industry knowledge with a responsive, hands‑on approach, we help clients maintain quality, meet regulatory requirements, and keep field operations running smoothly on some of California's most critical infrastructure projects.

Job Overview

Title: Senior Data Engineer
Sector: Information Technology / Data Engineering & Analytics
Seniority: Senior Level
Location: Oakland, CA
Job Type: Hybrid
Contract Length: 12 Months +
Compensation: $37.87 - $65.05/hour

Role Overview

Pivot Point Solutions is seeking a Senior Data Engineer to support the development and delivery of enterprise data and analytics solutions. This position will play a key role in designing, building and maintaining scalable data pipelines, data models, analytical applications and reporting solutions using Palantir Foundry and related technologies.

The ideal candidate combines strong hands‑on data engineering expertise with experience developing business-facing applications and analytics products. This role works closely with solution architects, data engineers, analysts, data scientists and business stakeholders to transform complex datasets into reliable, actionable solutions supporting critical utility operations.

Your Day-to-Day Activities

Design, develop and maintain scalable data pipelines supporting enterprise analytics and operational applications.

Build end-to-end data solutions from source ingestion through transformation, modeling and delivery.

Develop and maintain data models and ontology objects within Palantir Foundry.

Use Python, PySpark and SQL to transform, process and analyze large, complex datasets.

Develop operational applications using Palantir Foundry tools such as Workshop, Quiver and Slate.

Create data visualizations, dashboards and analytical products using Quiver, Contour and other reporting tools.

Collaborate with business subject matter experts to translate operational requirements into functional data solutions.

Monitor pipeline performance, data quality, freshness and overall reliability.

Troubleshoot data processing issues, pipeline failures and application performance problems.

Optimize data workflows to improve processing efficiency, latency and resource utilization.

Maintain and enhance existing data applications as business needs and usage evolve.

Partner with architects, analysts, data scientists and engineering teams to deliver integrated analytics solutions.

Support testing, validation, deployment and ongoing maintenance of data products.

Provide operational support for critical data applications, including participation in 24/7 support coverage as required.

Mentor junior data engineers and contribute to engineering standards and best practices.

The Job Requirements

Bachelor's degree in Computer Science, Engineering or a related field, or equivalent relevant experience.

5+ years of hands‑on data engineering experience, with a strong background building and maintaining production data pipelines.

Advanced proficiency in SQL, Python and PySpark, including experience working with large datasets and complex data transformations.

Practical experience developing solutions within Palantir Foundry, including its data modeling, pipeline and application development capabilities.

Experience creating analytical applications, dashboards or reporting solutions that support business decision‑making.

Strong problem‑solving skills and the ability to collaborate with technical teams and business stakeholders in a fast‑paced environment.

Ability to support critical production data systems, including participation in 24/7 operational support coverage as needed.

You’ll Stand Out If You Have

Hands‑on experience with Palantir Workshop, Quiver, Contour and Slate.

Experience developing ontology‑based applications and complex data products in Foundry.

Experience with Tableau or Power BI and enterprise data visualization.

Experience supporting utility, energy, smart grid or other large‑scale operational data environments.

About Pivot Point Solutions

Pivot Point Solutions delivers experienced field professionals to organizations throughout California's construction and utility industries. Our teams support critical infrastructure initiatives by placing inspectors, construction managers, and field personnel who understand the demands of complex, highly regulated construction environments.

We partner with our clients to provide professionals who can integrate quickly with project teams, operate independently in the field, and help ensure projects are completed safely, efficiently, and in full compliance with utility specifications, codes, and quality standards.