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:Data Warehouse: Building and managing the foundational data warehouses that enable key analyses across both our core engagement and monetization products.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-AH2At 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.Information regarding the culture at Pinterest and benefits available for this position can be found here.US based applicants only$177,185—$364,795 USDOur 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.By submitting this application, I certify that all information submitted in my application and throughout the hiring process is true, accurate, and complete to the best of my knowledge. I understand that any false statement, omission, or misrepresentation may disqualify me from employment consideration or result in termination if discovered after hire.