The pathway
How you actually get there, here
How you become one varies far more by country than what one does. This is the UK route. Most people take one of these ways in; the right one depends on where you're starting from.
- 1
From Mid-Level BI Analyst
2-3 years as a Mid-Level AnalystSkills to master
- Independent project ownership, advanced SQL/Python, initial stakeholder management, and basic data modelling. You'll have proven you can deliver reliable analyses on your own.
You're ready to move on when
- You're consistently delivering complex ad-hoc analyses without much supervision.
- You've started identifying data quality issues proactively, not just reacting to them.
- You're the go-to person for specific types of data requests or dashboards.
- You've expressed interest in mentoring junior team members.
- 2
From Data Analyst (Specialised Domain)
3-5 years in a specialised data role (e.g., Marketing Analyst, Financial Analyst)Skills to master
- Deep domain expertise, strong analytical skills, and the ability to translate business needs into data requirements. You'll need to pick up the broader BI tech stack (dbt, Snowflake) and advanced data modelling.
You're ready to move on when
- You've built complex analytical models in Excel or a similar tool for your domain.
- You're frustrated by the limitations of your current tools and want to build more scalable solutions.
- You've started learning SQL and a BI tool in your spare time.
- You have a strong desire to broaden your technical skills beyond your current specialisation.
- 3
From Data Engineer (with BI interest)
2-4 years as a Data EngineerSkills to master
- Strong data pipeline building and data warehousing skills. You'll need to develop your data visualisation, storytelling, and direct stakeholder management skills, as well as business acumen for specific domains.
You're ready to move on when
- You enjoy seeing the 'end product' of your data pipelines in dashboards.
- You're interested in the business context and impact of the data you're moving.
- You've started building simple dashboards for your own team's metrics.
- You want to be closer to the business decision-making process.