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
Associate Data Consultant (L1) Progression
1-2 years as an AssociateSkills to master
- Independent task execution, strong foundational SQL, basic dashboard building, clear communication of simple findings, proactive problem identification.
You're ready to move on when
- Consistently delivering accurate and on-time tasks with minimal supervision.
- Proactively identifying and suggesting solutions for minor data issues.
- Taking initiative to learn new tools and techniques beyond assigned work.
- Receiving positive feedback on the clarity and usefulness of your contributions from project leads.
- 2
External Data Analyst / BI Developer
2-4 years in a similar role outside of consultingSkills to master
- Advanced SQL, proficiency in a BI tool (Tableau/Power BI), experience with data transformation (e.g., dbt), strong analytical problem-solving, ability to translate business needs into technical requirements.
You're ready to move on when
- You've been responsible for end-to-end analytical projects in your previous role.
- You're comfortable presenting your findings to business stakeholders.
- You've actively sought out opportunities to improve data quality or processes.
- You have a genuine interest in the consulting approach to problem-solving and stakeholder management.
- 3
Business Analyst with Strong Data Focus
3-5 years as a Business AnalystSkills to master
- Strong requirements gathering, process mapping, understanding of business domains, coupled with solid SQL skills and experience working with data teams.
You're ready to move on when
- You've regularly worked closely with data teams to define reporting or analytical needs.
- You're comfortable querying data yourself to validate requirements or perform initial analyses.
- You have a proven ability to bridge the gap between business needs and technical solutions.
- You're looking for a role with more hands-on data analysis and less pure requirements documentation.