Data Engineer

Air Apps; San Francisco (CA); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Apple hardware ecosystem for work.

Annual Bonus

Medical Insurance (vision & dental)

Disability insurance - short and long‑

401k up to 4%

Air Conference

Transportation budget

Free meals at the hub

Gym membership

Job summary

Air Apps is seeking a Data Engineer to design, build, and optimize data pipelines, warehouses, and lakes. You’ll work with analysts, scientists, and engineers to create scalable data infrastructure powering BI and ML initiatives.

Bring 4+ years of data engineering or related experience, strong SQL/Python/Scala skills, and hands-on cloud data experience. Knowledge of Airflow, dbt, and big data frameworks is highly valued in a fast-paced, mission-driven environment.

Qualifications

• 4+ years of experience in data engineering, software engineering, or database management.
• Proficiency in SQL, Python, or Scala for data processing and automation.
• Hands-on experience with cloud-based data solutions (AWS Redshift, Google BigQuery, Azure Synapse, Snowflake).
• Experience building ETL pipelines with tools such as Apache Airflow, dbt, Talend, or Fivetran.
• Strong understanding of data modeling, schema design, and database optimization.
• Experience with big data frameworks (Apache Spark, Hadoop, Kafka, Flink) is a plus.
• Familiarity with orchestration tools, containerization (Docker, Kubernetes), and CI/CD workflows.
• Knowledge of data security, governance, and compliance (GDPR, CCPA, SOC 2).
• Strong problem-solving and debugging skills with the ability to handle large-scale data challenges.
• Experience working in fast-paced, data-driven environments with cross-functional teams.

Responsibilities

• Design, build, and maintain scalable data pipelines and ETL workflows to support analytics and reporting.
• Develop and optimize data warehouses and data lakes using cloud platforms such as AWS, Google Cloud, or Azure.
• Implement real-time and batch data processing solutions for various business needs.
• Work with structured and unstructured data, ensuring proper data modeling and storage strategies.
• Ensure data reliability, consistency, and scalability through best practices in architecture and engineering.
• Collaborate with data analysts, scientists, and software engineers to enable efficient data access and analysis.
• Automate data ingestion, transformation, and validation processes to improve data quality.
• Monitor and optimize query performance and data processing efficiency.
• Implement security, compliance, and governance standards for data storage and access control.
• Stay up to date with emerging data engineering trends, tools, and technologies.

Skills

SQL

Python

Scala

Cloud-based data solutions

ETL pipelines

Airflow

dbt

Data modeling

Big data frameworks

Docker

Kubernetes

GDPR/CCPA/SOC 2

Tools

AWS Redshift

Google BigQuery

Azure Synapse

Snowflake

Apache Airflow

dbt

Talend

Fivetran

Apache Spark

Hadoop

Kafka

Flink

Docker

Kubernetes

Job description

About Air Apps

At Air Apps, we believe in thinking bigger—and moving faster. We’re a family-founded company on a mission to create the world’s first AI-powered Personal & Entrepreneurial Resource Planner (PRP), and we need your passion and ambition to help us change how people plan, work, and live. Born in Lisbon, Portugal in 2018—and now with offices in both Lisbon and San Francisco—we’ve remained self-funded while reaching over 100 million downloads worldwide.

Our long-term focus drives us to challenge the status quo every day, pushing the boundaries of AI-driven solutions that truly make a difference. Here, you’ll be a creative force, shaping products that empower people across the globe.

Join us on this journey to redefine resource management—and change lives along the way.

The Role

As a Data Engineer at Air Apps, you will be responsible for designing, building, and optimizing data pipelines, data warehouses, and data lakes to ensure efficient data processing and analytics. You will work closely with data analysts, scientists, and software engineers to create scalable and reliable data infrastructure that supports business intelligence and machine learning initiatives.

This role requires expertise in data architecture, ETL processes, and cloud-based data solutions to handle large volumes of structured and unstructured data.

Responsibilities

• Design, build, and maintain scalable data pipelines and ETL workflows to support analytics and reporting.

• Develop and optimize data warehouses and data lakes using cloud platforms such as AWS, Google Cloud, or Azure.

• Implement real-time and batch data processing solutions for various business needs.

• Work with structured and unstructured data, ensuring proper data modeling and storage strategies.

• Ensure data reliability, consistency, and scalability through best practices in architecture and engineering.

• Collaborate with data analysts, scientists, and software engineers to enable efficient data access and analysis.

• Automate data ingestion, transformation, and validation processes to improve data quality.

• Monitor and optimize query performance and data processing efficiency.

• Implement security, compliance, and governance standards for data storage and access control.

• Stay up to date with emerging data engineering trends, tools, and technologies.

Requirements

• Around 4+ years of experience in data engineering, software engineering, or database management.

• Proficiency in SQL, Python, or Scala for data processing and automation.

• Hands‑on experience with cloud-based data solutions (AWS Redshift, Google BigQuery, Azure Synapse, Snowflake).

• Experience building ETL pipelines with tools such as Apache Airflow, dbt, Talend, or Fivetran.

• Strong understanding of data modeling, schema design, and database optimization.

• Experience with big data frameworks (Apache Spark, Hadoop, Kafka, Flink) is a plus.

• Familiarity with orchestration tools, containerization (Docker, Kubernetes), and CI/CD workflows.

• Knowledge of data security, governance, and compliance (GDPR, CCPA, SOC 2).

• Strong problem-solving and debugging skills with the ability to handle large‑scale data challenges.

• Experience working in fast‑paced, data‑driven environments with cross‑functional teams.

What benefits are we offering?

• Apple hardware ecosystem for work.

• Annual Bonus.

• Medical Insurance (including vision & dental).

• Disability insurance - short and long‑term.

• 401k up to 4% contribution.

• Air Conference – an opportunity to meet the team, collaborate, and grow together.

• Transportation budget

• Free meals at the hub

• Gym membership

Diversity & Inclusion

At Air Apps, we are committed to fostering a diverse, inclusive, and equitable workplace. We enthusiastically welcome applicants from all backgrounds, experiences, and perspectives. We celebrate diversity in all its forms and believe that varied voices and experiences make us stronger.

Application Disclaimer

At Air Apps, we value transparency and integrity in our hiring process. Applicants must submit their own work without any AI-generated assistance. Any use of AI in application materials, assessments, or interviews will result in disqualification.