Staff Business Intelligence Engineer, Archer

Enterprise & Telemetry Data

$163.2-204k

SQL

AWS

Kubernetes

Python

Looker

Kafka

Airflow

Terraform

Salesforce

Power BI

Redshift

Spark

Snowflake

Flink

BigQuery

Parquet

SAP

dbt

Expert level

San Francisco Bay Area

More information about location

Office located in San Jose, CA

Urban air mobility developer

Be an early applicant

Urban air mobility developer

501-1000 employees

B2CSustainabilityTransportManufacturingFlightsAerospace

Be an early applicant

$163.2-204k

SQL

AWS

Kubernetes

Python

Looker

Kafka

Airflow

Terraform

Salesforce

Power BI

Redshift

Spark

Snowflake

Flink

BigQuery

Parquet

SAP

dbt

Expert level

San Francisco Bay Area

More information about location

Office located in San Jose, CA

501-1000 employees

B2CSustainabilityTransportManufacturingFlightsAerospace

Company mission

To accelerate the benefits of sustainable air mobility.

Job

Company

Role

Who you are

10+ years in Business Intelligence, Data Engineering or Analytics Engineering roles
BS or MS in Computer Science, Software Engineering, Data Science or similar
Expert-level SQL plus strong Python; solid grasp of software engineering principles
Depth in Sigma, Superset or Power BI, from data prep through interactive dashboards
Proven success building and orchestrating pipelines with Airflow or Prefect at scale
Hands-on experience modeling and querying data in Snowflake, Amazon Redshift, BigQuery or Trino/Presto
Familiarity with manufacturing, finance or supply-chain data (SAP, Salesforce, MES, ERP schemas)
Understanding of time-series / telemetry concepts and how to harmonize them with enterprise data
Strong communication skills; comfort translating business requirements into technical designs and vice-versa

Desirable

Experience with dbt, Airbyte, Looker/LookML or semantic-layer tooling
Knowledge of streaming frameworks (Kafka, Spark Structured Streaming, Flink)
Exposure to Kubernetes, Terraform, AWS analytics services (Glue, Lake Formation)
Background in aerospace, automotive or other highly regulated industries

What the job involves

As a Staff Business Intelligence Engineer you will make those diverse data sources trusted, modeled and visualized so every team can move faster and smarter
Design and code robust ELT/ETL pipelines in Python and SQL using Airflow or Prefect to integrate data from SAP, Salesforce, MES, PLM, sensor logs and more
Develop intuitive dashboards and self-service reports in Sigma, Apache Superset and similar tools; evangelize data-visualization best practices
Build and maintain dimensional and star schemas, data marts and semantic layers that serve analytics, reporting and GenAI workloads
Optimize query performance and storage costs in Snowflake, Redshift, Trino and related lakehouse architectures (Parquet / Iceberg)
Collaborate with Finance, Manufacturing, Flight-Test, Supply-Chain and Engineering stakeholders to translate business questions into data models and metrics
Implement data quality, lineage and governance (tests, SLAs, documentation, role-based access) to ensure trust and compliance
Apply LLM / GenAI techniques—such as metadata enrichment, automated documentation and conversational analytics—to accelerate insight delivery
Mentor analysts and engineers; lead design and code reviews; champion a culture of continuous improvement

Our take

Electric air taxis may sound like a pipedream, but companies like Archer are in the process of testing models that they hope to begin producing at scale in 2025. Designed to be quiet and efficient, its current model can fly at speeds of 150 miles per hour and cover 60 miles per flight. With urban transport in mind, these air taxis are both greener and vastly more efficient than traditional vehicles.

Given the congestion and pollution issues that many cities are facing, it's easy to imagine such transport taking over. It’s also worth noting that although Archer plans to run them with human pilots initially, the company has automation as part of its long-term goals.

Other players exist in this space: EHang, a Chinese firm, flew its first aerial taxi in America in 2020. However, Archer has big backers and customers such as United Airlines (acting both as an investor and launch customer) and manufacturing partner Stellantis with whom it is mass-producing its flagship Midnight eVTOL aircraft.

There's certainly a growing demand for clean transport without sacrificing speed, but many barriers still remain in Archer's way as it must help to initiate a seismic shift in transportation infrastructure and behaviors to reach mass adoption. That being said, it has the funding behind it, raising close to $2 billion in post-IPO funding since 2021.

Freddie

Company Specialist at Welcome to the Jungle

Insights

Top investors

44% employee growth in 12 months

Glassdoor (3.4)

Company

Funding (1 round)

Jul 2020

$55.7m

SERIES A

Total funding: $55.7m

Company HQ

Tasman and Zanker, San Jose, CA

Leadership

Adam Goldstein

(CEO)

Started their career in financial services, before co-founding Vettery, a talent marketplace, in 2012. Founded Archer in 2018.

Salary benchmarks

We don't have enough data yet to provide salary benchmarks for this role.

Submit your salary to help other candidates with crowdsourced salary estimates.

Share this job

View 28 more jobs at Archer