Occupational Dossier
Data Analyst
Technology / Business / Finance · "Without Data Analysts, organisations make decisions based on gut instinct, politics, and noise — instead of evidence."
Organisations generate vast amounts of data but consistently struggle to extract meaning from it. Data Analysts identify patterns, test hypotheses, and translate numerical complexity into decisions that drive real business outcomes.
Work environment
Steady with Deadlines
Low-Medium
Collaborative
Where the work happens
AI exposure — Medium
AI tools handle routine analysis and report generation, but demand is growing for analysts who can frame complex problems, interpret nuanced results, and influence decisions. The role is evolving towards "insight strategist" and business partner.
One word carries a body of evidence: sector employment projections, skill-shortage pressure, and the changing shape of the work itself.
See the evidence ↓The skills behind it
Each is an observable action, done repeatedly under real constraints — not a trait.
The tools & the tribe
A tool amplifies the action; the tribe is where the craft's community gathers.
Professional tribeWhere this walk leads
Structural neighbours — work that shares this role's observable actions. An exploration, never a recommendation.
Skill neighboursContents & connections
What the work consists ofThe tool in handDoing it wellMyth & realityWhy it mattersWho's around youPathways inWhy "Rising" — the evidence↑ Back to the coverWhat the work consists of
Querying and joining datasets using SQL across multiple databases
Data Analysts sit between raw data and real-world decisions. The work involves querying databases, cleaning messy datasets, building dashboards, conducting statistical analysis, and presenting findings to stakeholders who do not speak SQL. The hardest and most valuable part of the job is not the technical execution — it is knowing what question to ask in the first place.
- Querying and joining datasets using SQL across multiple databases
- Cleaning, transforming, and validating raw data for analysis
- Building interactive dashboards and automated reports for business teams
- Conducting exploratory data analysis to identify trends, anomalies, and opportunities
- Designing and analysing A/B tests to measure the impact of product changes
- Presenting findings and recommendations to stakeholders in non-technical language
Key benefits: high demand across every industry; clear salary progression and career ladder; remote-friendly and flexible working; direct influence on business strategy; accessible entry routes — no cs degree required.
Missing some of these skills? See how to build them outside formal employment →The tool in hand
One measurement tool carries the trade — the judgement reading it stays human.
The measurement layer of this role runs through Tableau / Power BI / Looker — The BI and data visualisation platforms that turn database queries and spreadsheet data into dashboards, reports, and charts that non-technical stakeholders can navigate.
Doing it well
Accuracy of analytical outputs, speed of insight delivery, stakeholder adoption of recommendations, measurable business impact of decisions taken from analysis.
Weekly — via stakeholder check-ins, dashboard engagement metrics, and sprint reviews. This is a role where you find out for certain whether you were right.
Myth & reality
Why it matters
Flawed or absent analysis leads to mispriced products, wasted marketing spend, missed business opportunities, and strategic decisions made on false premises — costing organisations millions.
Data cleaning and wrangling (typically 70–80% of project time), chasing down data quality issues across teams, explaining the same statistical caveats repeatedly, and managing expectations of stakeholders who want certainty from uncertain data.
Who's around you
Day to day: Product Managers, Software Engineers, Marketing Teams, Finance Directors, UX Researchers — each carried in the ledger as a live link while you read this section.
The tribe: Royal Statistical Society · DAMA International · local data community meetups.
Pathways in — real routes people have taken
Several doors, not one — and none of them close behind you.
Formal gateways: BSc Mathematics / Statistics / Economics · Google Data Analytics Certificate (Coursera) · MSc Data Science · Self-taught via SQL courses and portfolio projects on Kaggle / GitHub. Fields of study: Mathematics & Statistics, Computer Science, Economics / Business.
Why "Stable" — the evidence behind the word
AI tools handle routine analysis and report generation, but demand is growing for analysts who can frame…
AI tools handle routine analysis and report generation, but demand is growing for analysts who can frame complex problems, interpret nuanced results, and influence decisions. The role is evolving towards "insight strategist" and business partner.
Sector baseline · published sourcesCovers Technology & Digital — the sector this role sits in. Per-role occupation-level (SOC) live data is a separate, pending item.
What the sector data means here: AI-exposed roles are changing fastest — but demand for digital professionals continues to outpace supply across all specialisms.
How the work itself is changing: From manual Excel pivot tables and static reports to cloud-scale SQL, self-serve BI platforms, and AI-assisted pattern detection.
SECTOR-LEVEL DATA · WORKING FUTURES 6 (UKCES) · UK EMPLOYER SKILLS SURVEY 2022 · EDUCATIONAL CONTEXT — NOT A PREDICTION ABOUT YOU.