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 evolving, so please check back with us if the state you live in is on the exclusion list . If your position is employed by another Airbnb entity, your recruiter will inform you what states you are eligible to work from. Our Commitment To Inclusion & Belonging: Airbnb is committed to working with the broadest talent pool possible. We believe diverse ideas foster innovation and engagement, and allow us to attract creatively-led people, and to develop the best products, services and solutions. All qualified individuals are encouraged to apply. We strive to also provide a disability inclusive application and interview process. If you are a candidate with a disability and require reasonable accommodation in order to submit an application, please contact us at: reasonableaccommodations@airbnb.com. Please include your full name, the role you’re applying for and the accommodation necessary to assist you with the recruiting process. We ask that you only reach out to us if you are a candidate whose disability prevents you from being able to complete our online application. Equal Employment Opportunity: Airbnb values diversity & belonging and is proud to be an Equal Employment Opportunity employer. All individuals seeking employment at Airbnb are considered without regard to race, color, religion, national origin, age, gender, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, gender expression, sexual orientation, or any other legally protected characteristic. How We'll Take Care of You: Our job titles may span more than one career level. The actual base pay is dependent upon many factors, such as: training, transferable skills, work experience, business needs and market demands. The base pay range is subject to change and may be modified in the future. This role may also be eligible for bonus, equity, benefits, and Employee Travel Credits. Pay Range $179,000—$210,000 USD Reasonable Accommodations: We are committed to providing reasonable accommodations throughout the recruitment process for applicants with disabilities. If you need assistance, or an accommodation, please let your recruiter know once you are contacted about a role. A Note on Recruiting Scams: Scammers sometimes pose as Airbnb recruiters to get money or personal information from candidates. A few things that will always be true for Airbnb’s hiring process: our open roles are posted on Airbnb’s Career’s Page at careers.airbnb.com, and our recruiters correspond only from @airbnb.com or @ext.airbnb.com email addresses. Our recruiters will never ask for your Social Security number, bank account details, passport, or payment app information while you are interviewing. We’ll also never ask you to pay a fee, send money, deposit or cash a check, or purchase work-related equipment (such as a company laptop) during the interview process. We encourage candidates to remain vigilant of these recruiting scams and not share sensitive information if you do not believe an individual is actually affiliated with Airbnb.