Senior Analytics Engineer

What’s the role? 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. In this role, you will: 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 In terms of qualifications, we’re seeking: About you: A data professional yearning to solve big-picture problems, learn new things, seek answers in data, who finds comfort in uncertainty A strong communicator, who thinks in terms of solutions instead of tools, and can clearly explain sophisticated systems to technical and non-technical audiences Engineering-minded with a strong bias towards action, delivering results quickly with iteration instead of waiting for perfection Strong prioritization and organizational skills the ability to juggle many tasks at once in a fast-paced, entrepreneurial environment Experience implementing advanced alerting and monitoring and building resilient systems and processes A strong bias towards being AI-forward, leveraging AI coding assistants (Cursor, Claude Code, Devin) and MCP servers (dbt, BigQuery) to automate processes and create leverage for the business A heart-first contributor who is able to deliver complex projects with multiple stakeholders Experience: 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 Experience with highly performant analytical databases (e.g. Clickhouse, AlloyDB) and/or caching layers (e.g. Redis) also a plus 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) 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. At Bilt Rewards, we believe in transparency and we do our best to make sure the company and our candidates are on the same page as it relates to compensation. In addition to posting salary ranges for our open roles, candidates should expect to be asked about compensation expectations and requirements early on in their interview process. Our goal is to highlight when expectations and Bilt’s salary range may be out of sync, and work with the candidate to determine whether it makes sense to continue conversations. We are considering candidates with differing levels of expertise for this position. Leveling will be based upon your experience and performance in the interview process. Where a new hire falls within a range will be based on their skills and experience, and how these competencies compare across other employees in the same role. Bilt's bands are designed to allow for individual compensation growth within the role. As such, new hires typically start at the lower end of the range. Bilt Rewards performance and outcomes - should you join the company, you will have the opportunity to grow your salary over time. The salary range for a Senior Analytics Engineer is $150,000 - $200,000 and you will be eligible for equity and an annual performance-based bonus. #J-18808-Ljbffr Bilt