Data Engineer - Flight Data (contract)

Posted Yesterday
Palo Alto, CA, USA
In-Office
Mid level
Professional Services • Social Impact
The Role
Build and operate Pivotal’s flight data warehouse and telemetry pipelines using AWS Glue, Athena, SQL, and Python. Design curated data marts, fleet health alerting services, data quality gates, dashboards, and query interfaces. Own data infrastructure, deployment, monitoring, and schema evolution end to end while collaborating with firmware, GNC, battery, flight operations, systems engineering, and MRO teams on telemetry and airworthiness decisions.
Summary Generated by Built In
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

Attributes aligned with Core Values

  • Safety Above All: Demonstrates a proactive safety mindset by embedding safety into daily work, identifying and mitigating risks, encouraging open dialogue about safety concerns, and continuously improving practices and protocols.
  • Customer Focus: Puts customers at the center of every action by understanding their challenges, delivering meaningful value, and supporting their success.
  • Work Better Together: Seeks and values diverse perspectives, builds cross-functional relationships, and fosters trust through empathetic, fact-based communication and commitment to shared decisions.
  • Be the Pilot: Drives results with clarity and purpose by focusing on what matters most, adapting to change, taking initiative, and owning outcomes.
  • Embrace the Unknown: Navigates ambiguity with resilience and bold thinking, challenges the status quo, and combines innovative ideas with practical approaches to overcome obstacles and drive progress.
  • Respect for People: Fosters a high-performance culture grounded in respect, professionalism, and support by balancing high expectations with a healthy, collaborative environment and being a trusted, dependable teammate.

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.

Skills Required

  • Bachelor's degree in Computer Science, Computer Engineering, Electrical Engineering, or a related technical discipline
  • 3+ years of professional data engineering experience building and operating production pipelines
  • Strong SQL skills, including window functions and query tuning on distributed columnar engines
  • Proficiency in Python for production services, including packaging, dependency management, unit testing, and code review
  • Hands-on experience with AWS S3, Glue, Athena, Lambda, SNS, CloudWatch, and IAM
  • Experience with dimensional modeling and data warehouse design, including partitioning strategies for large tables
  • Excellent analytical and written communication skills with the ability to work across multidisciplinary teams
  • 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 using GitLab CI or equivalent
  • 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
  • Familiarity with aerospace, automotive, or robotics telemetry and flight or vehicle test data
  • Experience decoding embedded logging formats and raw device logs, including CAN, serial, or proprietary binary formats
  • Familiarity with FAA aircraft certification or continued airworthiness processes
  • Interest in RC planes, quadcopters, or aviation
  • Eligibility for employment in the United States
  • Willingness to work onsite at the headquarters office in Palo Alto, California
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Redmond, WA
259 Employees
Year Founded: 2001

What We Do

Pivotal, founded by Melinda French Gates, is a group of organizations dedicated to accelerating social progress for women and young people globally. Through a combination of philanthropy, strategic investments, and advocacy, the organization works to drive momentum in areas with the greatest potential for impact. By supporting leaders and innovative ideas, Pivotal aims to expand women's power and influence, ultimately fostering a more equitable and inclusive future for everyone.

Similar Jobs

ServiceNow Logo ServiceNow

Senior Manager, Data Platform Engineering - Kubernetes - Distributed Systems

Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Remote or Hybrid
San Diego, CA, USA
29000 Employees
181K-317K Annually

BuildOps Logo BuildOps

Sales Development Representative

Cloud • Mobile • Software
Easy Apply
Hybrid
Los Angeles, CA, USA
500 Employees
85K-85K Annually

The Aerospace Corporation Logo The Aerospace Corporation

Sr Advanced Mechanical Design Enginee

Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Hybrid
2 Locations
4600 Employees
117K-146K Annually

Samsara Logo Samsara

Business Systems Analyst

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
USA
4000 Employees
111K-150K Annually

Similar Companies Hiring

Camber Thumbnail
Fintech • Healthtech • Social Impact
New York, New York
90 Employees
Sailor Health Thumbnail
Healthtech • Social Impact • Telehealth
New York City, NY
20 Employees
Playground (tryplayground.com) Thumbnail
Kids + Family • Payments • Social Impact • Software
New York City, New York
80 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account