Data Engineer • Geospatial • PostgreSQL
Building fast, reliable geospatial data systems with PostgreSQL, FME & Python.
Leeds‑based data engineer focused on Postgres/PostGIS, H3, and tidy pipelines. I ship optimised queries, clean data flows, and useful APIs.
- 10+ years in geospatial and data.
- PostGIS, H3, spatial indexing.
- ETL/ELT, APIs, CI/CD.
- Python, PL/pgSQL, FME.
About
A GIS veteran turned data engineer. I care about performant SQL, reproducible pipelines, and efficient spatial processing.
Experience
Data Engineer — Geolytix
Building and operating the geospatial databases powering retail and location planning.
- Design and tune PostgreSQL/PostGIS schemas for national‑scale datasets (partitioning, BRIN/GiST/GIN, query plans, VACUUM/ANALYZE strategy).
- Implement spatial processing with H3 (hex tiling, catchments, k‑ring search, distance, index‑based joins) and PL/pgSQL utilities.
- Optimise data‑science code for use in client‑facing production systems.
- Operationalise data‑science code for use in customer‑facing systems.
GIS Data Scientist — VU.CITY
Automation, web services for internal 3D data, and cloud Postgres/PostGIS operations.
- Built robust ETL automations in FME/Python.
- Wrote custom code for the creation of Unity assets.
- Shipped internal web services exposing 3D data assets.
- Deployed/administered Postgres/PostGIS in the cloud.
- Built a map‑based model ordering system; unlocked real sales value.
- Gained experience with Kubernetes (GKE) supporting internal services.
Senior Consultant — CACI
Demographic product creation and management across EMEA, as well as supporting internal products.
- Managed and built derivative demographic data products for Europe.
- Created FME workflows for high‑volume processing.
- Communicated product development across the organisation.
Logistics & IT Consultant — Map Mechanics
Custom road networks and logistics solutions for NA/EMEA markets.
- Built customised road networks for logistics and retail planning.
- Scoped, delivered, and integrated logistics solutions for clients.
- Customised software to meet client logistics constraints and requirements.
- Trained technical and non‑technical staff.
IT Support Technician — Gowling WLG
On‑call/off‑site IT support and asset management.
- Serviced office IT and implemented corporate IT and data‑security policies.
Senior GIS Consultant — Compass Informatics
Managed large ESRI‑based systems; delivered on‑ and off‑site training.
- Managed ESRI architecture deployments.
- Delivered training to local government and state agencies.
Skills
Projects
Model Ordering System
Planned, built, and deployed a map‑based system for ordering 3D models, integrating with self‑built internal APIs and data services. Streamlined the ordering process, allowing users to select areas on a map and request 3D models, reducing delivery time and request iterations while unlocking real sales value.
Book a Chat
Want to discuss a project or opportunity? Book a 30‑minute chat with me directly:
Book via CalendlyContact
Open to data engineering, cloud, and geospatial work.
- osarhan@gmail.com
- Leeds, UK
- +447402325510