Siddharth Chauhan

Data Engineering & Architecture · Macro Evidence

Profile

Current work spans data engineering and architecture at Macro Evidence, focused on open macroeconomic data infrastructure. I maintain Macro Data Observatory (MDO), its flagship and foundational platform.

Computer Science and Engineering undergraduate (B.Tech expected 2027). Technical work spans Python ETL pipelines, relational data modeling, PostgreSQL persistence with SQLAlchemy, data-quality validation, automated tests, and continuous integration across World Bank, IMF, and FRED ingestion workflows.

Education

Bachelor of Technology (B.Tech) in Computer Science and Engineering

2022–2027 (expected)

Dr. A.P.J. Abdul Kalam Technical University

Lucknow, Uttar Pradesh, India

Experience

Founder

2026–Present

Macro Evidence

  • Design and maintain Macro Data Observatory’s ingestion pipelines, relational data model, persistence, validation, testing, and CI.
  • Implement source and pipeline changes across World Bank, IMF, and FRED data, with reproducible transformations and validation before load.
  • Document non-trivial technical decisions through versioned ADRs and keep project documentation aligned with implementation.

Selected project

Macro Data Observatory (MDO)

2026–Present

Open-source macroeconomic data infrastructure GitHubgithub.com/macro-evidence/macro-data-observatory

  • Modular ingestion pipelines for macroeconomic indicators from the World Bank, IMF, and Federal Reserve Economic Data (FRED).
  • Series-first relational modeling with PostgreSQL persistence through SQLAlchemy and a structured transformation layer.
  • Data-quality validation before load, including structural checks for source data.
  • Automated testing with Pytest and continuous integration through GitHub Actions.

Technical skills

Python SQL PostgreSQL SQLAlchemy pandas ETL pipelines API integration Relational data modeling Data-quality validation Pytest Git GitHub Actions (CI)

Languages

English

Professional working proficiency

German

CEFR A1 · studying toward A2