Be an Early Applicant
A loyalty program that rewards residents at home, in their neighborhood, & when they travel, no matter where they live.
The Role
Lead development and ownership of BigQuery data assets, pipelines, and observability. Build and optimize dbt models, CDC/file/streaming ingestion, and streaming replication. Partner with engineering and business teams to enable self-service analytics, advanced analytics (LTV, churn, attribution), and reliable real-time data products.
Summary Generated by Built In
What is Bilt?
Bilt is the membership for where you live, transforming rent and mortgage payments into valuable rewards while connecting members with exclusive benefits in their neighborhood.
With every on-time rent or mortgage payment, Bilt Members earn Bilt Points – the industry's most valuable and flexible points currency. They can transfer their points 1:1 to their favorite airlines or hotels with our industry leading travel program, use them for future rent payments, redeem for everyday purchases, or save them for a down payment on a home. Plus, unlock exclusive rewards on the 1st of every month with Rent Day®.
Bilt Members get even more value at their favorite local spots with exclusive Neighborhood Benefits™ at local restaurants, fitness studios, pharmacies, on Lyft rides, and more–over 45,000 merchants nationwide. When they use any linked card with our neighborhood partners, they’ll earn Bilt Points and access special experiences including complimentary items, member events, and more.
While Bilt Members can use many payment methods to earn points and access their benefits, Bilt has a suite of 3 cards offering the richest rewards in the market - and the first and only card suite that lets you pay rent and earn points without the transaction fee.
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 (based on YOE/level), and you will be eligible for equity and an annual performance-based bonus.
Top Skills
Sql,Bigquery,Dbt,Dbt Cloud,Jinja,Yaml,Datastream,Cdc,Materialize,Kafka,Pub/Sub,Postgresql,Clickhouse,Alloydb,Redis,Terraform,Java,Python,Airflow,Cloud Composer,Sftp,Gcs,Fivetran,Airbyte,Sigma,Omni,Tableau,Census,Cursor,Claude Code,Devin
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Bilt Rewards is the first loyalty program that rewards members on rent and in their neighborhood, no matter where they live.
Bilt Members can earn points and access exclusive benefits on rent payments, condo & co-op fees, and around their neighborhood at local restaurants, fitness studios, rideshare, pharmacy, and more. Ranked the highest-value point currency by top publications, Bilt Points can be transferred 1:1 to major airline and hotel programs or used towards rent payments, shopping, fitness, and even a down payment on a home. Members also get access to credit-building benefits, member-only experiences, and an Elite Status program.
In partnership with the top multifamily owners & operators across the country, we’ve also created the Bilt Rewards Alliance, a network of 4M+ apartments and homes across the country. Residents who live in the Bilt Rewards Alliance make payments directly through the Bilt Payment Center and get access to benefits including additional earn opportunities on new leases, renewals, and more.
While Bilt Members can use any debit or credit card to earn points and access their benefits, Bilt has partnered with Mastercard and Wells Fargo to create the Bilt Mastercard® - the first and only credit card that lets you pay rent and earn points without the transaction fee.
Why Work With Us
Bilt Rewards is revolutionizing how people pay rent by rewarding them at home and in their neighborhoods. Here, you'll shape the future of rewards programs while working in a high-impact, fast-paced startup environment. Join our collaborative culture, learn from industry experts, and grow your career while making a meaningful difference.
Gallery
Bilt Offices
OnSite Workspace
We’re an in-person company where energy and collaboration fuel our creativity, agility, and speed. With most of our team in the office 4-5 days a week, we create an environment that sparks new ideas and drives our momentum forward.
Typical time on-site:
None
New York, NY
