Archer56

Sr. Staff Data Engineer

San Jose, California, United States · Staff+

No sponsorship$207k-$259kDetected 5 days ago

PythonSQLBigQuerySnowflakeDatabricksCloud PlatformsAirflowdbtData EngineeringLeadership

About the role

This is a high-ownership, low-bureaucracy role on a small team.
You'll shape how data is modeled and stored, work closely with engineering and operations stakeholders, and have direct visibility into how your work shapes the company.

Own the design and evolution of our data warehouse and lakehouse architecture - schemas, layer structure, modeling patterns, and long-term scalability
Lead data modeling efforts: dimensional modeling, semantic layer design, and entity relationship design across key business domains
Partner with analytics engineers and business stakeholders to translate domain requirements into robust, reusable data models
Drive decisions on storage design, partitioning strategies, and compute optimization for query performance and cost efficiency
Build and maintain production-grade pipelines where needed, with a focus on reliability and idempotency
Advanced SQL - complex joins, aggregations, window functions, query optimization, and schema design

7+ years of data engineering experience with demonstrated depth in data modeling and warehouse design
Experience designing and scaling data warehouses or lakehouses in cloud environments (Snowflake, Databricks, BigQuery, or equivalent)
Python proficiency for data transformation and pipeline work
Familiarity with orchestration tools (Airflow, Prefect, or equivalent)
Experience with data governance concepts - lineage, cataloging, access control, quality frameworks

Experience with dbt or similar transformation/modeling frameworks
Exposure to agentic or AI-assisted data infrastructure
Experience in a fast-moving startup or aerospace/manufacturing environment
You take ownership - if something is broken or unclear, you fix or clarify it
You think in systems: you model data to be reusable, not just functional
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.
Reasonable accommodations will be determined on a case-by-case basis.

Define standards for how data is structured, named, documented, and governed across the Medallion Architecture (bronze → silver → gold)
Contribute to data governance - lineage, cataloging, access control, and quality frameworks
Participate in architecture reviews and bring Senior Staff-level judgment to data stack decisions
You're comfortable operating on a small, high-trust team without a lot of process overhead

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.
This is a high-ownership, low-bureaucracy role on a small team. You'll shape how data is modeled and stored, work closely with engineering and operations stakeholders, and have direct visibility into how your work shapes the company.
What We're Looking For

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

This listing is sourced directly from Archer56's careers page and normalized into a canonical job model.