# Senior Analytics Engineer

**Company:** [Bilt Rewards](https://hotfix.jobs/companies/bilt)
**Location:** New York, NY
**Role:** Data Engineering
**Experience:** 6+ years
**Skills:** SQL, BigQuery, dbt, Datastream, Materialize, Kafka, Pub/Sub, Airflow, Cloud Composer, Sigma, Tableau, Fivetran, Airbyte, Census, Terraform
**Posted:** 2026-06-22

> Build and own Bilt's full data stack including BigQuery warehouse, dbt models, CDC/streaming pipelines, and observability. Drive analytics, data modeling, and self-service tooling for business stakeholders.

## Job Description

## Responsibilities
- Partner with Data team and business stakeholders to model data into usable and scalable formats for embedded and self-service analytics
- Lead end-to-end development of models, alerts, semantic models, and metrics for stakeholders and partners
- Identify and execute opportunities for advanced analytics and complex models (sessionization, marketing attribution, profit modeling, LTV, Churn)
- Identify and execute cost and performance optimizations for existing models (incremental loading, indexing, partitioning, clustering)
- Build strong relationships with engineering and business stakeholders to empower data-driven use cases
- Advance dbt implementation and own core BigQuery data assets
- Build technical integrations with engineering stakeholders to scale data capabilities
- Build and maintain data pipelines from source databases into BigQuery using CDC (Datastream), file ingestion (SFTP/GCS), and streaming replication to Materialize
- Own pipeline reliability, orchestration, alerting, and observability across batch and streaming systems
- Provide analytics support: build dashboards in Sigma, perform complex analyses, partner with stakeholders to deliver insights, promote self-service AI analytics tools

## Requirements
- 6+ years of experience in analytics engineering or data engineering
- Deep fluency in SQL and a modern data warehouse (BigQuery strongly preferred)
- Experience with real-time streaming databases (Materialize or similar) and event streams (Kafka, Pub/Sub)
- Strong experience with dbt, including owning/building dbt projects, Jinja, YAML, and semantic modeling
- Experience acting as lead for data warehouse operations including permissions, data governance, scalability, and reliability
- Strong experience orchestrating large datasets and DAG dependencies using dbt Cloud, Airflow, Cloud Composer, or similar tools, including alerting and observability frameworks
- Hands-on experience with data ingestion technologies: CDC (Datastream or similar), file-based ingestion (SFTP, GCS), managed connectors (Fivetran, Airbyte)
- Experience with BI Tools (Sigma, Omni, Tableau) and building self-service solutions
- Experience with reverse ETL solutions (Census, Airbyte)

## Nice-to-Haves
- Familiarity with Terraform
- Java/Python familiarity
- Experience with highly performant analytical databases (Clickhouse, AlloyDB) and caching layers (Redis)

## Similar roles

- [Data Operations Lead](https://hotfix.jobs/jobs/4f8dee72-5fff-4c10-90b5-cbd0607417e6) - HappyRobot - San Francisco, CA - $180k – $240k/yr
- [Senior Software Engineer, AI Data Systems & Database Infrastructure](https://hotfix.jobs/jobs/11739793-220f-4ff1-882c-90bf341ca36c) - Ambient.ai - Redwood City, CA - $168k – $205k/yr
- [Senior Data Engineer](https://hotfix.jobs/jobs/cf45e5a5-fb7b-43fb-94e6-dff187027a77) - Vanta - Remote - $190k – $224k/yr
- [Senior Data Engineer](https://hotfix.jobs/jobs/c950f79a-6886-4ce0-9990-2627edb264f3) - Cloudflare - Austin, TX
- [Senior Data Engineer](https://hotfix.jobs/jobs/298b05d6-eba7-413d-bb1d-948ca80c669a) - Trexquant - Stamford, CT - $150k – $200k/yr

**Apply:** https://hotfix.jobs/jobs/96e61b1d-886c-4dda-a563-eca6e485af38
**Canonical:** https://hotfix.jobs/jobs/96e61b1d-886c-4dda-a563-eca6e485af38