OCCUVISTA
Home›Categories›Data and Analytics

Data and Analytics

Turning raw data into insight, infrastructure, and intelligence

Overview

Data and Analytics covers the roles that collect, move, transform, store, analyse, and model data across organisations. It is one of the largest and most varied career categories in technology — spanning hands-on data analysis and business reporting through to engineering complex data pipelines, building machine learning models, and designing the architecture of entire data platforms.

The category has three broad orientations. Data engineers and architects build and maintain the infrastructure that makes data available and reliable. Analysts and BI professionals query and interpret data to answer business questions. Data scientists and ML engineers develop statistical models and machine learning systems. Many roles sit at the boundaries between these areas, and SQL is the one skill that runs across almost all of them regardless of specialism.

Roles in this Category

25 roles

Skills

Hard Skills

  • SQL
  • Python
  • Data Pipeline Orchestration
  • Statistical Modelling
  • Data Quality Management
  • Data Modelling
  • ETL Pipeline Design
  • Reporting and Visualisation
  • Data Governance

Soft Skills

  • CommunicationTranslating findings for non-technical audiences
  • Attention to DetailSmall data errors propagate downstream
  • Analytical ThinkingFraming questions before touching the data
  • CollaborationWorking across engineering, product, and analytics
  • Analytical RigourSeparating signal from noise in messy data
  • Engineering DisciplineBuilding data systems that hold up at scale

Tools & Software

AWSSnowflakedbtSQL ServerApache AirflowPower BIDatabricksJupyter Notebook

Core Themes

  • Querying, cleaning, and preparing data for analysis or downstream use
  • Building and maintaining data pipelines and transformation layers
  • Designing data warehouse, data lake, and lakehouse architectures
  • Developing dashboards, reports, and visualisations for business stakeholders
  • Building, training, and deploying machine learning and statistical models
  • Ensuring data quality, governance, and lineage across the data platform
  • Working closely with engineering, product, and business teams to make data useful

Typical Entry Points

Data Analyst and SQL Developer are the most accessible entry roles — many practitioners enter through self-study, bootcamps, or degrees in Mathematics, Statistics, Economics, or Computer Science. Google Data Analytics Professional Certificate and Microsoft Power BI certifications are recognised entry credentials. A portfolio of SQL queries, dashboards, or data projects on GitHub is the primary hiring signal for career switchers.

Who This Category Is For

  • People who enjoy finding patterns and meaning in numbers and datasets
  • Those who like asking why — not just reporting what the data shows
  • People from analytical backgrounds (finance, research, economics) considering a tech transition
  • Those comfortable with ambiguity — data problems are rarely clean or straightforward
  • People who want a career path with clear progression from analyst to engineer to architect
  • Those interested in AI and machine learning as a longer-term direction
  • People who want to be involved in business decisions without being in a pure management role
  • Those who enjoy writing SQL — it is a daily activity across most roles in this category

Related Categories

Recommended Reading

Designing Data-Intensive Applications — Martin Kleppmann

Fundamentals of Data Engineering — Joe Reis & Matt Housley

Storytelling with Data — Cole Nussbaumer Knaflic

Python for Data Analysis — Wes McKinney