Air

Subscription-based digital asset management for marketers

Data Engineer - Analytics

Data EngineeringPosted on Nov 12

Full-timePittsburgh, PA, USANo salary listed

About the Job

Requirements

U.S. citizenship is required.
Have at least 3 years of experience writing, maintaining, and optimizing production-grade SQL, including common table expressions, correlated and non-correlated subqueries, and window functions.
Have at least 3 years of data modeling experience, including knowledge of star and snowflake schemas and the distinction between dimensions and facts.
Have at least 3 years of experience writing extract, transform, load pipelines and experience with Airflow, Dagster, Prefect, or a similar orchestration tool.
Have 1–3 or more years of Python experience for pipelines, data science, or applications.
Have hands-on experience in at least one startup or technology data domain: Finance, Pipeline/Funnel, Product Analytics, or Operations.
Be able to understand how end-user engagement with an application relates to conversion and revenue.
Demonstrate the ability to work collaboratively and deliver independently.
Use sound judgment and attention to detail when validating complex relationships and resolving ambiguous cases.
Have written communication skills sufficient to document decisions with clear reasoning and auditable source support.
Be able to prioritize, triage, and execute quickly while maintaining consistent quality.
Have stakeholder communication skills and the ability to coordinate across multiple workstreams.
Pay close attention to detail when validating data accuracy.

Responsibilities

Collaborate with software engineers, product managers, and client-facing teams to understand client requirements and translate them into technical solutions.
Lead the 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 of new feature functionality and design capabilities.
Optimize processes for speed and accuracy.
Seek innovation and continuous improvement, finding efficiencies in assigned tasks.
Source enterprise data from business systems and the core application, then transform it into a scalable data model that delivers key insights.
Maintain high-confidence accuracy across each stage of the medallion architecture and ensure tooling and the data model scale with growth.
Execute, deliver, and validate key data pipelines that inform go-to-market, Operations, Product, and Engineering decisions.

Desired Qualifications

Have current possession of a U.S. security clearance or be able to obtain one with employer sponsorship.
Have experience in or exposure to a startup or other entrepreneurial environment.
Have experience with a business intelligence tool such as Tableau, Looker, or Sigma.
Have exposure to data governance practices, including source of truth, role-level security, permissions, and roles.

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.

Job Description

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

Qualifications

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.

Air is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans status or any other characteristic protected by law.

Air