Senior Data Engineer

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.

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

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.

• 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.

• 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.

• 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.

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.