Staff Software Engineer, Data Warehouse Foundation

Pinterest; Palo Alto (CA); Hybrid; USD 177,000 - 365,000; Full time

Job summary

Pinterest is seeking a Staff Software Engineer to lead design and execution of scalable data warehouse and analytics platforms. You will shape architecture, mentor engineers, and drive cross‑functional initiatives that accelerate data-driven decision making across core teams.

You will collaborate with Product, Data Science, and Engineering to translate needs into robust data products, while guiding architectural decisions and ensuring reliable, scalable delivery.

Qualifications

• Bachelor’s degree in CS/Engineering or equivalent experience.
• 8+ years of experience with large-scale data warehouses.
• 5+ years building data warehouses and tools (Spark, Trino, Flink, Airflow, etc.).
• Ability to work with cross-functional partners across orgs.
• Hands-on experience with AI coding tools (Cursor, Claude Code, Codex).
• Experience building AI tools to accelerate data pipeline analytics.

Responsibilities

• Define and design Pinterest's data warehouse architecture, storage, and access patterns.
• Lead ambiguous, cross‑functional initiatives in data warehouse and analytics domains.
• Mentor engineers and set technical direction for complex design and trade-offs.
• Collaborate with Product, Data Science, and Engineering to align needs and progress.

Skills

Cross-functional collaboration

Leadership

AI tool familiarity

Data-centric mindset

Education

Bachelor’s degree in Computer Science/Engineering or related field

Equivalent experience

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.

#LI-REMOTE

#LI-AH2

US based applicants only

$177,185—$364,795 USD

At Pinterest we believe the workplace should be equitable, inclusive, and inspiring for every employee. In an effort to provide greater transparency, we are sharing the base salary range for this position. The position is also eligible for equity. Final salary is based on a number of factors including location, travel, relevant prior experience, or particular skills and expertise.

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