Pivotal Software

Modernizes apps and infrastructure using Kubernetes

Data Engineer - Flight Data

Data EngineeringConfirmed live in the last 24 hours

ContractPalo Alto, CA, USA$60 - $70 /hr

About the Job

Requirements

A bachelor's degree in Computer Science, Computer Engineering, Electrical Engineering, or a related technical discipline.
At least 3 years of professional data engineering experience building and operating production pipelines.
Strong SQL skills, including window functions and query tuning on a distributed, columnar engine such as Athena, Trino, Presto, Spark, Snowflake, or BigQuery.
Proficiency in Python for production services, including packaging, dependency management, unit tests, and code review.
Hands-on experience with the AWS data stack, including S3, Glue, Athena, Lambda, SNS, CloudWatch, and IAM.
Experience with dimensional modeling and warehouse design, including partitioning strategies for large tables.
Ability to work across multidisciplinary teams with strong analytical and written communication skills.

Responsibilities

Build and maintain ingest and transformation pipelines that transfer aircraft telemetry from S3 into the flight data warehouse using AWS Glue and Athena, including schema evolution as firmware logging changes.
Design and maintain curated marts for flight runs, component flight hours, vehicle modes, and battery flight features in SQL, with clear grain, documented lineage, and idempotent incremental refresh.
Develop and operate Python services that evaluate flight-by-flight health checks and deliver alerts to engineering and customer-facing channels through SNS and Slack.
Own automated quality gates for mart freshness, source-to-mart reconciliation, and watermark integrity, and block deployments that would publish incorrect fleet data.
Build dashboards and query interfaces for engineering teams to monitor the fleet and convert repeated one-off analyses into supported datasets.
Work directly with firmware, GNC, battery, systems engineering, flight operations, and MRO teams to define logging, alerting, and signal-quality requirements.

Desired Qualifications

At least 5 years of relevant data engineering experience, including ownership of an on-call or operationally critical data system.
Experience with infrastructure as code using Terraform and deployment pipelines in GitLab CI or an equivalent platform.
Experience with transformation frameworks such as dbt and data quality or testing frameworks.
Experience with high-volume time-series or sensor telemetry and observability tools such as Grafana or CloudWatch, including alert design that avoids alarm fatigue.
Experience with aerospace, automotive, or robotics telemetry and flight or vehicle test data.
Experience with embedded logging formats and decoding raw device logs, including CAN, serial, or proprietary binary packet formats.
Experience with FAA aircraft certification or continued airworthiness processes.
Interest in RC planes, quadcopters, or aviation.

Salary Range: 60 to 70 (Currency: USD) (Pay period: per-hour-wage)

Pivotal is the leader in the emerging market of electric Vertical Takeoff and Landing (eVTOL) aircraft. We design, develop, and manufacture light eVTOL aircraft and are renowned for the BlackFly aircraft the world's first light eVTOL to fly manned missions and enter the consumer market.

Efficient, compact, and simple, Pivotal aircraft are designed for a wide range of consumer, public service, and defense applications. Our distinctive tilt-aircraft architecture and scalable platform have been flying for over 10 years. Last year we announced our next-generation aircraft, the Helix, which is rapidly progressing toward general release and scalable production in 2026.

Mobility is one of the most highly-valued areas of modern technology investments. This is the right company, in the right space, the right strategy, at the right time. If you are ready for adventure, we invite you to join our amazing team and grow with us.

Pivotal is seeking a Data Engineer to build and operate the flight data warehouse — the system of record for telemetry off every aircraft in the fleet. Flight logs land continuously from customer and test aircraft; you will turn them into curated datasets, automated fleet health alerts, and dashboards that the firmware, GNC, battery, flight operations, and MRO teams rely on to make airworthiness and design decisions. This is a small team building production infrastructure, so you will own pipelines end to end: the data model, the services that run on it, the infrastructure as code that deploys them, and the monitoring that tells us when they break.

Responsibilities

Pipeline development: Build and maintain the ingest and transformation pipelines that land aircraft telemetry from S3 into the flight data warehouse (AWS Glue, Athena), including schema evolution as firmware logging changes.
Data modeling: Design and maintain curated marts — flight runs, component flight hours, vehicle modes, battery flight features — in SQL, with clear grain, documented lineage, and idempotent incremental refresh.
Fleet alerting services: Develop and operate the Python services that evaluate flight-by-flight health checks and deliver alerts to engineering and customer-facing channels via SNS and Slack.
Data quality: Own the automated quality gates — mart freshness, source-to-mart reconciliation, and watermark integrity — and block deploys that would publish incorrect fleet data.
Analytics enablement: Build the dashboards and query interfaces engineering teams use to monitor the fleet, and convert repeated one-off analyses into supported datasets.
Collaboration: Work directly with firmware, GNC, battery, systems engineering, flight operations, and MRO to define what gets logged, what gets alerted on, and what “good” looks like for each signal.

Qualifications

Bachelor’s degree in Computer Science, Computer/Electrical Engineering, or a related technical discipline
3+ years of professional data engineering experience building and operating production pipelines
Strong SQL, including window functions and query tuning on a distributed, columnar engine (Athena/Trino/Presto, Spark, Snowflake, or BigQuery)
Proficient in Python for production services — not just notebooks: packaging, dependency management, unit tests, and code review
Hands-on experience with the AWS data stack: S3, Glue, Athena, Lambda, SNS, CloudWatch, and IAM
Dimensional modeling and warehouse design, including partitioning strategy for large tables
Excellent analytical and written communication skills, with the ability to work across multidisciplinary teams

Preferred Qualifications

5+ years of relevant data engineering experience, including ownership of an on-call or operationally critical data system
Infrastructure as code with Terraform, and building deployment pipelines in GitLab CI or equivalent
Transformation frameworks such as dbt, and data quality/testing frameworks
High-volume time-series or sensor telemetry, and observability tooling (Grafana, CloudWatch, or similar), including alert design that avoids alarm fatigue

Familiarity/experience with one or more of the following

Aerospace, automotive, or robotics telemetry and flight/vehicle test data

Embedded logging formats and decoding raw device logs (CAN, serial, or proprietary binary packet formats)

FAA aircraft certification or continued airworthiness processes

Interest in RC planes, quadcopters, or aviation

Applicants must be eligible for employment in the United States and willing to work onsite at our HQ office in Palo Alto, CA.

Pivotal offers a comprehensive benefits package, including medical, dental, vision, and 401k plans.

Pivotal is an Equal Opportunity Employer. Pivotal does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.

About the Company

Pivotal Software

Modernizes apps and infrastructure using Kubernetes

Pivotal, now part of VMware Tanzu, helps organizations modernize apps and infrastructure to speed software delivery and improve reliability using Kubernetes. Its products center on Kubernetes platforms and management, including Tanzu Kubernetes Grid, Tanzu Mission Control, Tanzu Observability, Tanzu Service Mesh, and Tanzu Labs consulting. These tools provide an integrated, enterprise-grade Kubernetes stack with built-in DevSecOps, security, and observability, plus consulting to upgrade legacy systems. The goal is to enable seamless multi-cloud deployments, accelerate delivery, and modernize applications across complex IT environments.

Company size: 201-500
Company stage: IPO
Headquarters: San Francisco, CA
Founded: 2013

Recently Posted Jobs

Explore more opportunities at Pivotal Software

See more jobs