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
Mid-Level Business Intelligence Developer
2-3 yearsSkills to master
- Independently owning moderately complex dashboards, optimising SQL queries, understanding dimensional modelling basics, and consistently delivering accurate reports.
You're ready to move on when
- Consistently delivers assigned projects on time and to a high quality.
- Proactively identifies and resolves minor data quality issues.
- Can explain complex technical concepts to non-technical stakeholders clearly.
- Shows initiative in learning new tools and techniques without constant prompting.
- 2
Data Analyst transitioning to Development
3-4 yearsSkills to master
- Deepening SQL skills for data transformation, learning data warehousing concepts, picking up dbt for ELT, and mastering a BI tool for complex data model design, not just reporting.
You're ready to move on when
- Has built complex analyses and reports using advanced SQL.
- Demonstrates a strong interest in the 'how' behind data, not just the 'what'.
- Has self-taught or taken courses in data engineering/BI development tools.
- Can articulate the challenges of data quality and performance in current reporting.
- 3
Software Engineer moving into Data
2-3 yearsSkills to master
- Understanding business domain specifics, learning dimensional modelling, mastering SQL for analytical purposes, and becoming proficient in BI visualisation tools. Leveraging their software engineering rigour for data quality and testing.
You're ready to move on when
- Strong programming fundamentals (e.g., Python) and software engineering best practices.
- Has worked with databases and understands data structures.
- Shows a keen interest in business data and how it drives decisions.
- Can apply engineering principles (testing, version control) to data pipelines.