Analytics Engineer

Full-time - Mid Level

San Francisco, CA

Personal and Laundry Services

About the position

AirGarage is repurposing the 30% of real estate in the average American city currently dedicated to parking. We are building a future where real estate is digitized and can be transitioned from one use to another seamlessly on-demand, moving every piece of urban real estate toward its highest and best use. We are starting with the $131 billion US parking real estate market because it is one of the most offline and mismanaged commercial real estate asset types. As a full-stack parking operator, we automate the operation of parking lots and parking garages. We handle everything from advertising to collecting payments from drivers and enforcing against illegal parking. We already operate 250+ parking lots and parking garages across 35 US states and we are growing quickly. We are backed by top tier investors including Andreessen Horowitz, Floodgate, Founders Fund, and angel investors who have founded or worked at companies like Uber, Opendoor, Flexport, and more. The Data team at AirGarage is not merely a service function for internal stakeholders - we are a value-driving function for the business at large. As an early member of this small but mighty team, reporting directly to the Chief Data Officer, you will play a critical role in ensuring that the company's data is maximized. To do so, you will be helping build and maintain the world's best parking database. This role requires you to be an exceptional steward of data: obsessing over data quality and curating raw data into clean and reliable models ripe for insight generation. While we expect you to have specialty in analytics engineering, we are still a small team so you will also have the opportunity to stretch across all aspects of data from generating new data to analyzing it.

Responsibilities

• Partner with our founding team and company leadership to build out a best-in-class analytics system to give our partners insight into their parking lot and garage performance and super charge our internal organization.
• Work with our engineering, data, sales, marketing, and product teams to understand the data needs of the business and produce pipelines, data marts and other data solutions that enable better decision-making.
• Develop scalable code that transforms raw data in an automated and efficient manner to ensure curated and ready-to-analyze data is always available.
• Identify new data sources we can leverage to improve the company's performance in core business activities; this can take the form of collaborating with our engineering team to improve data logging, scraping data from the web, or using third-party datasets.
• Conduct data analyses to assist partner teams in diagnosing issues, understanding opportunities, or measuring performance.
• Troubleshoot and communicate data issues to internal stakeholders, including by building code tests to alert us when there is a problem in our data before it affects end users.
• Play a critical role in helping define data team best practices, workflows, and documentation to ensure we are building a sustainable and scalable data function.

Requirements

• A degree in engineering, science, math, or a related analytical field.
• 5 - 10 years of experience in Data Engineering or Analytics Engineering.
• Experience with the modern data stack (Snowflake / dbt / Polytomic / Hex or equivalents).
• Advanced fluency in SQL and Python (bonus for Snowpark) - knowing how to write intricate queries and build automated pipelines.
• Prior experience with data modeling and writing performant queries in a data warehouse setting on large datasets.
• Passion for data - you're excited by the opportunity to clean up messy datasets and obsess over how to bring data to the table for decision-making.
• Extreme attention to detail and nuance - this is a critical quality when the stakes are high and trust is everything to our partners.
• Innate curiosity - proactively asking questions and independently chasing down the answers to those questions.
• Systems-thinker - you understand all the inter-connected parts of a process and know how a change in one part of a system will affect other parts of the system.
• A growth mindset - you should be a lifelong learner, hungry to challenge yourself and grow.

Benefits

• Competitive salary.
• Equity: Have a stake in the business that you're helping to build and grow.
• Work remotely: Live and work wherever you like! We believe in folks working where they are happiest and most productive. We currently hire teammates that are located anywhere within North America.
• Health insurance: We offer health insurance and currently cover 85% of the cost of medical plans for the primary employee and 50% of the cost of plans for dependents.
• Home office setup: Get a laptop + additional equipment needed to set you up for success.
• Time to recharge: We have an unlimited PTO policy with a minimum requirement of 10 days per year.
• 401(k): Make financial planning right for you with a 401(k) retirement savings program.
• Team Off-sites: ~2 times per year our team comes together for a full week in places like San Diego, Puerto Vallarta, and Charleston.
• Room to grow: the Data team will grow with the company over the next few years, and you'll be the foundation of that team.
• Transform our cities: The opportunity to change the way that the world thinks about real estate use in our cities.
• Work with a diverse team: we are currently 35%+ female and 30%+ non-white and we hope to continue hiring thoughtfully to build a team that represents the fact that our customers come from all walks of life.