Senior Data Analyst

About You and The Role

We are looking for a highly motivated and skilled Data Analyst to build out system health and performance monitoring within the Systems Engineering team, working closely with the team’s Data Engineers and Data Scientists. This role will play a key part in identifying critical fleet issues, improving safety, and removing barriers to Zipline’s growth. The successful candidate will work closely with engineers across Zipline, helping them understand the performance of their systems and how they relate to others, as well as senior leadership, assisting in measuring key company metrics. The ideal candidate has deep experience in data analytics, particularly in monitoring real-world hardware and/or operations, and can work adeptly with both highly technical and non-technical stakeholders to extract actionable insights from complex technical data.

What You’ll Do

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

What You’ll Bring

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

Preferred but Not Required:

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

What Else You Need to Know

Zipline is an equal opportunity employer and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws or our own sensibilities.

We value diversity at Zipline and welcome applications from those who are traditionally underrepresented in tech. If you like the sound of this position but are not sure if you are the perfect fit, please apply!