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
Junior Data Analyst / Associate Consultant
1-2 yearsSkills to master
- Mastering data cleaning in Excel, writing efficient basic SQL queries, building clear charts in BI tools, and consistently delivering accurate work under supervision.
You're ready to move on when
- Consistently delivering accurate data pulls and initial analyses with minimal errors.
- Proactively identifying data quality issues and suggesting solutions.
- Successfully managing small, well-defined analytical tasks from start to finish.
- Receiving positive feedback on your ability to learn quickly and adapt to new tools.
- 2
Business Intelligence Analyst
2-3 yearsSkills to master
- Deep expertise in a specific BI tool (e.g., Power BI, Tableau), designing and maintaining complex dashboards, and understanding data warehousing concepts.
You're ready to move on when
- Demonstrated ability to build and maintain robust, user-friendly dashboards.
- Strong understanding of data models and how data flows through systems.
- Experience gathering requirements directly from business users for reporting needs.
- Positive feedback on your ability to translate business questions into technical BI solutions.
- 3
Financial Analyst (with strong data skills)
2-4 yearsSkills to master
- Advanced financial modelling in Excel, understanding of accounting principles, budgeting, forecasting, and profitability analysis.
You're ready to move on when
- Proven ability to build and maintain complex financial models with high accuracy.
- Strong understanding of P&L, balance sheets, and cash flow statements.
- Experience using data to support financial planning and analysis activities.
- Positive feedback on your ability to explain financial concepts clearly.