Sign in

Andrew Jones

@andrew-jones.com
279 followers 637 following 257 posts

Principal Engineer. Created Data Contracts and wrote the book on it. Father of 2. Brewer of beer. Aphantasic. Newsletter 👉 andrew-jones.com/newsletter

PostsRepliesMedia
Andrew Jones @andrew-jones.com · 11/10/2026
I have only one joke about time. I don’t have a second. #SundayPunday
000
Andrew Jones @andrew-jones.com · 09/10/2026
In this week's newsletter I write about Singer and more generally about abstractions for data engineering. There's also links to articles on is AI doing less, what makes a data product, and what actually is an ontology. a-j.io/n261009 #DataBS
a-j.io
Singer and abstractions for data integration
All abstractions are wrong, but some are useful.
010
Andrew Jones @andrew-jones.com · 07/10/2026
I've been working this week on an agentic pipeline builder and one of the discussions we've been having is how much of a pipeline would be agentic. This is an interesting data point. tomtunguz.com/hybrid-state...
tomtunguz.com
Is AI Doing Less & Less?
Analysis of 14 production agent workflows reveals the optimal balance between deterministic code & LLM inference. 65% of nodes run as pure code, saving tokens & improving reliability.
000
Andrew Jones @andrew-jones.com · 04/10/2026
Solar power is the future, but it won’t happen overnight. #SundayPunday
010
Andrew Jones @andrew-jones.com · 02/10/2026
In this week's newsletter I look at the context required to build a self-service data platform. There's also links to semantic layers and headless BI, BigQuery graph as a semantic layer, and the easiest tracking setup in the world. a-j.io/n261002 #DataBS
a-j.io
Self-service platforms run on context
To provide capabilities the platform needs context
000
Andrew Jones @andrew-jones.com · 27/09/2026
I was sitting drinking tea in my slippers this morning, when I thought to myself… I really need to wash some mugs. #SundayPunday
000
Andrew Jones @andrew-jones.com · 25/09/2026
In this week's newsletter I write about the draw of Iceberg. There's also links to articles on real-time personalisation, shifting from imperative to declarative, and dbt-contracts. a-j.io/n260925 #DataBS
a-j.io
The draw of open storage formats
Why are people drawn to the Iceberg?
000
Andrew Jones @andrew-jones.com · 20/09/2026
They thought I’d get the name of the Black Eyed Peas frontman wrong. I said Will I Now? #SundayPunday
010
Andrew Jones @andrew-jones.com · 18/09/2026
In this week's newsletter I look at the costs of schema-on-read vs schema on write. There's also links to articles on an AI-ready warehouse, modelling and semantic layers, and where data goes. a-j.io/n260918 #DataBS
a-j.io
Schema-on-read vs schema on write: It's about the costs
Both the costs to each party and the total costs to the business
020
Andrew Jones @andrew-jones.com · 13/09/2026
I bought my kids a book called ‘Spot the Dog’. What a waste of money. The dog was the main picture on every page. #SundayPunday
001
Andrew Jones @andrew-jones.com · 11/09/2026
In this week's newsletter I write about how to frame data contracts to different audiences. There's also links to articles on graphs in practice at Netflix, ODCS v3.2.0 and ODPS v1.1.0 release, and asking is the data catalog finally dead. a-j.io/n260911 #DataBS
a-j.io
How to frame data contracts
How you frame them depends on your audience
000
Andrew Jones @andrew-jones.com · 06/09/2026
Which country’s capital is the fastest growing? Ireland. Every year, it’s Dublin. #SundayPunday
000
Andrew Jones @andrew-jones.com · 04/09/2026
In this week's newsletter I write about how we increase data accessibility. There's also links to articles on RAG architectures, LLMs in search, and agentic data. a-j.io/n260904 #DataBS
a-j.io
Increasing data accessibility
It can't all be done by data engineers
000
Andrew Jones @andrew-jones.com · 16/08/2026
My friend Tony asked me not to say his name backwards. I asked, “Why not?” #SundayPunday
020
Andrew Jones @andrew-jones.com · 14/08/2026
In this week's newsletter I write about what ownership is (it's complicated!). There's also links to articles on closing the context gap, getting your data team a seat at the table, and creating data & AI use cases. a-j.io/n260814 #DataBS
a-j.io
What is ownership?
It's not just what the spreadsheet says
010
Andrew Jones @andrew-jones.com · 09/08/2026
Roman numeral puns are great and I for one will continue to make them. #SundayPunday
021
Andrew Jones @andrew-jones.com · 07/08/2026
This week I write about how, when our data output needs to be reliable, so does our input. There's also links to posts on using data contracts to build a shared language, federated data architecture with DuckDB, and Bitol becoming a graduate project a-j.io/n260807 #DataBS
a-j.io
Reliable output needs a reliable upstream
Pipelines can only be as reliable as their inputs
110
Andrew Jones @andrew-jones.com · 02/08/2026
Police have just arrested the tongue-twister world champion. If found guilty, they’ll be given a very tough sentence. #SundayPunday
000
Andrew Jones @andrew-jones.com · 31/07/2026
In this week's newsletter I write about limiting what you have in your data contract. There's also links to articles on how a SSOT depends on governance, inverting data architectures, and shifting quality left. a-j.io/n260731 #DataBS
a-j.io
Limit what you have in your data contract
Only put in fields that drive automation
010
Andrew Jones @andrew-jones.com · 26/07/2026
My friend Sid was a sudden ID theft victim. Now they’re just S. #SundayPunday
000
Andrew Jones @andrew-jones.com · 24/07/2026
In this week's newsletter I write about how IaC is a prerequisite for automation, including automating with agents. There's also links to articles on improving agentic analytics, building an Agentic Development Platform, and Apache Ossie. a-j.io/n260724 #DataBS
a-j.io
IaC is a prerequisite for automation
That's true for tooling and AI agents
010
Andrew Jones @andrew-jones.com · 21/07/2026
Interesting analysis on what makes an impact when trying to improve agentic analytics decisionspine.com/blog/agentic...
decisionspine.com
Agentic Analytics: How Much Does Grounding Actually Buy You?
Every vendor says their AI analyst works, and the benchmark numbers are high. So I built one in a controlled lab and added grounding one layer at a time (semantic layer, verified examples, knowledge…
010
Andrew Jones @andrew-jones.com · 19/07/2026
Germany is advising people to stock up on cheese and sausages, in what officials are calling the Wurst Käse scenario. #SundayPunday
020
Andrew Jones @andrew-jones.com · 17/07/2026
This week's newsletter is about change management for changes that impact the meaning of data. There's also links to articles on building a context layer, Write-Audit-Publish for analytics agents, and a new data streaming framework. a-j.io/n260717 #DataBS
a-j.io
Data contracts anti-pattern #4: Your CI passed. Your data still broke.
How to manage changes of *meaning* as well as structure
000
Andrew Jones @andrew-jones.com · 12/07/2026
A ship carrying red paint collided with a ship carrying purple paint. Both crews thought to be marooned. #SundayPunday
010
Andrew Jones @andrew-jones.com · 10/07/2026
In this week's newsletter I write about the 3rd anti-pattern in my series - Vanity SLOs. There's also links to articles on semantic vs context layers, building a semantic layer at Lyft, and data contracts in KCL. a-j.io/n260710 #DataBS
a-j.io
Data contracts anti-pattern #3: Vanity SLOs
SLOs that make a difference
010
Andrew Jones @andrew-jones.com · 05/07/2026
The most disapproving of all the Pharaohs was King Tut. #SundayPunday
020
Andrew Jones @andrew-jones.com · 03/07/2026
This week's newsletter is the second in my series of data contracts anti-patterns, following on from last week's post on contracts as documentation. There are also links to articles on data platform incident management and encoding your data expert. a-j.io/n260703 #DataBS
a-j.io
Data contracts anti-pattern #2: Checkbox compliance
Keep your data contracts lean and useful
020
Andrew Jones @andrew-jones.com · 28/06/2026
A man tried to sell me a coffin today. I told him that’s the last thing I need. #SundayPunday
100
Andrew Jones @andrew-jones.com · 26/06/2026
In this week's newsletter I write about the anti-pattern of contracts as documentation. There's also links to posts on building governance into the platform, making an impact as a platform PM, and analytical identifiers. a-j.io/n260626 #DataBS
a-j.io
Data contracts anti-pattern #1: Contracts as documentation
A data contract without impact is just documentation.
000
Andrew Jones @andrew-jones.com · 14/06/2026
Too many authors to quote? No problem et al. #SundayPunday
000
Andrew Jones @andrew-jones.com · 12/06/2026
In this week's newsletter I write about scaling data governance by moving away from documents and towards automation. There's also links to articles on data product managers, context graph architecture, and autonomous web scraping. a-j.io/n260612 #DataBS
a-j.io
Stop writing data governance policies
Automate them instead
021
Andrew Jones @andrew-jones.com · 07/06/2026
My mate lost his job as a pole vaulter. Never got over it. #SundayPunday
000
Andrew Jones @andrew-jones.com · 05/06/2026
In this week's newsletter I talk about the importance of meeting your users where they are. There's also links to articles on a meshy approach to building data models, SQL patterns for catching fraud, and the case for data marketplaces. a-j.io/n260605 #DataBS
a-j.io
Meet your users where they are
Focus on their developer experience, not your own
000
Andrew Jones @andrew-jones.com · 24/05/2026
Last weekend, I competed in the world race walking championship for the fourth time running. Needless to say, I was disqualified. #SundayPunday
010
Andrew Jones @andrew-jones.com · 22/05/2026
In this week's newsletter I write about how we can't just blame data producers, we need to look at ourselves and the support we give them. There's also links to context, finally achieving self-serve analytics, and synthetic customers. a-j.io/n260522 #DataBS
a-j.io
You can't just blame data producers for poor data quality
Look at yourselves too
110
Andrew Jones @andrew-jones.com · 21/05/2026
This is a good read on the future of platform engineering and the "missing middle" www.syntasso.io/post/platfor...
syntasso.io
Platform Engineering: Orchestrating Applications, Platforms, and Infrastructure
We all know that when the good people at Gartner highlight a topic as a strategic technology trend for the coming year, everyone will pay more attention – especially within the enterprise ecosystem.…
000
Andrew Jones @andrew-jones.com · 17/05/2026
Since I cancelled my subscription to the Scrabble Club, they’ve started sending me threatening letters. #SundayPunday
000
Andrew Jones @andrew-jones.com · 15/05/2026
In this week's newsletter I write about how to make your golden paths actually golden. There's also links to articles on self-serve data, north star metrics for AI data products, and standards in the data landscape. a-j.io/n260515 #DataBS
a-j.io
Make your golden paths actually golden
Or watch them quietly build their own
010
Andrew Jones @andrew-jones.com · 03/05/2026
I’ve just won the ‘World’s most secretive person’ award. I can’t tell you how much it means to me. #SundayPunday
010
Andrew Jones @andrew-jones.com · 01/05/2026
In this week's newsletter I write about the simple concept of data contracts, and its power. There's also links to articles on the 7-table fallacy and measurement engineering. And finally, a pun, but I can't say more. a-j.io/n260501 #DataBS
a-j.io
Data contracts are a simple concept
Simple concept, but powerful in practice
020
Andrew Jones @andrew-jones.com · 26/04/2026
Someone ripped off the front and back sections of my dictionary. It just goes from bad to worse. #SundayPunday
010
Andrew Jones @andrew-jones.com · 24/04/2026
"The best leaders don’t rely on smart people to notice mistakes in time. They build systems that assume confidence will arrive before correctness, and they design for that reality." Great post on challenging decisions. substack.com/home/post/p-...
substack.com
Red-Teaming Your Strategy
Why Certainty Needs Constraints
000
Andrew Jones @andrew-jones.com · 24/04/2026
In this week's newsletter I write about how the quality of a data product is not just the data, it's the code behind it too. There's also links to articles on building an LLM platform, speed when decentralising, and building decision systems. a-j.io/n260424 #DataBS
a-j.io
The quality of a data product is its data and its code
Monitoring code quality is as important as data quality
010
Andrew Jones @andrew-jones.com · 23/04/2026
I made a small but nice improvement to my terminal recently, where each project (git repo) now has its own background colour in the terminal. It's an effective context signal telling me which project I’m currently in as I'm bouncing around terminal windows. andrew-jones.com/blog/per-pro...
140
Andrew Jones @andrew-jones.com · 13/04/2026
This is a good read on the human quality of laziness, which LLMs do not have: bcantrill.dtrace.org/2026/04/12/t... (Also nice quote from one of the first computing books I read 🐪.)
bcantrill.dtrace.org
The peril of laziness lost
In his classic Programming Perl — affectionately known to a generation of technologists as "the Camel Book" — Larry Wall famously wrote of the three virtues of a programmer as laziness, impatience,…
010
Andrew Jones @andrew-jones.com · 12/04/2026
I’ve got some racing geese for sale. Let me know if you want to take a quick gander. #SundayPunday
000
Andrew Jones @andrew-jones.com · 10/04/2026
In this week's newsletter I write about finding the right level of abstraction. There's also links to articles on the outbox pattern at scale, first 90 days as a CDO, and measuring latency. a-j.io/n260410 #DataBS
a-j.io
The right level of abstraction
How do you find the sweet spot?
000
Andrew Jones @andrew-jones.com · 05/04/2026
What’s leather and sounds like a sneeze? A shoe! #SundayPunday
000
Andrew Jones @andrew-jones.com · 03/04/2026
In this week's newsletter I introduce the contract-driven data platform. There's also links to articles on the AI wave, the relevance of business models to data, and a self-improving Text-to-SQL engine. a-j.io/n260403 #DataBS
a-j.io
The Contract-driven Data Platform
What if there was a different way to build a data platform, one that is made up of consistent, interoperable, governed data products?
000