Senior Analytics Engineer, Airbnb.org

Airbnb; United States; Remote; USD 179,000 - 210,000; Full time

Job summary

Airbnb.org, the nonprofit arm of Airbnb, seeks a Senior Analytics Engineer to design and deliver data models, metrics and dashboards powering reporting, analysis and experimentation.

You will own major end-to-end data projects, collaborating with cross-functional teams to ensure data quality and reliability in a modern data stack using SQL, Python and distributed processing.

Qualifications

• 5+ years of relevant industry experience in analytics engineering or data engineering.
• Experience owning major data projects end to end, from scoping 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.
• Proven ability to succeed in both collaborative and independent work environments.
• Passion for high data quality and ownership mindset toward reliability.
• Preferred: Minerva and Tableau skills for dashboards and visualization.

Responsibilities

• Design, build and launch efficient data models and pipelines powering reporting, analysis and experimentation.
• Define and implement metrics and dimensions for Airbnb.org and document them for cross-team trust.
• Own data quality for tables and pipelines; implement testing, auditing and validation.
• Identify and improve low-quality or duplicative data assets and plan quality improvements.
• Design and develop dashboards and self-serve data products that are easy to consume.
• Write technical designs, solicit peer feedback and contribute to others' designs and code.
• Understand stakeholder needs across Marketing, Fundraising, Programs, Product, Data Science and Engineering.

Skills

SQL

Data modeling

Python

Communication

End-to-end ownership

Tools

Spark

Presto

Hive

Airflow

Tableau

Job description

Senior Analytics Engineer, Airbnb.org

United States

Role overview

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. Application

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.

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: [e-mail]. 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