Thinklytics

Data Architecture Consulting Firms

How to choose a data architecture consulting firm

Most data architecture engagements produce a diagram. The useful ones produce a design your team can operate after the consultants leave, which is a different deliverable and a different conversation. These are the questions that tell the two apart before you sign.

What separates a strong Data Architecture consulting company

They design against your systems, not a reference architecture

A reference architecture is a vendor diagram with your logo on it. Ask what they will read before designing: the actual schemas, the actual job failures, the actual places two systems disagree about the same record. A design that never touched your data is a slide.

They say what to retire, not only what to add

Architecture work that only adds layers leaves you with more surface to operate and the original problem intact. The firms worth hiring come back with a decommission list, and they are specific about what breaks when each thing goes.

They settle the definitions before the pipelines

If two teams disagree about what a customer or a booking is, no architecture fixes it, because the ambiguity moves downstream into whatever you build. Semantic layer and ownership decisions belong before the platform choice, not after.

They are specific about who operates it

Ask who runs this in month six, what skills that needs, and what it costs in people rather than licences. An architecture your team cannot staff is a dependency sold as a design.

They are platform-agnostic in a checkable way

Everyone claims it. The test is whether they will name a case where they recommended against the platform they most often implement. A firm whose answer never varies by client is describing its own partner agreements.

They tell you when you do not need this

Plenty of reporting problems are definition problems or one broken join, and a full architecture engagement is an expensive way to find that out. A firm that scopes the diagnosis separately from the build can afford to say so.

Proof

  • 4,380 workbooks: Retired at AT&T, with server response cut from 47 to 9 seconds and a $6.2M platform migration avoided
  • 14 definitions to 1: Regional patient encounter definitions consolidated in 11 weeks, ending $2.1M a year of reconciliation labour
  • Four systems to one: Core banking data unified, cutting $1.3M a year and delivering same-day member analytics

Where Thinklytics fits

Thinklytics designs against what is actually running, which means reading the schemas, the job history and the places two systems disagree before proposing anything. Senior people stay on the engagement end to end, so the person who sits in the meeting where two directors disagree about margin is the person who later writes the semantic layer that settles it. Every engagement produces a decommission list alongside the design, and where the honest finding is that the problem is a definition rather than an architecture, that is what the first stage says.

Related

Frequently asked questions

What do data architecture consulting firms actually do?

They decide how data moves and where it lives, which in practice means settling what the core entities mean, choosing where the authoritative record sits, designing the layers that serve reporting and models, and deciding what gets retired. The platform choice is the visible part and usually the least consequential. Most of the value is in the decisions about ownership and definitions that the platform then enforces.

How is data architecture consulting different from data engineering?

Architecture decides the shape; engineering builds it. The split matters commercially because they fail differently. A bad architecture produces a system that works and cannot be changed, which is the expensive failure and the one you discover in year two. Weak engineering produces a system that breaks visibly, which is cheaper to fix. If a firm only offers one of the two, ask who does the other and when they get involved.

What should a data architecture engagement deliver?

Four things you can hold. A design mapped to your real systems rather than a reference diagram. A decommission list, with what breaks when each item goes. The definitions and ownership for the core entities, agreed with the people who disagree about them. And a sequence that delivers something usable in weeks rather than at the end. If the deliverable is only a diagram, the hard decisions have been deferred to whoever implements it.

Do we need a data architecture consultant or a data strategy consultant?

Strategy decides which questions the business needs answered and in what order. Architecture decides how the data has to be shaped to answer them. If you already know what you are trying to answer and the problem is that your systems cannot answer it, you need architecture. If the disagreement is about priorities and value, strategy comes first, and architecture on an unagreed priority list is expensive guesswork.

How long does a data architecture engagement take?

The design for a bounded scope usually runs four to eight weeks, and the variable is how many systems have to be traced and how contested the ownership is. Implementation runs considerably longer and should be phased so something is usable early. Be wary of an architecture phase that runs six months, because it has consumed the budget that should have delivered the first piece of it.

What is modern data architecture, and do we need it?

The phrase usually means a lakehouse, separated storage and compute, and streaming where it earns its place. Whether you need it depends on the workload rather than the fashion. Plenty of mid-market reporting runs fine on a warehouse and a well-designed semantic layer, and the modern pattern adds operating burden a small team may not be able to staff. The question worth answering is which specific workload the current shape cannot serve.

Should we fix our architecture before building AI?

Some of it, and rarely all of it. The parts that matter for AI specifically are identity resolution, because a model acting on the wrong record is worse than one that does not act, and lineage, because an AI output you cannot trace is not defensible. The rest can usually wait. A short readiness read answers which is which for your use case far more cheaply than a full architecture programme.

Frequently asked questions

Use these as your shortlist criteria. A firm that can't meet them is selling hours, not outcomes.