Zipline is seeking a Senior Data Analyst to join the Systems Engineering team, focusing on building system health and performance monitoring. The role involves designing analytics solutions, collaborating with engineers to track hardware and software health, and extracting insights from complex technical data to improve safety and fleet reliability. The analyst will work with data engineers, data scientists, and senior leadership to measure key company metrics and support data-driven decision-making across the organization.

Responsibilities

Design and build data analytics solutions, including monitoring dashboards, alerting tools, and ad hoc analyses, to track Zipline’s core flight reliability and safety metrics.
Collaborate with System Engineers and partner teams to track the health of hardware, software, and operational systems.
Create software scripts (in SQL and Python) to extract system performance data from raw flight logs.
Work autonomously with other Data Scientists and Analysts across the company to create and maintain shared data models in our data warehouse, ensuring company-wide access for analytics and reporting.
Ensure that we are following best practices for efficient data access across multiple technical systems.
Serve as a source of knowledge and expertise, assisting team members across the company in locating and reporting on their own data.

Requirements

5+ years of experience in data analysis or business intelligence, preferably related to hardware-software systems or operations.
Strong proficiency in data visualization tools such as Mode, ThoughtSpot, Looker, Tableau, PowerBI, or similar.
Experience writing SQL queries to extract, manipulate, and aggregate large datasets from relational databases, including complex joins, aggregations, and window functions, with the ability to optimize and debug queries for performance and readability.
Experience working with Snowflake’s cloud data platform or comparable data warehouse/data lake tools.
Excellent problem-solving and analytical skills.
Strong communication skills, with the ability to present complex data in a clear, concise manner to both technical and non-technical audiences.
Ability to work independently and manage multiple projects simultaneously.
Inherent self-motivation, adaptability, and creativity.

Nice to have

Experience using DBT to create data ETL pipelines.
Familiarity with Python for data analysis, including working with pandas, numpy, matplotlib, etc., and exploratory analysis in a Jupyter notebook environment.
Experience with GIS and spatial analysis.
Knowledge of GitHub and the ability to navigate a software pull request workflow.