Staff Software Engineer, Data Warehouse Foundation

About Pinterest:

Millions of people around the world come to our platform to find creative ideas, dream about new possibilities and plan for memories that will last a lifetime. At Pinterest, we’re on a mission to bring everyone the inspiration to create a life they love, and that starts with the people behind the product.

Discover a career where you ignite innovation for millions, transform passion into growth opportunities, celebrate each other’s unique experiences and embrace the flexibility to do your best work. Creating a career you love? It’s Possible.

At Pinterest, AI isn't just a feature, it's a powerful partner that augments our creativity and amplifies our impact, and we’re looking for candidates who are excited to be a part of that. To get a complete picture of your experience and abilities, we’ll explore your foundational skills and how you collaborate with AI.

Through our interview process, what matters most is that you can always explain your approach, showing us not just what you know, but how you think. You can read more about our AI interview philosophy and how we use AI in our recruiting process here.

The Data Product Platform is mission-critical to accelerate data-driven decision-making at Pinterest on the foundation of 100s of thousands of tables and an exadata-scale data warehouse. We strive to provide effortless, efficient, and reliable data products and platforms that power the entire company. We achieve this by investing in two core areas:

1. Data Warehouse: Building and managing the foundational data warehouses that enable key analyses across both our core engagement and monetization products.


2. Analytical Velocity: Creating agentic analytical tools that empower internal data users to leverage our vast data assets and capable infrastructure effectively.

We are seeking a Staff Software Engineer to provide technical leadership and contribute to the development of solutions across both these pillars. In this role, you will shape the vision and drive the execution of the solutions that handle increasing data volume, navigate business complexity, accelerate analytical velocity, and build the foundation for our next generation of agentic analytics products. If you are passionate about building world-class data ecosystems at massive scale, we invite you to come build with us!


What you’ll do: 

• Define and design Pinterest's data warehouse architecture, storage, and access patterns.


• Lead ambiguous, highly challenging, and cross-functional initiatives across the data warehouse and agentic data analytics domains.


• Mentor and elevate the technical bar for engineers, providing leadership on complex technical design, execution strategies, and critical trade-off decisions.


• Collaborate with stakeholders across Product, Data Science, and Engineering teams to understand user needs, drive alignment and drive progress.
  
  

What we’re looking for:

• Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent experience.


• 8+ years of relevant industry experience with large scale data warehouses, data tools and platforms. 


• 5+ years experience building data warehouses and tools around the data ecosystem with technologies such as Spark, Trino, Flink, Airflow, Querybook, Superset, DataHub, etc.


• Ability to work with cross-functional partners across multiple organizations.


• Hands-on experience building tools and data pipelines leveraging AI coding tools, e.g. Cursor, Claude Code, Codex, etc.


• Hands-on experience building AI tools and platforms to accelerate data pipeline authoring, data analytics and engineering productivity.

Relocation Statement:

• This position is not eligible for relocation assistance. Visit our PinFlex page to learn more about our working model.

In-Office Requirement Statement:

• We recognize that the ideal environment for work is situational and may differ across departments. What this looks like day-to-day can vary based on the needs of each organization or role.


• This role will need to be in the office for in-person collaboration 1-2 times/quarter, and therefore can be situated anywhere in the country.

#LI-REMOTE

#LI-AH2