Experience
Two decades of making data and systems work
Joe's roles have ranged from database administrator and data architect to head of platform and technology lead: designing data warehouses, leading migrations, integrating with partners' systems, and leading the development teams that build them.
20+ years
In data, databases and software, from building web shops in the early 2000s to designing SaaS platforms today.
Health and logistics
Deep knowledge of NHS data and national datasets, and of ecommerce delivery, returns and the circular economy.
Leading teams
Heading data teams, managing in-house, offshore and outsourced developers, and leading technical reviews with large retailers.
Healthcare
NHS data, from the warehouse to the national returns
A large NHS teaching hospital trust
Thirteen years leading the Data Management team. Joe built the Trust's reporting data warehouse, bringing together clinical, pharmacy, workforce, finance and performance data, and its reporting suite and dashboards.
A first-of-type migration
When the Trust moved to a new patient administration system in 2017, the first organisation to do so, Joe led the data migration: millions of records moved, checked by a purpose-built comparison tool, with reporting working on day one.
Clinical tools
Designing the data and integrations for the Trust's in-house electronic patient record, and building warning tools with clinicians and researchers, for infection control and early warning alerts, from real-time data.
National data standards
Contract work for NHS organisations on Commissioning Data Sets, Faster Data Flows and new data warehouses and reporting, including automating manual processes and retiring legacy systems.
Logistics, returns and ecommerce
Carriers, returns platforms and the retailers that use them
A major UK out-of-home carrier, now
Currently Technical Onboarding Manager (previously Client Integration Manager), managing front-end ecommerce integration for merchants joining the carrier's locker and parcel shop delivery and returns services. That covers new integrations and migrating existing ones onto the carrier's APIs and webhooks, for choosing a pick-up point at checkout, label generation and tracking. Specialising in Shopify and API connectivity: troubleshooting, solution design, and finding ways for each merchant to make the most of what the carrier can do.
An international courier's returns portal
Supporting and building out the courier's new returns portal: carrier and platform integrations, and onboarding merchants onto it.
A returns platform for global retailers
Head of Platform Solutions: the platform roadmap, solution design for full system integrations with major online retailers, offshore development teams, and IT due diligence for the company's sale.
A UK pallet network
Reviewing the systems, data and tech team, then redesigning the data warehouse and customer reporting for real-time pallet network performance in Azure, and upskilling the team to carry it on.
The circular economy
Co-founder and technology lead for a new international SaaS platform for returns, takeback and producer responsibility: solution design, API contracts and leading the development team.
Integration monitoring tools
Tools that check integrations keep working, such as an order monitor that places real test checkouts and API orders on a Shopify development store every few minutes, times how quickly a carrier's app picks each one up, and charts and alerts on the results.
Working with AI
Fluent with AI, in the work and in the product
AI is part of how JHR Tech works every day, not a buzzword on the side. Joe uses it to build faster and to put useful AI features into the software itself, with the judgement to know where it helps and where it doesn't.
Building with Claude
JHR Tech's apps are built with Anthropic's Claude as a day-to-day development partner: writing and refactoring code, tests, data migrations, documentation and page copy. Joe sets the direction, reviews the work and tests it, which is how a small company ships this much.
AI features in products
Practical features using the Claude API: an email assistant that says whether a message needs action, and a running coach that answers questions from someone's actual training, with structured answers the app checks.
Used carefully
AI only sees the data a task needs, keys stay on the server, results are checked by code and by people, and everything is tested before it goes live.
How we can help
What that experience is good for
Databases and data warehouses
Design, migration, performance tuning and reporting on SQL Server, Azure and PostgreSQL, including ETL with SSIS and Data Factory, and reporting in SSRS and Power BI.
Carrier and returns integrations
Connecting shops and platforms to carriers and returns services through their APIs and webhooks, for pick-up points at checkout, labels and tracking, and getting merchants live on them. Ordersmith, our Shopify app, comes from the same experience.
Putting AI to work
Finding where AI genuinely helps, and adding it to your software or processes safely and productively. See AI consultancy.
Software built for you
Web apps, integrations and automation: see bespoke software development and Shopify app development.
Skills
Tools and technologies
- SQL Server
- Azure SQL and Data Factory
- PostgreSQL
- MySQL
- Snowflake
- InterSystems Caché and IRIS
- SSIS, SSRS and SSAS
- Power BI
- Tableau
- DOMO
- REST and SOAP APIs
- HL7, Mirth and Rhapsody
- C# and .NET
- TypeScript and Node.js
- React
- Claude and Claude Code
- AWS, GCP and Fly.io
- Shopify
Looking for help with data, integrations or a new build?
Tell us what you're working on and we'll reply by email, or connect with Joe on LinkedIn.