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 team's roadmap • Design and develop dashboards and self-serve data products that make data discoverable, trusted and easy to consume • Write clear technical designs that lay out benefits, risks and tradeoffs; seek and incorporate peer feedback, and provide constructive input on others' designs and code • Understand stakeholder needs across Marketing, Fundraising, Programs, Product, Data Science and Engineering, and prioritize work within your projects to align with Airbnb.org's goals; mentor and share knowledge with fellow data practitioners Your Expertise: • 5+ years of relevant industry experience in analytics engineering, data engineering, or a closely related field • Experience owning major data projects end to end, including ones that started out loosely defined, from scoping and design through delivery • Strong SQL skills and experience optimizing queries on distributed data processing systems (e.g. Spark, Presto, Hive) • Solid experience in dimensional data modeling, schema design and metric definition • Proficiency in at least one programming language for data work (e.g. Python) and experience with an ETL/orchestration framework like Airflow • Ability to communicate technical solutions and tradeoffs clearly to both technical and non-technical partners, and to adapt to competing priorities • Proven ability to succeed in both collaborative and independent work environments • Passion for high data quality, attention to detail, and an ownership mindset toward the reliability of what you build • Preferred: Minerva and Tableau skills, and an eye for design when it comes to dashboards and visualization tools Your Location: This position is US - Remote Eligible. The role may include occasional work at an Airbnb office or attendance at offsites, as agreed to with your manager. While the position is Remote Eligible, you must live in a state where Airbnb, Inc. has a registered entity. Click here for the up-to-date list of excluded states. This list is continuously