Senior Analytic Engineer

Bilt • New York, NY

6d • $150,000 - $200,000

About The Position

We are looking for an experienced data professional to join our high-performing team that is transforming the future of renting, home ownership, and rewards. You will play a key role driving business growth by building the data foundation to unlock strategic & analytical insights, with an emphasis on structuring, modeling, testing and activating our data. You will take significant ownership of our BigQuery data warehouse, data pipelines from source systems (CDC, file ingestion, streaming replication), and the orchestration and observability frameworks that keep it all running. This is a “full data stack” role — you’ll be equally comfortable writing dbt models and debugging a Datastream CDC pipeline or working with streaming replication to support real-time data products. The ideal candidate has a proven track record developing data products, building reliable data infrastructure, and cultivating key stakeholder relationships.

Requirements

• 6+ years of experience in analytics engineering or data engineering
• SQL is your primary language, you live and breathe it. Deep fluency in a modern data warehouse (BigQuery strongly preferred). Familiarity with Terraform is ideal; Java/Python familiarity is a nice to have
• Experience with real-time streaming databases (e.g. Materialize or similar) and event streams (Kafka, Pub/Sub) — you will own PostgreSQL replication into Materialize and help maintain streaming analytics workloads
• Strong experience with dbt, comfortable owning / building out dbt projects, leveraging Jinja, YAML and semantic modeling to enable analytics at scale
• Experience acting as lead for all things data warehouse, 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 building alerting and observability frameworks to proactively catch pipeline failures
• Experience applying best practices and frameworks such as DRY, incremental models, testing and alerting, and generating documentation
• Hands-on experience with data ingestion technologies such as CDC (Datastream or similar), file-based ingestion (SFTP, GCS), and/or managed connectors (Fivetran, Airbyte). Comfortable managing database migrations and replication across environments
• Experience with a variety of BI Tools (e.g. Sigma, Omni, Tableau etc.) and building solutions to promote self-service and general business observability
• Experience with reverse ETL solutions, syncing data assets to downstream services via a variety of SaaS / OSS tools (e.g. Census, Airbyte)

Nice To Haves

• Familiarity with Terraform is ideal; Java/Python familiarity is a nice to have
• Experience with highly performant analytical databases (e.g. Clickhouse, AlloyDB) and/or caching layers (e.g. Redis) also a plus

Responsibilities

• Be instrumental in growing Bilt’s data function to support the business’ goals
• Partner with other members of the Data team and business stakeholders to model data into usable and scalable formats to drive embedded and self-service analytics
• Lead the Data team with end-to-end development of models/alerts/semantic models/metrics to be consumed by stakeholders and partners
• Identify and execute on opportunities for employing advanced analytics and building complex models to answer business problems such as sessionization of events data, marketing attribution, granular profit modeling, LTV and Churn
• Identify and execute on cost and performance optimizations for existing models, including advanced incremental loading, indexing, partitioning, and clustering strategies
• Build strong relationships with engineering and business stakeholders and serve as a key centralized function to empower data-driven use cases
• Continue advancing our dbt implementation and take ownership of core BigQuery data assets
• Build technical integrations together with engineering stakeholders to scale and power Bilt’s overall 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 — ensuring data is fresh, accurate, and well-monitored
• Roll up your sleeves to provide analytics support when needed — building dashboards in Sigma, performing complex analyses, and partnering directly with business stakeholders to deliver insights, and promoting use of self-service AI analytics tools

Benefits

• Compensation - We offer a competitive salary with a meaningful stake in the company via equity and our performance bonus program
• Health insurance for you (& your loved ones) from day one - Enjoy a One Medical Membership, wellness stipends, family programs and more, on us. We’ve got you and your family covered from day one.
• 401k plan with a match - Retirement may feel more like a pipe dream than a reality but we’re here to help you get there.
• Commuter FSAs - We believe the best ideas come from being together in one place. We just don’t think getting there should be so expensive.
• UNLIMITED PTO - Because we believe that working hard shouldn’t mean always working. Take time for yourself as often as you need it.
• Exclusive Employee only Bilt Points - We give our employees unique opportunities to earn points throughout their time at Bilt.
• Team Events - We believe in human connection so we hold events to help our employees break from the monotony of the typical work week.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed