Staff Software Engineer, Data Warehouse Foundation
Provides technical leadership for Pinterest’s data warehouse foundation and agentic analytics platforms at massive scale. The role designs warehouse architecture, leads cross-functional initiatives, mentors engineers, and requires extensive data platform experience plus hands-on AI tooling expertise.
About the job
Responsibilities
- Define and design Pinterest’s data warehouse architecture, storage, and access patterns.
- Lead ambiguous, highly challenging, and cross-functional initiatives across data warehouse and agentic data analytics domains.
- Mentor engineers and raise the technical bar through leadership on complex technical design, execution strategies, and trade-off decisions.
- Collaborate with Product, Data Science, and Engineering stakeholders to understand user needs, drive alignment, and make progress.
Requirements
- 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 building data warehouses and tools around the data ecosystem.
- Ability to work with cross-functional partners across multiple organizations.
- Hands-on experience building tools and data pipelines with AI coding tools such as Cursor, Claude Code, or Codex.
- Hands-on experience building AI tools and platforms to accelerate data pipeline authoring, data analytics, and engineering productivity.
Technologies
- Spark
- Trino
- Flink
- Airflow
- Querybook
- Superset
- DataHub
- Cursor
- Claude Code
- Codex
Compensation
- Base salary range: $177,185–$364,795 USD.
- Eligible for equity.
- Benefits information is available through Pinterest.
Skills
Data Warehousing, Spark, Trino, Apache Flink, Apache Airflow, Querybook, Superset, Datahub, Ai Coding Tools, Data Pipelines, Artificial Intelligence, Data Analytics, Data Architecture, Exadata
Similar jobs
Data Engineering jobs
United States
Leads the design, operation, and technical direction of Pinterest’s data workflow and context control planes, driving reliability, scalability, AI-native capabilities, and open-source contributions. Requires 10+ years of distributed-systems experience, infrastructure expertise, and proficiency in Python or Java.
SmithRx
United States
Leads enterprise data engineering strategy, architecture, delivery, governance, and technical leadership across the organization. Requires extensive data engineering experience, advanced data modeling and warehouse expertise, and strong PySpark, SQL, and Python skills.
IntusCare
United States
Staff-level engineer responsible for the technical direction, reliability, and evolution of a cloud ELT platform supporting healthcare data products. The role requires 7+ years of software or data engineering experience, deep SQL/Python and modern data-platform expertise, and strong architectural and mentoring leadership.
Rula
United States
Leads organization-wide Snowflake migration, Medallion architecture, warehouse optimization, and CI/CD quality controls while partnering with executives on data strategy. The role requires 6+ years in analytics or data engineering, expert SQL, production dbt experience, and strong architectural judgment.
Twilio
United States
Architects scalable data systems and platforms using distributed technologies like Spark, Kafka, and AWS. Mentors engineers and drives innovation on large-scale data projects, requiring 8+ years experience and expertise in data infrastructure.