Analytics Engineer, Notion

• You are a self-starter and continuously gather and synthesize high-impact needs from business partners, design and implementing the appropriate technical solutions, and effectively communicating about deliverables, timelines and tradeoffs
• You've spent 5+ years as an analytics or data engineer building core datasets and supporting business verticals as needed. You are passionate about analytics use cases, data models and solving complex data problems
• You have hands-on experience in the Trust & Safety domain
• You have hands-on experience shipping scalable data solutions in the cloud (e.g AWS, GCP, Azure), across multiple data stores (e.g Snowflake, Redshift, Hive, SQL/NoSQL, columnar storage formats) and methodologies (e.g dimensional modeling, data marts, star/snowflake schemas)
• You are an SQL expert. You intimately understand aggregation functions, window functions, UDFs, self-joins, partitioning and clustering approaches to run correct and highly-performant queries
• You are highly comfortable with object-oriented programming paradigms (e.g Python, Java, Scala)

Desirable

• As Notion continues to grow quickly, ensuring user safety and platform integrity becomes increasingly critical.
• There is a unique opportunity to build the data foundations that power Trust & Safety initiatives and help protect our community while maintaining the open, collaborative nature that makes Notion special.
• This is where you come in — to design and build reliable, trusted and timely datasets that accelerate Trust & Safety decision-making, detect harmful content, prevent abuse, and ensure compliance.
• You will have a strong impact on making Notion a safer platform for millions of users worldwide
• You'll define the processes and ETL infrastructure to transform and make Trust & Safety data readily available to help understand emerging abuse patterns, size impact of solutions, prioritize future projects
• You'll build core datasets to serve as unique sources of truth for Trust & Safety functions including abuse detection, content policy enforcement, user safety metrics, fraud prevention, and regulatory compliance
• You'll partner with internal stakeholders to understand their needs and then design, build and monitor pipelines that enable real-time threat detection and rapid response to safety incidents
• You'll implement automated workflows that support content moderation at scale, define and uphold SLAs for critical safety data delivery, and build dashboards and self-serve analytics tools for Trust & Safety teams