Data Engineer

Job Type
Full-time

Description

On April 28, 2021, Avelo took flight as America’s first new airline in nearly 15 years – ushering in a new era of affordable, convenient, and reliable air travel. Founded and led by airline industry veteran, Andrew Levy, along with a team of world-class airline executives, we endeavored to build a different and better kind of airline with one mission in mind: “To inspire travel” and we’ve done so with industry-leading reliability and a caring Soul of Service. If you are looking for the opportunity to join a new and exciting airline that offers the chance to make your mark on aviation history, keep reading!

Purpose: The Data Engineer contributes to the design, development, and operation of the data infrastructure that powers our analytics and AI capabilities. Microsoft Fabric is the centerpiece of this role: you will help build and maintain notebook-based data pipelines, collaborate with analysts and Power BI developers, and grow your skills on a modern cloud data platform. This is a role for someone who is curious, detail-oriented, and ready to develop into a full-stack data engineering practitioner.

Core Responsibilities

- Pipeline & Notebook Development

- Assist in building and maintaining data pipelines under the guidance of senior engineers
- Write and maintain PySpark, Python, and SQL code for data ingestion, transformation, and loading
- Support implementation of medallion data architecture patterns (e.g., Bronze - Silver - Gold) to deliver clean, reliable datasets to downstream consumers
- Learn and apply software engineering best practices including version control, code review, and automated testing
- Participate in troubleshooting pipeline issues and help identify root causes
- Document data workflows, tables, and processes following established team standards

2. Data Quality & Observability

- Perform routine data quality checks to ensure accuracy, completeness, and consistency of datasets
- Define and implement automated data quality checks embedded directly into pipeline logic
- Support monitoring of pipeline health including data freshness, error rates, and row counts
- Help maintain documentation of data flows, schema changes, and source-system agreements

3. Platform Support

- Assist in maintaining and monitoring the cloud data platform environment
- Configure and enforce workspace-level access controls, row-level security (RLS), data encryption, and compliance policies; partner with IT Security on audit and certification requirements
- Track Fabric product updates and evaluate new capabilities (e.g., Real-Time Intelligence, Direct Lake, Fabric APIs); advocate for adoption where there is clear business value.
- Document all platform configurations, data flows, and operational runbooks in Microsoft Purview; maintain an accurate organizational data catalog and lineage map.

4. Collaboration & Communication

- Partner with analysts and BI developers to understand data requirements and deliver consistent, well-structured, documented datasets
- Translate business questions into defined data tasks with guidance from senior team members
- Participate in code reviews and contribute to shared repositories
- Communicate progress, questions, and blockers clearly to teammates and stakeholders

5. AI-Augmented Development

- Use AI development tools (Claude, Microsoft Copilot) as coding and documentation aids; apply critical review to all AI-generated outputs before committing to production
- Maintain awareness of AI data privacy obligations; escalate concerns to senior team members when appropriate

Requirements

Education & Experience:

- Bachelor's or Master's degree in Engineering, Computer Science, Mathematics, Data Science, or a related field; or equivalent practical experience
- 1-3 years of hands-on experience in data engineering, analytics engineering, software development, or a closely related technical role
- Demonstrated experience writing SQL queries and Python scripts for data processing or analysis
- Familiarity with at least one cloud data platform (Fabric, Azure, AWS, or GCP) through coursework, projects, or professional work
- Experience with Git or another version control system

Skills & Attributes:

- Solid foundation in SQL; comfortable writing joins, aggregations, and transformations independently
- Working knowledge of Python for data processing or automation tasks
- Understanding of core data concepts: relational vs. warehouse databases, schemas, data types, and basic data modeling
- Strong written and verbal communication; able to ask precise questions and explain your reasoning to both technical and non-technical audiences
- Systematic approach to troubleshooting -- investigates root causes rather than symptoms, and documents findings for future reference
- Genuine curiosity about data infrastructure and eagerness to learn new tools and platform capabilities
- Comfortable operating in a fast-moving environment where tools, features, and priorities evolve

X Factors:

Strong candidates will stand out in one or more of the following areas:

- Hands-on experience with Microsoft Fabric (workspaces, lakehouses, warehouses, or notebooks)
- Familiarity with the Azure data stack: Azure Data Factory, Azure Synapse Analytics, or Azure Data Lake Storage
- Experience with PySpark or distributed data processing frameworks (Databricks, Spark)
- Exposure to medallion architecture or equivalent layered data design patterns (Bronze/Silver/Gold)
- Familiarity with Microsoft Purview for data cataloging, lineage, or governance
- Exposure to real-time or near-real-time ingestion patterns (Eventstream, Kafka, Event Hubs)
- Experience in a regulated or operationally critical industry (aviation, finance, healthcare) where data reliability directly impacts business outcomes
- Prior exposure to AI-augmented or agentic workflows in a data engineering context

May perform other responsibilities as assigned. Responsibilities and duties may change when circumstances dictate (e.g., emergencies, changes in workload, etc.).

Avelo is an equal opportunity employer.

Salary Description
$85,000-$95,000 annually