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
Innovation Analyst / Project Coordinator
1-2 yearsSkills to master
- Data collection, basic reporting, understanding project lifecycles, using project management tools (e.g., Jira).
You're ready to move on when
- Consistently delivers accurate data on time.
- Proactively identifies minor data discrepancies.
- Can clearly explain project status to their supervisor.
- Demonstrates a keen interest in the 'why' behind innovation projects.
- 2
Business Analyst (Data-focused)
2-3 yearsSkills to master
- Advanced Excel, data modelling, stakeholder interviewing for requirements, creating dashboards, basic financial analysis.
You're ready to move on when
- Can build complex Excel models with minimal supervision.
- Successfully created and maintained dashboards for business stakeholders.
- Effectively gathered and translated business requirements into data solutions.
- Comfortable presenting data insights to a small group.
- 3
Junior Data Analyst
2-3 yearsSkills to master
- SQL, Python (pandas/NumPy), data cleaning, statistical analysis, building data pipelines (basic).
You're ready to move on when
- Proficient in querying databases and manipulating data.
- Successfully cleaned and prepared messy datasets for analysis.
- Can articulate the limitations and assumptions of their data analysis.
- Shows an interest in applying analytical skills to business strategy.