Data Engineer - Analytics

Air•Pittsburgh, PA
•Onsite

About The Position

Air is seeking an experienced Data Engineer to build and maintain data pipelines that deliver business insights and support company growth. The role sources data from business systems and Air’s core application, then transforms it into a scalable data model. The engineer will collaborate with technical and business stakeholders, maintain data accuracy throughout the medallion architecture, and ensure the tooling and data model can scale with the company. The role owns the execution, delivery, and validation of key pipelines that inform go-to-market, Operations, Product, and Engineering decisions. It is a full-time position based out of Air’s Pittsburgh, Pennsylvania office and may require up to 10% travel.

Requirements

  • U.S. citizenship is required.
  • At least 3 years writing, maintaining, and optimizing production-grade SQL for business functions and/or applications, including CTEs, correlated and non-correlated subqueries, and window functions.
  • At least 3 years of data modeling experience, including familiarity with star and snowflake schemas and the distinction between dimensions and facts.
  • At least 3 years writing ETL pipelines and experience with Airflow, Dagster, Prefect, or a similar orchestration tool.
  • 1–3+ years of Python experience for pipelines, data science, or applications.
  • Hands-on experience in at least one startup or technology data domain: Finance, Pipeline/Funnel, Product Analytics, or Operations.
  • Ability to understand how end-user application engagement relates to conversion and revenue.
  • Demonstrated ability to collaborate and deliver independently.
  • Sound judgment and attention to detail when validating complex relationships and resolving ambiguous cases.
  • Excellent written communication, including the ability to document decisions with clear reasoning and auditable source support.
  • Ability to prioritize, triage, and execute quickly while maintaining consistent quality.
  • Strong stakeholder communication and ability to coordinate across multiple workstreams.
  • Close attention to detail and data accuracy validation.

Nice To Haves

  • Current U.S. security clearance or ability to obtain one with company sponsorship.
  • Experience in or exposure to a startup or other entrepreneurial environment.
  • Experience with a business intelligence tool such as Tableau, Looker, or Sigma.
  • Exposure to data governance practices, including sources of truth, role-level security, permissions, and roles.

Responsibilities

  • Collaborate with software engineers, product managers, and client-facing teams to understand client requirements and translate them into technical solutions.
  • Lead deployment and integration of software and data solutions in client environments, ensuring smooth implementation and adherence to project timelines.
  • Participate in designing, building, and testing scalable data architecture.
  • Write clean, testable, and maintainable code.
  • Participate in end-to-end software development for new feature functionality and design capabilities.
  • Optimize processes for speed and accuracy.
  • Seek innovation and continuous improvement and find efficiencies in assigned tasks.
  • Build and maintain data pipelines, and own their execution, delivery, and validation.
  • Source and transform business-system and core-application data into scalable models that provide business insights.
  • Maintain high-confidence data accuracy across the medallion architecture and ensure the tooling and data model scale with growth.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service