Staff Software Engineer, Data Warehouse Foundation

Pinterest; United States; Hybrid; USD 177,000 - 365,000; Full time

Job summary

Pinterest is seeking a Staff Software Engineer to lead the Data Product Platform, shaping data warehouse architecture and scalable analytics at exadata scale.

You will drive cross-functional initiatives, mentor engineers, and partner with Product, Data Science, and Engineering to accelerate data-driven decisions and build agentic analytics at Pinterest.

Qualifications

• 8+ years of experience with large scale data warehouses and data tools.
• 5+ years building data warehouses and tools in the data ecosystem (Spark/Trino/Flink, etc).
• Hands-on experience with AI coding tools and data pipelines.
• Ability to collaborate with cross-functional partners across organizations.

Responsibilities

• Define and design Pinterest's data warehouse architecture, storage, and access patterns.
• Lead ambiguous, cross-functional initiatives across data warehouse and analytics domains.
• Mentor engineers on complex design, execution strategies, and trade-offs.
• Collaborate with Product, Data Science, and Engineering to understand user needs and drive progress.

Skills

Large-scale data warehouses

Data tooling

AI coding tools

Cross-functional collaboration

Education

Bachelor’s degree in Computer Science or related field

Tools

Spark

Trino

Flink

Airflow

Querybook

Superset

DataHub

Job description

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.

US based applicants only

Base Salary Range: $177,185 — $364,795 USD

Information regarding the culture at Pinterest and benefits available for this position can be found here.

Our Commitment to Inclusion:

Pinterest is an equal opportunity employer and makes employment decisions on the basis of merit. We want to have the best qualified people in every job. All qualified applicants will receive consideration for employment without regard to race, color, ancestry, national origin, religion or religious creed, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender, gender identity, gender expression, age, marital status, status as a protected veteran, physical or mental disability, medical condition, genetic information or characteristics (or those of a family member) or any other consideration made unlawful by applicable federal, state or local laws. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. If you require a medical or religious accommodation during the job application process, please complete this form for support.