You and the process

With a person
Anna, in-house recruiter
9 years hiring engineers
30 minutes with a real recruiter
They read your CV with you, on a call, and say where the offers are being lost.
Didn’t find what you were looking for? Tell us what to build
Air

Data Engineer - Analytics

  • Office
  • 3-6 years

Salary

Not stated

Similar roles pay $80K - 175K a year · our estimate

AI summary

For members

The whole posting in a few lines. Sign up to read it here and on every role you open.

Sign Up to Read

Description

Company Description

Air is the leader in Enterprise Readiness. Our mission is to establish readiness as a real-time condition that is continuously achieved. Today, a dangerous Readiness Gap exists between what the front line needs and what is delivered. Our AI-native platform, Air Enterprise Readiness, aligns development, production, delivery, and sustainment into one coordinated execution system for government agencies and industrial suppliers. By revealing true capacity, exposing real constraints, coordinating resources, and executing at the speed of operational demands, the front line gets what it needs to succeed.

We are seeking an exceptional and experienced Data Engineer team member, a role for someone who shares our passion and obsession with shipping insightful and accurate data. You will be a core member of our team dedicated to helping drive our growth by building and maintaining data pipelines that deliver key business insights. The ideal candidate is an analytically minded engineer with large dataset experience. You must also possess strong interpersonal skills to work cross-functionally across internal teams and with Air platform Subject Matter Experts (SMEs).

You will support the proliferation of our enterprise data by sourcing data from business systems and our core application, and transforming that into a scalable data model delivering key insights. This role involves collaborating with technical and business stakeholders, maintaining high-confidence accuracy across every stage of our medallion architecture, and ensuring our tooling and data model scales to meet growth. You will own the execution, delivery, and validation of key data pipelines driving GTM, Operations, Product, and Engineering decisions.

This role is a full-time position located out of our office in Pittsburgh, PA.

This role may require up to 10% travel

Scope of 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

Requirements

  • U.S. Citizenship is required
  • Required Skills:
  • 3+ years of writing, maintaining, and optimizing Production grade SQL to support business functions and/or applications. Knows how to efficiently write CTE’s, 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
  • Strong stakeholder communication skills and the ability to coordinate across multiple workstreams
  • Close attention to detail and validating data accuracy
  • Desired Skills:
  • Current possession of a U.S. security clearance, or the ability to obtain one with our sponsorship
  • Experience in or exposure to the nuances of a startup or other entrepreneurial environment
  • Experience with a Business Intelligence tool (Tableau, Looker, Sigma, etc.)
  • Exposure to Data Governance practices (Source of Truth, Role Level Security, permissions and roles)
  • We firmly believe that past performance is the best indicator of future performance. If you thrive while building solutions to complex problems, are a self-starter, and are passionate about making an impact in global security, we’re eager to hear from you.

Where you’d work

From the office

No visa sponsorship

About the company

Air

Office in Pittsburgh, United States

Also hiring in Arlington, United States

3 of their 8 open roles are remote

Your chances

We've checked whether it's still hiring and how crowded it is.

  • 19 checks run
  • 0 red flags

Still hiring?

13 checks

No red flags

How crowded?

6 checks

No red flags

Fits Me

How well does this role fit you?

Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.

  • Your field
  • Level
  • Stack
  • Work model
  • Salary floor
  • Must-haves
Details11 facts · Role, Location, Compensation, Employment
Tech stack
  • Python
  • SQL
  • Tableau
  • Looker
  • Snowflake
  • Airflow
Type
Full-time
Specialty
Data Engineering
Region
United States
Pay period
Annual
Show 6 more factsShow less

Role

Category
Data & Analytics
Specialty
Data Engineering
Experience
3+ years
Tech stack
  • Python
  • SQL
  • Tableau
  • Looker
  • Snowflake
  • Airflow

Location

Work model
Office
Region
United States
Office
  • Pittsburgh, United States
Visa sponsorship
Not sponsored

Compensation

Salary
Salary by agreement
Pay period
Annual

Employment

Type
Full-time

Something wrong with this vacancy?

Similar vacancies

Share this vacancy

What's wrong with it?

The employer never sees who reported.

Reason