Table 1Transition record

data engineertodata analyst

A data engineer already meets 21% of what the data analyst role asks for. The move turns on 28 required skills not yet in the profile.

From data engineer

21%

Overlap1

To data analyst

13 Skills carried over

28 Required, not held

84.7 Difficulty2

adjacent 0–30

moderate 30–55

substantial 55–75

career change 75–100

this move, 84.7

This move: 84.7 of 100 · career change

1 Share of the data analyst role’s weighted skill requirement already met by the data engineer profile. Required skills count in full, supplementary skills at 0.35. Directional: the figure for the reverse move differs. 2 Combines what is missing with how specialised it is, so a gap of general skills scores easier than the same number of narrow ones.

Table 2

Table 2 · What you already bring

Of the 13 skills that carry over, these are the ones fewest other occupations ask for. A data analyst role needs them, and most people applying for one will not have them already. This is the part of a data engineer background worth leading with.

Skill the target role also needs Area

already held store digital data and systems working with computers
already held establish data processes working with computers
already held create data models information skills
already held use data processing techniques working with computers
already held manage quantitative data working with computers
already held data models information and communication technologies (icts)

All 13 carried skills, including the 8 the data analyst role treats as required.

Table 3

Table 3 · What you would need to learn

The 54 missing skills fall into 11 areas of the ESCO skill hierarchy, numbered below in the order worth working in: the areas carrying the most required skills come first, and inside each one the required skills sit above the supplementary ones.

Skill to acquire Tier

01 information and communication technologies (icts) 9 required, 12 supplementary

required, not held data mining required
required, not held information confidentiality required
required, not held information extraction required
required, not held information structure required
required, not held query languages required
required, not held resource description framework query language required
required, not held data engineering required
required, not held data science required
required, not held data visualisation software required

optional, not held Hadoop optional
optional, not held LDAP optional
optional, not held LINQ optional
optional, not held MDX optional
optional, not held N1QL optional
optional, not held SPARQL optional
optional, not held XQuery optional
optional, not held information architecture optional
optional, not held online analytical processing optional
optional, not held database optional
optional, not held image recognition optional
optional, not held web analytics optional

02 information skills 6 required, 5 supplementary

required, not held analyse big data required
required, not held apply statistical analysis techniques required
required, not held collect ICT data required
required, not held execute analytical mathematical calculations required
required, not held handle data samples required
required, not held interpret current data required

optional, not held gather data for forensic purposes optional
optional, not held manage cloud data and storage optional
optional, not held manage data collection systems optional
optional, not held make data-driven decisions optional
optional, not held report analysis results optional

03 working with computers 5 required, 1 supplementary

required, not held integrate ICT data required
required, not held normalise data required
required, not held perform data mining required
required, not held implement data quality processes required
required, not held perform data cleansing required

optional, not held use spreadsheets software optional

04 business, administration and law 2 required, 1 supplementary

required, not held data quality assessment required
required, not held business intelligence required

optional, not held marketing analytics optional

05 social sciences, journalism and information 2 required, 1 supplementary

required, not held documentation types required
required, not held information categorisation required

optional, not held social network analysis optional

06 arts and humanities 2 required

required, not held visual presentation techniques required
required, not held data ethics required

5 further areas in the appendix

Table 4

Table 4 · Where to start

The 3 entries a data analyst role is least likely to hire without. The ordering is computed from the skill data, not from what pays.

Each entry opens a course search for that skill. Career Overlap earns nothing from these links.

Appendix

Appendix · The rest of the record

All 13 skills that carry over

Skill Type

already held data models knowledge
already held digital data processing skill
already held establish data processes skill
already held manage data skill
already held statistics knowledge
already held unstructured data knowledge
already held use data processing techniques skill
already held use databases skill
already held cloud technologies knowledge
already held create data models skill
already held data storage knowledge
already held manage quantitative data skill
already held store digital data and systems skill

The 5 learning areas not shown above

Skill to acquire Tier

07 natural sciences, mathematics and statistics 1 required, 2 supplementary

required, not held business analytics required

optional, not held statistical modeling techniques optional
optional, not held game theory optional

08 management skills 1 required

required, not held define data quality criteria required

09 generic programmes and qualifications 2 supplementary

optional, not held multidisciplinary research optional
optional, not held research design optional

10 communication, collaboration and creativity 1 supplementary

optional, not held deliver visual presentation of data optional

11 health and welfare 1 supplementary

optional, not held healthcare analytics optional

26 supplementary skills, helpful but not required

Skill to acquire Tier

optional, not held Hadoop optional
optional, not held LDAP optional
optional, not held LINQ optional
optional, not held MDX optional
optional, not held N1QL optional
optional, not held SPARQL optional
optional, not held XQuery optional
optional, not held gather data for forensic purposes optional
optional, not held healthcare analytics optional
optional, not held information architecture optional
optional, not held manage cloud data and storage optional
optional, not held manage data collection systems optional
optional, not held online analytical processing optional
optional, not held statistical modeling techniques optional
optional, not held database optional
optional, not held deliver visual presentation of data optional
optional, not held game theory optional
optional, not held image recognition optional
optional, not held make data-driven decisions optional
optional, not held marketing analytics optional
optional, not held multidisciplinary research optional
optional, not held report analysis results optional
optional, not held research design optional
optional, not held social network analysis optional
optional, not held use spreadsheets software optional
optional, not held web analytics optional

15 held skills the data analyst role does not ask for

Skill Type

not needed by the target role SAS Data Management knowledge
not needed by the target role Teradata Database knowledge
not needed by the target role analyse pipeline database information skill
not needed by the target role computer science knowledge
not needed by the target role create data sets skill
not needed by the target role data analytics knowledge
not needed by the target role data warehouse knowledge
not needed by the target role database management systems knowledge
not needed by the target role design database in the cloud skill
not needed by the target role develop data processing applications skill
not needed by the target role implement data warehousing techniques skill
not needed by the target role manage ICT data architecture skill
not needed by the target role manage research data skill
not needed by the target role perform dimensionality reduction skill
not needed by the target role process data skill

35 gaps that are knowledge rather than practice

Knowledge gaps usually close through study. Practical skill gaps usually need something you can point at.

Skill to acquire Tier

required, not held business analytics required
required, not held data mining required
required, not held data quality assessment required
required, not held documentation types required
required, not held information categorisation required
required, not held information confidentiality required
required, not held information extraction required
required, not held information structure required
required, not held query languages required
required, not held resource description framework query language required
required, not held visual presentation techniques required
required, not held business intelligence required
required, not held data engineering required
required, not held data ethics required
required, not held data science required
required, not held data visualisation software required
optional, not held Hadoop optional
optional, not held LDAP optional
optional, not held LINQ optional
optional, not held MDX optional
optional, not held N1QL optional
optional, not held SPARQL optional
optional, not held XQuery optional
optional, not held healthcare analytics optional
optional, not held information architecture optional
optional, not held online analytical processing optional
optional, not held statistical modeling techniques optional
optional, not held database optional
optional, not held game theory optional
optional, not held image recognition optional
optional, not held marketing analytics optional
optional, not held multidisciplinary research optional
optional, not held research design optional
optional, not held social network analysis optional
optional, not held web analytics optional

Index

Other moves recorded from data engineer

Full index of moves from data engineer

Note

How this record was compiled

Both occupations are taken from ESCO, which lists the skills and knowledge each occupation is expected to have and marks every one required or optional. Nothing here is a prediction about hiring, and nothing here knows that a particular employer wants a particular certificate. Treat Table 3 as a starting point for your own research rather than a syllabus. The full method states what these figures can and cannot tell you.