Senior Data Warehouse Engineer - End-to-End & AI-Ready

BILL; Draper (UT); On-site; USD 148,400 - 177,900; Full time

Benefits offered by this job

Health insurance

HSA & FSA accounts

Life Insurance

Paid holidays

Stock Purchase Program

Job summary

BILL in Draper, UT is hiring a Staff Data Warehouse Engineer to own end-to-end pipelines and warehouse architecture, partnering with Analytics, Data Science, and Product teams to deliver trusted data for reporting and decision making.

You have 8+ years in data engineering, expert SQL, Python, ETL/ELT design, and hands-on experience with Snowflake or similar lakehouse platforms. This role offers a competitive salary in Utah with bonus and equity opportunities, and a comprehensive benefits package.

Qualifications

• 8+ years of experience in data engineering or combined software/data engineering roles.
• Expert-level SQL and strong Python, with production-grade applications beyond ad hoc scripts.
• Deep knowledge of ETL/ELT design, ingestion methods, and orchestration (dbt, Airflow).
• Hands-on experience with modern lakehouse/warehouse platforms (Snowflake, Trino/Starburst, or similar).
• Experience in financial services and/or SaaS environments.
• Comfort operating with minimal DevOps/IT support on core database and warehouse administration.
• Proven mentorship and standards-setting experience; formal management not required.

Responsibilities

• Own end-to-end delivery of pipelines and warehouse architecture, from design through production, for new builds, migrations, and re-platforming efforts.
• Administer and harden the data warehouse, including schema design, performance tuning, stability, and cost-aware optimization.
• Embed data quality and governance into pipelines by default — testing, documentation, lineage — not as afterthoughts.
• Translate ambiguous business requirements into clear technical designs; scope tradeoffs and dependencies with cross-functional stakeholders.
• Define and codify simple, stable, repeatable engineering standards and patterns adopted by the broader team.
• Mentor engineers through design reviews, code reviews, and hands-on guidance to raise the technical bar.
• Evaluate and introduce tools or architecture patterns when they materially improve scale, reliability, or cost and be able to justify and explain the rationale.
• Design the warehouse to be queried by AI agents, not just people; structure models, naming conventions, and metadata for correct NL querying.

Skills

Data engineering

SQL

Python

ETL/ELT

dbt/Airflow

Snowflake

SaaS/FinServ

DevOps basics

Mentorship

Tools

Airflow

dbt

Job description

BILL in Draper, UT is hiring a Staff Data Warehouse Engineer to own end-to-end pipelines and warehouse architecture, partnering with Analytics, Data Science, and Product teams to deliver trusted data for reporting and decision making.

You have 8+ years in data engineering, expert SQL, Python, ETL/ELT design, and hands-on experience with Snowflake or similar lakehouse platforms. This role offers a competitive salary in Utah with bonus and equity opportunities, and a comprehensive benefits package.