Staff Business Intelligence Engineer - Enterprise & Telemetry Data

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).
• Background in aerospace, automotive or other highly regulated industries.

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.