Data Engineer (AI)

Location: San Francisco, California; hybrid schedule with office attendance on Mondays, Tuesdays and Thursdays at the San Francisco Headquarters.

Base salary: $179,000–$200,000 per year for roles based in San Francisco, plus equity and benefits.

Company

Notion develops a collaborative AI workspace for knowledge, projects, meetings, documents, databases, and AI tools.

What you will do

• Define ETL processes and infrastructure that make data available across the company.
• Build core datasets as single sources of truth for product, marketing, sales, finance, customer experience, data science, operations, IT, and engineering.
• Partner with data scientists and stakeholders to design, build, and monitor scalable data pipelines.
• Implement automated workflows, reduce operational costs, and define SLAs for timely data delivery.
• Enable self-serve dashboards, discovery tools, and AI-assisted data exploration.
• Gather high-impact business needs, design technical solutions, and communicate deliverables, timelines, and tradeoffs.

Requirements

• 5+ years of experience as a data engineer building core datasets and supporting business functions.
• Strong understanding of scalable cloud data solutions across AWS, GCP, or Azure and multiple data stores, including Snowflake, Redshift, Hive, SQL/NoSQL, and columnar formats.
• Experience with dimensional modeling, data marts, and schemas.
• Expert SQL skills, including aggregation, window functions, UDFs, self-joins, and query optimization.
• Strong object-oriented programming skills in Python, Java, or Scala.
• Expertise using AI and agent-based tools for data development, including defining guardrails, workflows, and context for safe, production-scale work.

Nice to have

• Experience at a fast-scaling or SaaS company.
• Experience designing and building highly scalable, reliable data pipelines with Airflow, DBT, Spark, Hive, Parquet/ORC, Protobuf, or Thrift.
• Experience as a Notion user.

Culture & Benefits

• Collaborative in-person work is emphasized on the designated Anchor Days.
• Competitive cash compensation, equity, and benefits.
• Inclusive equal-opportunity workplace with reasonable accommodations available during hiring.
• AI curiosity, tinkering, discovery, and practical use of AI as a work collaborator are encouraged.