Hey, I'm
Zain Siddiqi
Analytics Engineer
London, UK
About Me
I am an Analytics Engineer with 2 years of experience in data analytics managing the full data lifecycle, from ELT to Serving Dashboards. Coming from a background in Physics, I love to turn complex datasets into meaningful insights, whether that be through data models, notebook analyses, reports, or dashboards.
I am proficient in Python, SQL, dbt, Git, and various BI tools such as PowerBI, Tableau, and Looker.I am currently working as an analytics engineer using a modern data stack with dbt, Databricks, and GitHub. I often post my learnings and thoughts in my newsletter the Analytics Engineering Chai. I'm always looking to connect with data professionals and discuss all things data, please find my contact details and CV as buttons!Personally, I love playing golf, video games (PlayStation >>), chess, walking in nature, and watching movies from the golden era (2000s)!
PROJECTS
Analysing my Chess Games
I extract data from my chess games using APIs in Python and land it in Google BigQuery. I then use dbt to model it into a Star Schema and create a view which is fed into a Google Looker Dashboard, giving me insights. Orchestration is done using Dagster.
Tools
Python, SQL, git
BigQuery, dbt, Dagster, Looker Studio
Self-made Spotify Wrapped
I request my personal data from Spotify. I use the Spotify API to request song features to enrich my listening history dataset. I clean these datasets using Python. Finally, I create a dashboard on Tableau showing insights about my music listening.