← Back to Insights
Lester Leong

Lester Leong

·4 min read

Will AI Replace Data Analysts? No. But It Will Expose Which Ones Were Misallocated.

The Replacement Narrative Is Wrong

There is a narrative circulating in every boardroom and analytics Slack channel: AI will replace analysts. It is wrong, but in an interesting way. The error is not in overestimating what AI can do. It is in misunderstanding what analysts were supposed to be doing in the first place.

Most analysts spend 60 to 70 percent of their time on tasks that are, in the strictest sense, mechanical. Pulling data from warehouses. Cleaning malformed tables. Generating summary statistics. Producing charts that visualize what happened last quarter. These tasks require skill, but they do not require judgment. They are necessary steps in a process, not the point of the process.

AI handles these tasks faster and, in many cases, more reliably than a human analyst working under deadline pressure. A well-configured AI agent can query a data warehouse, clean the output, run standard statistical summaries, and produce publication-quality visualizations in minutes. The same workflow takes a human analyst hours or days, depending on the complexity of the data and the number of interruptions in their calendar.

This is not a future scenario. It is the current state of production AI tooling available to any analytics team willing to adopt it.

The 30% That Cannot Be Automated

What AI cannot do is the remaining 30 percent of analyst work. And this 30 percent is where all the value lives.

Judgment is the ability to look at a set of findings and determine which ones matter. Not statistically significant. Not interesting. Which ones will change a decision that leadership is about to make. A model can surface anomalies. It cannot tell you which anomaly is a rounding error and which one signals a retention crisis in your highest-value customer segment.

Framing is the ability to structure an analysis so that the conclusion is inevitable by the time the reader reaches it. The same data, presented in two different frames, leads to two different decisions. Analysts who understand framing do not just present numbers. They build arguments that guide the reader to the right conclusion without ever appearing to advocate.

Translation is the bridge between analytical output and organizational action. An insight that sits in a notebook is worth nothing. An insight translated into a recommendation an executive can act on in the next leadership meeting is worth everything. This translation requires understanding the politics, priorities, and constraints of the people who will act on the finding. No model has that context.

Problem selection is arguably the most undervalued analytical skill. Choosing which question to investigate is more important than the sophistication of the analysis. A mediocre analysis of the right question outperforms a brilliant analysis of an irrelevant one. AI can answer questions efficiently. It cannot tell you which questions are worth asking.

The Team Structure Implication

If AI handles the mechanical 70 percent, the composition of analytics teams must change. The traditional hiring model prioritizes technical proficiency: SQL, Python, statistical modeling, data visualization tools. These skills were necessary because the mechanical work dominated the job. Analysts needed to be fast at pulling and transforming data because that is what they spent most of their time doing.

In an AI-augmented environment, these skills are table stakes, not differentiators. Every analyst will have access to AI tooling that handles data extraction, cleaning, and visualization. The competitive advantage shifts to the skills that were always the differentiator but were historically underweighted in hiring: communication, business judgment, and the ability to structure ambiguous problems.

This means analytics leaders need to rethink their hiring criteria. The analyst who writes the clearest memo is now more valuable than the analyst who writes the fastest query. The analyst who can walk into a room of executives and change their mental model with a single well-structured argument is more valuable than the analyst who can build a dashboard in an afternoon.

The uncomfortable implication: some of your current analysts were primarily valuable for their mechanical speed. As AI absorbs that work, their contribution gap becomes visible. This is not a failure of the analyst. It is a failure of the role design that allocated 70 percent of their time to work that did not require their most important skills.

The Hiring Pivot

The practical shift for analytics leaders is straightforward but requires discipline. Stop writing job descriptions that lead with "proficiency in SQL and Python." Those are increasingly commoditized capabilities. Start leading with "ability to translate analytical findings into executive-ready recommendations" and "experience structuring ambiguous business problems into testable hypotheses."

Screen for communication quality in the interview process. Ask candidates to take a messy dataset and produce a one-page decision memo, not a dashboard. Evaluate their ability to identify which findings matter, not their ability to find all the findings. The best analyst in an AI-augmented team is not the one who can do everything. It is the one who knows which thing to do.

This also changes how you develop existing team members. Invest in training that builds business acumen, presentation skills, and strategic thinking. These were always the skills that separated a good analyst from a great one. AI just made that separation impossible to ignore.

The New Operating Model

The analytics team of 2027 will look structurally different from the analytics team of 2023. Fewer people doing more impactful work. AI agents handling the data pipeline from extraction through visualization. Human analysts spending the majority of their time on judgment, framing, and translation.

This is not a reduction in headcount. It is a reallocation of effort. The same team that previously spent 70 percent of its time on mechanical work now spends 70 percent on strategic work. The output quality increases dramatically, not because the people changed, but because the work changed.

The organizations that make this transition first will have a compounding advantage. Their analysts will develop stronger judgment faster because they are practicing it more. Their decisions will improve because the analytical inputs are focused on the questions that matter. Their competitors will still be arguing about whether AI replaces analysts while they are already operating with analysts who are, for the first time, doing the job they were actually hired to do.

Stop asking whether AI will replace your analysts. Start asking whether your analysts are doing work worth protecting.

Want frameworks like this for your company?

I work with 3 to 4 AI-era companies at a time, building the analytics systems that turn data into decisions. If that sounds like what you need, let’s talk.

Get Your Free Diagnosis

Keep Reading