OCCUVISTA

Data Analyst

Querying and interpreting data to answer business questions and support decision-making

Also known as:Data Analytics AnalystJunior Data AnalystInsights AnalystReporting Data AnalystBusiness Data Analyst
Growing

Data Analyst Salary

United Kingdom

£28,000 – £55,000

United States

$55,000 – $100,000

Varies by location, sector, and experience. Last updated: 2025.

What Is a Data Analyst?

A Data Analyst collects, queries, and interprets data to answer business questions and support decision-making. The role exists across virtually every industry — from e-commerce and finance to healthcare and the public sector — making it one of the most widely available entry points into a data career. Data Analysts work directly with business stakeholders, translating questions into analysis and presenting findings in a way that drives action.

Day-to-day work spans SQL querying, building reports and dashboards, cleaning and validating datasets, and communicating findings clearly. The role sits closer to the business than a Data Engineer or Analytics Engineer — the primary output is insight rather than infrastructure. Strong SQL, a working knowledge of at least one BI or visualisation tool, and the ability to tell a clear story with numbers are the core requirements for the role at any level.

What Does a Data Analyst Do?

  • Write SQL queries to extract and analyse data from relational databases and cloud data warehouses
  • Build and maintain dashboards and reports in BI tools to track business performance metrics for stakeholders
  • Clean, validate, and prepare datasets by identifying inconsistencies, handling nulls, and standardising formats before analysis
  • Identify trends, patterns, and anomalies in data and present findings with clear visualisations and narrative context
  • Respond to ad hoc data requests from business teams, scoping requirements and delivering analysis to agreed timelines
  • Document analysis methodology and maintain clear records of data sources, transformation logic, and field definitions

Data Analyst Skills

Hard Skills

  • SQL
  • Data Analysis
  • Reporting and Visualisation
  • Data Quality Management
  • Statistical Modelling
  • Data Modelling
  • Stakeholder Management
  • Requirements Gathering
  • Python

Soft Skills

  • Analytical ThinkingTranslating business questions into SQL queries
  • CommunicationPresenting findings to non-technical stakeholders
  • Attention to DetailValidating data quality before drawing conclusions
  • Stakeholder ManagementScoping analysis requests across business teams
  • StorytellingFraming data findings as actionable narratives
  • CuriosityProbing data to surface unexpected patterns

Data Analyst Tools & Software

How to Become a Data Analyst

Typical Route

Most Data Analysts hold a bachelor's degree in Mathematics, Statistics, Economics, Computer Science, or Business. The role is among the most accessible in data — analytical aptitude and SQL proficiency matter more than a specific major, and graduates from social science, finance, and engineering backgrounds enter regularly. Community colleges offering two-year programs in business analytics or data management provide a viable entry route. A master's degree in Data Science, Business Analytics, or Applied Statistics supports progression into senior analyst and specialist positions.

Alternative Route

Google Data Analytics Professional Certificate and Microsoft Power BI Data Analyst (PL-300) are widely recognised entry credentials. IBM Data Analyst Professional Certificate provides a comprehensive structured pathway. Bootcamps including Springboard and Thinkful run data analytics programs suited to career switchers building SQL and Python skills. A portfolio of SQL queries, dashboards, and analysis projects published on GitHub is consistently cited by US hiring managers as the most persuasive evidence of readiness alongside or in place of formal qualifications.

A Day in the Life of a Data Analyst

Morning

Pull the weekly active user data from the data warehouse using SQL and investigate a 14% drop in engagement for the Android app cohort that appeared in yesterday's automated report
Clean and validate a dataset provided by the logistics team for a delivery performance analysis, identifying and resolving 340 rows with mismatched order IDs before the analysis can proceed
Respond to the marketing director's request for conversion rates by acquisition channel over the past 90 days, scoping the query before starting

Afternoon

Complete the conversion rate analysis and build a simple Tableau bar chart showing channel performance against the 3.2% target, ready for the marketing team's weekly review meeting tomorrow
Present the Android engagement findings to the product manager, walking through the query logic, the three hypotheses for the drop, and the segmentation needed to test each one
Update the monthly retention dashboard after the data engineering team fixed an upstream pipeline bug that had been undercounting reactivated users for the past six weeks

Data Analyst Career Path

Junior Data Analyst

0–2 yrs

→

Data Analyst

2–4 yrs

→

Senior Data Analyst

4–6 yrs

→

Analytics Engineer / Data Scientist

6–8 yrs

→

Head of Analytics / Data Lead

8+ yrs

Data Analyst Job Outlook

Growing

Data Analyst is one of the most consistently in-demand roles across all sectors — financial services, retail, healthcare, and the public sector all hire at volume, and virtually every organisation with meaningful data benefits from analytical capability. Demand is growing as data-informed decision-making becomes a baseline expectation rather than a differentiator. The role is also one of the strongest career-switcher entry points in tech, with a well-established certification and portfolio pathway that does not require a computer science degree.

Related Roles