Senior Analytics Engineer, Airbnb.org

Airbnb was born in 2007 when two hosts welcomed three guests to their San Francisco home, and has since grown to over 5 million hosts who have welcomed over 2 billion guest arrivals in almost every country across the globe. Every day, hosts offer unique stays and experiences that make it possible for guests to connect with communities in a more authentic way. The Community You Will Join: In December 2020 Airbnb launched Airbnb.org, a non-profit organization that builds on a long history of connecting people in times of crisis to safe, comfortable places to stay. This work began at Airbnb in 2012, when a Host named Shell reached out wanting to offer her home for free to those impacted by Hurricane Sandy in New York City. Since then, Airbnb - and now Airbnb.org - has helped provide safe housing for over 250,000 people to date in response to hundreds of emergency events around the world including hurricanes, wildfires, refugee crises, and a global pandemic. The Airbnb.org team within Airbnb works in support of the Airbnb.org non-profit and partners with Hosts, nonprofit organizations, emergency management agencies and governments to provide stays to people around the world in times of crisis, and has announced a series of commitments to diversity, equity and inclusion including centering marginalized communities in its work and in team composition. The Difference You Will Make: Airbnb.org operates like a small startup inside Airbnb. Our data team is lean, the problems are new, and there is no established playbook for most of what we do. That means your ingenuity and autonomy are welcome and you will have the room to decide what to build and how, to experiment, and to shape the way a growing, mission-driven organization uses data. Analytics Engineers build the data foundation for the whole team - which translates to impact on all stakeholders with insights, analysis and experimentation. As a Senior Analytics Engineer, you will own major projects that build out the data foundation for Airbnb.org: designing and delivering the data models, metrics and dashboards that power our reporting, analysis and experimentation, and continuously raising the bar on data quality and reliability for the systems you build. Many of these projects will start out vaguely defined, and you will bring structure to them by breaking down the work, weighing tradeoffs, and delivering solutions that are efficient, reliable and simple to maintain. You will bring strong expertise in metric development, dimensional data modeling, SQL, Python, and distributed data processing frameworks, and a solid understanding of how the pieces of a modern data stack fit together. Data can transform how an organization operates; high data quality and tooling is the biggest lever to achieving that transformation. You will partner closely with stakeholders across Marketing, Fundraising, Programs, Product and Engineering to understand their data needs, translate business questions into well-defined metrics and data products, and prioritize your work in line with Airbnb.org's goals. You will work alongside our existing data team - Analytics Engineer, Analyst and Data Scientist - sharing knowledge, seeking and giving feedback, and collaborating with Data Engineering and Data Platform teams to get things built. A Typical Day: Design, build and launch efficient, reliable and maintainable data models and pipelines that power reporting, analysis and experimentation, in partnership with Data Engineering Design, define and implement metrics and dimensions for Airbnb.org, and document them clearly so they are trusted and used consistently across teams Own data quality for the tables and pipelines you build: implement testing, auditing and validation, respond to data incidents, and follow through on corrective actions that go beyond the immediate fix Identify and improve or deprecate low-quality or duplicative data assets, and plan quality improvements into the t