Data Engineer - Real-Time Enterprise Pipelines (Pittsburgh)

Air

Pittsburgh (Allegheny County)

On-site

USD 110,000 - 150,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Air is seeking an experienced Data Engineer in Pittsburgh to build and maintain data pipelines that deliver key business insights. You will source data from business systems and the core application, transform it into scalable models, and partner with SMEs to ensure accuracy in the medallion architecture.

This full-time role requires collaboration with cross-functional teams and a focus on reliability, performance, and scalability as Air grows. Travel up to 10% may be required.

Qualifications

  • 3+ years of writing, maintaining, and optimizing Production grade SQL to support business functions and/or applications. Knows how to efficiently write CTEs, correlated and non-correlated subqueries, and window functions.
  • 3+ years of data modeling. Knows star and snowflake schemas and the difference between a dimension and a fact.
  • 3+ years writing ETL pipelines. Has used Airflow, Dagster, Prefect, or similar orchestration tools.
  • 1-3+ years of Python for pipelines, data science, or applications.
  • Has hands-on experience in at least one startup/tech data domain: Finance, Pipeline/Funnel, Product Analytics, Operations.
  • Ability to quickly understand how end user engagement with an application ties to conversion and revenue.
  • Demonstrated track record of working collaboratively and delivering independently.
  • Strong judgment and attention to detail when validating complex relationships and resolving ambiguous cases.
  • Excellent written communication — able to document decisions with clear reasoning and auditable source support.
  • Ability to prioritize, triage, and execute quickly while maintaining consistent quality.

Responsibilities

  • Collaborate with other software engineers, product managers, and client-facing teams to understand client requirements and translate them into technical solutions.
  • Lead the deployment and integration of our software and data solutions in client environments, ensuring smooth implementation and adherence to project timelines.
  • Actively participate in designing, building and testing scalable data architecture.
  • Craft clean, testable, and maintainable code.
  • Participate in the end-to-end software development of new feature functionality and design capabilities.
  • Optimize processes for maximum speed and accuracy.
  • Regularly seek out innovation and continuous improvement, finding efficiency in all assigned tasks.

Skills

SQL
Data modeling
ETL pipelines
Python
Startup experience
User engagement
Collaboration
Data accuracy
Documentation
Stakeholder comms

Tools

Airflow
Dagster
Prefect
Tableau
Looker
Sigma

Job description

Air is seeking an experienced Data Engineer in Pittsburgh to build and maintain data pipelines that deliver key business insights. You will source data from business systems and the core application, transform it into scalable models, and partner with SMEs to ensure accuracy in the medallion architecture.

This full-time role requires collaboration with cross-functional teams and a focus on reliability, performance, and scalability as Air grows. Travel up to 10% may be required.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer — Scalable Pipelines & Growth Impact
Data Engineer — Scalable Pipelines & Growth Impact

Archer • Pittsburgh

On-site
USD 100,000 - 140,000
Data Engineer: ETL Pipelines for Industrial Analytics (Pittsburgh)
Data Engineer: ETL Pipelines for Industrial Analytics (Pittsburgh)

MedTeam Staffing Inc. • Pittsburgh

Hybrid
USD 100,000 - 140,000
Data Engineer: Build Industrial Data Pipelines (Pittsburgh)
Data Engineer: Build Industrial Data Pipelines (Pittsburgh)

Talent With Heart • Pittsburgh

Hybrid
USD 120,000 - 150,000
Data Engineer: Enterprise Pipelines (On-Site, Pittsburgh)
Data Engineer: Enterprise Pipelines (On-Site, Pittsburgh)

Workforce Recruiter • Pittsburgh

Hybrid
USD 120,000 - 160,000
Data Engineer: Build Enterprise Data Pipelines (On-Site)
Data Engineer: Build Enterprise Data Pipelines (On-Site)

Professional Recruiting Consultants, Inc. • Pittsburgh

Hybrid
USD 90,000 - 140,000
Data Engineer: Industrial Pipelines & Analytics (On-Site)
Data Engineer: Industrial Pipelines & Analytics (On-Site)

CareerNerds, LLC • Pittsburgh

Hybrid
USD 100,000 - 140,000
Data Engineer: Build Robust Pipelines & Analytics (On-Site)
Data Engineer: Build Robust Pipelines & Analytics (On-Site)

Your Talent Team • Pittsburgh

Hybrid
USD 95,000 - 125,000
Industrial Data Engineer - ETL Pipelines & DW (On-Site PA)
Industrial Data Engineer - ETL Pipelines & DW (On-Site PA)

Job Juncture • Pittsburgh

Hybrid
USD 110,000 - 160,000
Data Engineer On-site ETL Pipelines for Industrial Analytics
Data Engineer On-site ETL Pipelines for Industrial Analytics

Client Growth Resources, Inc • Pittsburgh

Hybrid
USD 100,000 - 150,000
Data Engineer - On-Site: Build Enterprise Data Pipelines
Data Engineer - On-Site: Build Enterprise Data Pipelines

Talent Solutions Partners • Pittsburgh

Hybrid
USD 120,000 - 160,000