Staff Business Intelligence Engineer - Enterprise & Telemetry Data

Archer is an aerospace company based in San Jose, California building an all-electric vertical takeoff and landing aircraft with a mission to advance the benefits of sustainable air mobility. We are designing, manufacturing, and operating an all-electric aircraft that can carry four passengers while producing minimal noise.

Our sights are set high and our problems are hard, and we believe that diversity in the workplace is what makes us smarter, drives better insights, and will ultimately lift us all to success. We are dedicated to cultivating an equitable and inclusive environment that embraces our differences, and supports and celebrates all of our team members.

What you'll do

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.

What you need:

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).

At Archer we aim to attract, retain, and motivate talent that possess the skills and leadership necessary to grow our business. We drive a pay-for-performance culture and reward performance that supports the Company's business strategy. For this position we are targeting a base pay between $163,200.00 - $204,000.00. Actual compensation offered will be determined by factors such as job-related knowledge, skills, and experience.

Archer is committed to working with and providing reasonable accommodations to job applicants with physical or mental disabilities, and those with sincerely held religious beliefs. Applicants who may require reasonable accommodation for any part of the application or hiring process should provide their name and contact information to Archer's People Team at people@archer.com. Reasonable accommodations will be determined on a case-by-case basis.

Information collected and processed as part of any job applications you choose to submit is subject to Archer's Candidate Privacy Policy.

Archer is unable to provide work visa sponsorship for this position at the present time.

Archer is proud to be an Equal Opportunity employer committed to diversity and inclusivity in the workplace. All aspects of employment are decided on the basis of merit, qualifications, and business needs. We do not discriminate based upon race, color, religion, sex, sexual orientation, age, national origin, disability status, protected veteran status, gender identity or any other characteristic protected by federal, state or local laws.

Archer Aviation does not engage with external recruiting agencies/individual recruiters with whom it does not have a prior written agreement. Archer reserves the right to make use of any unsolicited resumes that it receives and bears no responsibility for payment of any fees asserted from the use of unsolicited resumes. If you are a recruiting agency or individual recruiter wishing to do business with Archer, please reach out to People@archer.com. All employment processes are managed by the Archer People Team.