David Raznick

Twenty years working with data-heavy systems — with a particular strength in taking over or replacing ad-hoc systems and turning them into reliable applications that non-technical staff enjoy using.

Comfortable owning a system end to end: data modelling, backend, frontend, deployment, and ongoing development driven by user feedback.

Employment

Global Energy Monitor

Nov 2022 – present

Software Developer and Data Engineer

Designed and built, from scratch, the Django database application that GEM's researchers now use as the home for their research data, replacing a large collection of spreadsheets.
Sole full-stack developer: data model, backend, frontend (Django + HTMX), PostgreSQL, deployment (Heroku) and ongoing development.
Migrated all of GEM's energy-generating project data into the system, followed by LNG, steel, and oil & gas extraction trackers, with the aim of bringing all remaining trackers into the database.
Continue to develop the application in short feedback cycles with its users; feedback from researchers across the organisation has been consistently positive.

The system now serves ~80 researchers and holds ~150,000 projects across ~200,000 units and phases.

Part time until August 2023, full time since.

Open Data Services Co-operative

Jan 2016 – Aug 2023

Director / Senior Developer

Lead developer on a variety of open-data projects, e.g. GrantNav — 360Giving's search tool for UK grants data.
Main developer of flatterer, a fast JSON-to-CSV/XLSX/SQLite/Parquet converter with a Rust core and Python bindings — 200+ GitHub stars.
Heavily worked on flatten-tool, converting between spreadsheets and structured JSON data.
Designed and developed tools to help data analysts and data publishers do their work.
As a director, helped run the co-operative.

Overlapped part time with Global Energy Monitor from November 2022.

Open Knowledge Foundation

Jan 2011 – May 2014

Senior Python Developer

Development lead for CKAN, the open-source open-data publishing platform used mainly by governments — responsible for overseeing all areas of its development.
Took ownership of a large existing codebase, assessed it, and steered its improvement and roadmap.
Client facing: translated client needs into development plans.
Lead developer on data.gov.uk and data.gov.

Amnesty International

Apr 2006 – Jan 2011

Data Analyst

Developed all reporting systems covering supporter (activist/donor) activity; designed and implemented all statistical reports.
Developed the in-house data processing system for data input.
Responsible for integrating all internal datasets and for the data migration onto a new database system.

192.com

Oct 2005 – Apr 2006

Data Analyst

Marketing and management reporting; search and traffic analysis; advised developers on efficiency improvements.

Buongiorno Vitaminic

Aug 2004 – Oct 2005

Data Analyst

Data mining for CRM campaigns; financial, analytical and ad-hoc reporting across the business; liaised with the development team on system improvements.