AKAbdullah Khan

Freelance • Education operations startup • 2021

Notion to BigQuery Incremental ETL

Engineered an incremental ETL that extracts Notion entities, normalizes through silver/gold zones, and loads analytical tables to BigQuery.

Challenge

Semi-structured Notion data required robust parsing and denormalization before analytics usage.

Solution

Built staged parsers for relation/text/date fields, created business joins, and added run-level logging.

Outcomes

  • Created repeatable data model from semi-structured source
  • Enabled startup analytics reporting
  • Introduced monitoring and traceability

Technology Stack

  • Python
  • Notion API
  • BigQuery
  • JSON parsers

Ready To Build

Want this delivery model for your team?

I can map the same principles to your architecture, timeline, and constraints.

Talk About Your ContextBack to Projects