Staff Business Intelligence Engineer – Enterprise & Telemetry Data at Archer

San Jose, California, United States

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years), Expert & Leadership (9+ years)Experience Level

Full TimeJob Type

UnknownVisa

AerospaceIndustries

Requirements

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
Bonus Requirements
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

Responsibilities

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

Skills

Python

SQL

Airflow

Prefect

Sigma

Apache Superset

Snowflake

Redshift

Trino

SAP

Salesforce

ETL

Data Modeling

GenAI

LLM

Archer

Designs and develops electric vertical takeoff aircraft

About Archer

Archer designs and develops electric vertical takeoff and landing (eVTOL) aircraft aimed at transforming urban transportation. Their aircraft operate by taking off and landing vertically, which allows them to navigate congested city environments efficiently. Archer targets urban commuters, city planners, and transportation networks, offering eco-friendly solutions to improve urban mobility. Unlike traditional transportation methods, Archer's eVTOLs provide a sustainable alternative that reduces environmental impact. The company generates revenue through the sale of its aircraft and may also offer air taxi services in the future. Archer's goal is to lead the shift towards sustainable air mobility, making urban commuting more efficient and environmentally friendly.

Palo Alto, CaliforniaHeadquarters

2020Year Founded

$637.8MTotal Funding

IPOCompany Stage

Automotive & TransportationIndustries

1,001-5,000Employees

Benefits

Performance Bonus

Risks

Regulatory challenges from FAA and DOT may delay operational plans.

Increased competition from companies like Joby Aviation could impact market share.

Reliance on strategic partnerships poses risks if expectations are not met.

Differentiation

Archer focuses on sustainable urban air mobility with all-electric eVTOL aircraft.

The company targets urban commuters with eco-friendly, time-saving air taxi services.

Archer's strategic partnerships enhance its market reach and operational capabilities.

Upsides

Archer secured $430M funding, strengthening its financial position for growth.

FAA approval for LA air taxi services positions Archer for urban mobility leadership.

Planned LA air mobility network could significantly reduce commuter travel times.

Land your dream remote job 3x faster with AI

Try Jobo Free