Full Stack Data Engineer - Internal Flight Data Applications

Pivotal•Palo Alto, CA

5d•Onsite

About The Position

Pivotal is seeking a Full Stack Data Engineer to build the internal applications that put flight data directly in engineers' hands. This role involves working across the entire technology stack, from backend services querying a data platform to web front ends for data exploration, dashboards, AI-assisted tooling, and packaging analysis tools for engineer laptops. The position requires understanding user needs through direct conversation and delivering functional tools. It is ideal for an engineer early in their career seeking product ownership and direct interaction with the teams building and flying aircraft.

Requirements

2+ years of professional experience building and shipping web applications, from backend to front end.
Bachelor’s degree in Computer Science or a related technical discipline, or equivalent practical experience.
Proficiency in Python and comfortable writing SQL against a real database.
Experience with a modern JavaScript or TypeScript front-end framework (React, Vue, or similar).
Experience building and consuming HTTP APIs, including authentication, pagination, and error handling.
Comfort with Git-based workflows, code review, and CI/CD.
Ability to understand non-software engineers' needs through conversation and deliver functional tools.

Nice To Haves

AWS experience, particularly with S3, Athena, Lambda, or API Gateway.
Experience with large or time-series datasets and maintaining UI responsiveness over millions of rows.
Familiarity with charting and data visualization libraries; Grafana dashboard development.
Experience with Docker and infrastructure as code using Terraform.
Experience building with LLM APIs or agent frameworks, including tool use, retrieval over structured data, and output evaluation.
Experience building internal tools for colleagues.
Familiarity/experience with aerospace, automotive, or robotics telemetry, and flight or vehicle test data.
Experience packaging desktop or command-line tooling for non-developer users, including on Windows.
Experience with authentication and access control for internal applications (SSO, IAM, scoped credentials).
Experience in regulated or safety-critical environments with traceability and data retention requirements.
Experience with natural-language or conversational interfaces over structured, time-series, or diagnostic data.
Interest in RC planes, quadcopters, or aviation.

Responsibilities

Build and maintain internal web applications for engineers to work with flight data, including flight record browsers, query interfaces, and analysis tools.
Develop Python backend services and HTTP APIs that query Athena and S3 efficiently, handling pagination and caching for large datasets.
Create user interfaces that allow engineers to explore large telemetry datasets through sortable tables, filters, and time-series plots.
Develop AI-assisted tooling that enables engineers to ask questions in plain language and trace symptoms to root causes without manual query writing, ensuring underlying data and derivation methods are provided for verification.
Transform recurring one-off analyses from various engineering teams into supported, self-serve tools.
Generate and maintain an internal field guide and data catalog directly from the warehouse to ensure metadata accuracy and machine readability.
Build review and triage surfaces for fleet health alerts, including acknowledgment, history, and trend views.
Package and distribute analysis tooling for engineer laptops, including Windows, ensuring ease of setup.
Take ownership of work through deployment, including testing, code review, CI/CD, and monitoring.
Collaborate with engineering teams to understand their needs and document shipped products.