Senior Analytics Engineer, Airbnb.org

airbnb, Inc.; Northern (KY); Hybrid; USD 179,000 - 210,000; Full time

Job summary

Airbnb.org is seeking a Senior Analytics Engineer to design and deliver data models, metrics, and dashboards that empower reporting, analysis, and experimentation. You will partner with Marketing, Fundraising, Programs, Product, Data Science and Engineering to translate questions into measurable data products and ensure high data quality across the stack.

You will own major end-to-end data projects, influence the data foundation, and mentor teammates, while using SQL, Python, and distributed

Qualifications

• 5+ years in analytics/data engineering.
• Experience owning major data projects end to end.
• Strong SQL and distributed data processing experience.
• Python with ETL/Orchestration like Airflow.
• Ability to communicate technical tradeoffs clearly.

Responsibilities

• Design, build, and launch data models and pipelines for reporting and experimentation.
• Define metrics and dimensions; document for trust and consistency.
• Own data quality, testing, auditing, and incident response.
• Improve or deprecate low-quality data assets and plan improvements.
• Develop dashboards and self-serve data products for teams.

Skills

SQL

Python

Airflow

Spark/Presto/Hive

Dimensional modeling

Data quality

Communication

Tools

Tableau

Minerva

Job description

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

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.

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.