My name is Jonathan, thanks for checking out my profile! I am an Analytical Chemistry grad and fine wine professional with a big passion for data analysis and web development. My mainstay is all things Python: data, scripting, and most recently full stack web development, but I am more and more moving to SQL-first projects, especially with DuckDB and dbt. I am currently on the hunt for a job in data analysis in Australia, preferably somewhere I can leverage my knowledge of wine, chemistry or otherwise. What follows is a description of my skillset and recent projects.
Python: Pandas, Polars, scikit-learn, scipy, numpy, matplotlib, plotly, etc. Lately I've been working on upping my SQL game with DuckDB, sqlite, postgres and working to integrate dbt. My latest project utilises airflow to orchestrate ingestion of pdf documents into a webapp backend for digitisation and analysis. Django was my tool of choice for that implementation.
Presently I am learning javascript with the intention of integrating React into my personal webapp projects in order to provide a modern web experience.
May 2025 - November 2025
Wine Wiki was initially built on a simple premise - how to get as much information to a wine professional as possible while removing any unncessary friction. Even in 2025 most restaurants don't allow their staff to use phones during work hours, a stark contrast to practically any other profession, so how is that professional supposed to keep up to date with their products, espeically when competing with customers who have Vivino or winesearcher a tap away? My solution was to digitise the wine list, presenting the landing page as per that document but each wine on each line of each page would provide links to useful websites and a wine profile page whose content was provided by the business itself. What followed was Wine Wiki.
The final architecture utilised Airflow to orchestrate the complex ETL pipline required to extract the content and formatting of the wine list from a provided PDF and normalising the data suitable for a webapp backend. Django was the framework of choice, as I was already comfortable with Python. This was a great learning project for me because I'd never done any web development before so I had to learn a lot about how the modern web worked, how modern web frameworks work, etc.
As of November 2025 a number of staff at a particular venue utilise Wine Wiki to store their reading and tasting notes, and I'm in the early stages of testing an automated edition updater to ensure the display on the app is always in sync with the current wine list edition.