Article

From Pipelines to Products: The Craft of Analytics Engineering

What the role really is, according to someone who’s lived across the entire data stack.

Engineering

If you search “analytics engineer,” you’ll get a hundred different definitions. Most of them reduce the role to “the person who writes SQL,” which is a bit like saying a chef is “the person who uses knives.” Technically true, but wildly incomplete.

I’ve spent my career moving through every corner of the data world — data engineering, analytics, data science, and eventually leading data teams. Across all of that, analytics engineering is the discipline that has gripped me the most. Not because it was simple, but because it was incredibly impactful and takes a real craft.

Analytics engineering is the intersection of modeling, engineering, and product thinking

The best analytics engineers I’ve worked with — and the version of the role I eventually grew into — operate at a crossroads:

  • Modeling: shaping raw data into something structured, meaningful, and reusable
  • Engineering: building pipelines, abstractions, and systems that don’t collapse under real‑world use
  • Product thinking: understanding what people actually need, not just what they asked for

It’s a role that requires empathy for the user, respect for the data, and enough engineering discipline to keep the whole thing from turning into a pile of brittle SQL scripts.

It’s not about SQL — it’s about semantics

SQL is the tool.
Modeling is the craft.

Analytics engineers define the meaning of data:

  • What is a “customer”?
  • What counts as “active”?
  • How do we measure “retention”?
  • What does “revenue” actually mean in this company?

These aren’t technical questions. They’re semantic ones. And they shape everything downstream — dashboards, experiments, ML models, business decisions, even how teams talk about the business.

A good analytics engineer doesn’t just write queries.
They define the language of the organization.

It’s engineering, but with different failure modes

Data engineering fails loudly — pipelines break, jobs crash, alerts fire.

Analytics engineering fails quietly.

A subtle modeling mistake can:

  • inflate revenue
  • undercount users
  • mislead a product team
  • break an experiment
  • or send a leadership team down the wrong path entirely

The craft is in building systems that are:

  • trustworthy
  • testable
  • documented
  • predictable
  • boring in the best way

Analytics engineering is engineering with a UX layer — the user experience of data.

It’s also architecture

Analytics engineers design the shape of the data warehouse:

  • layers
  • dependencies
  • naming conventions
  • transformation patterns
  • semantic models
  • governance
  • lineage

It’s the closest thing the modern data stack has to software architecture. And it matters — a good architecture accelerates everyone. A bad one slows the entire company down.

It’s product work, whether people admit it or not

Analytics engineers build data products:

  • metrics
  • models
  • semantic layers
  • curated datasets
  • reusable transformations
  • documentation
  • dashboards that actually make sense

These aren’t “deliverables.” They’re products with users, expectations, and lifecycles.

The craft is in making data feel intuitive — not just available.

It’s communication, storytelling, and translation

Analytics engineers sit between:

  • data engineers
  • analysts
  • scientists
  • product managers
  • business stakeholders
  • leadership

They translate between worlds:

  • business → logic
  • logic → models
  • models → pipelines
  • pipelines → insights

It’s a role that requires clarity, diplomacy, and the ability to say “no” without making enemies.

It’s the glue that holds modern data teams together

Data engineering builds the foundation.
Analytics engineering shapes the structure.
Analytics and science build on top of it.

Without analytics engineering, everything becomes ad‑hoc:

  • duplicated logic
  • inconsistent metrics
  • dashboards that disagree
  • models built on shifting definitions
  • teams arguing over whose number is “right”

Analytics engineering is the discipline that prevents chaos.

And for me, it became the through‑line of my entire career

I didn’t start as an analytics engineer. I grew into it.

Data engineering taught me systems.
Analytics taught me empathy.
Science taught me rigor.
Leadership taught me clarity.

Analytics engineering is where all of that converged — the place where modeling, engineering, and product thinking finally clicked into one craft.

It’s not just writing SQL.
It’s shaping how an organization understands itself.