Career Overlap Transition record Edition 1 · ESCO v1.2.1
Table 1Transition record

knowledge engineertodata warehouse designer

A knowledge engineer already meets 58% of what the data warehouse designer role asks for. The move turns on 12 required skills not yet in the profile.

From knowledge engineer
58%
Overlap1
To data warehouse designer
65 Skills carried over
12 Required, not held
58.8 Difficulty2
Career overlap Partial match

58%

Learning distance Substantial retraining

58.8/ 100

1 Share of the data warehouse designer role’s weighted skill requirement already met by the knowledge 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.

Why

Why this move works

A data warehouse designer role treats 16 of its required skills as things a knowledge engineer already does. These are the ones it depends on most.

  • ICT security legislation
  • analyse business requirements
  • apply ICT systems theory
  • assess ICT knowledge
  • business process modelling
  • create database diagrams

What stands in the way is 12 required skills the profile does not yet cover. Table 3 groups them; Table 4 says which to take first.

Table 2

Table 2 · What you already bring

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

Skill the target role also needs Area
  • already held define database physical structure working with computers
  • already held create database diagrams communication, collaboration and creativity
  • already held store digital data and systems working with computers
  • already held systems theory information and communication technologies (icts)
  • already held apply ICT systems theory working with computers
  • already held assess ICT knowledge management skills

All 65 carried skills, including the 16 the data warehouse designer role treats as required.

Table 3

Table 3 · What you would need to learn

The 45 missing skills fall into 6 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) 4 required, 19 supplementary
  • required, not held data warehouse required
  • required, not held database management systems required
  • required, not held query languages required
  • required, not held database required
  • optional, not held CA Datacom/DB optional
  • optional, not held DB2 optional
  • optional, not held Filemaker (database management systems) optional
  • optional, not held IBM Informix optional
  • optional, not held LDAP optional
  • optional, not held MDX optional
  • optional, not held MarkLogic optional
  • optional, not held Microsoft Access optional
  • optional, not held MySQL optional
  • optional, not held ObjectStore optional
  • optional, not held OpenEdge Database optional
  • optional, not held Oracle Relational Database optional
  • optional, not held PostgreSQL optional
  • optional, not held SQL Server optional
  • optional, not held Teradata Database optional
  • optional, not held TripleStore optional
  • optional, not held XQuery optional
  • optional, not held data models optional
  • optional, not held data visualisation software optional
02 working with computers 3 required, 3 supplementary
  • required, not held migrate existing data required
  • required, not held operate relational database management system required
  • required, not held identify software for warehouse management required
  • optional, not held develop reporting software optional
  • optional, not held use access control software optional
  • optional, not held perform data analysis optional
03 communication, collaboration and creativity 2 required, 5 supplementary
  • required, not held create software design required
  • required, not held write database documentation required
  • optional, not held design database backup specifications optional
  • optional, not held design database in the cloud optional
  • optional, not held design user interface optional
  • optional, not held apply technical communication skills optional
  • optional, not held respond to customers' inquiries optional
04 management skills 2 required
  • required, not held develop automated migration methods required
  • required, not held manage standards for data exchange required
05 information skills 1 required, 1 supplementary
  • required, not held create data sets required
  • optional, not held perform resource planning optional
06 business, administration and law 5 supplementary
  • optional, not held Agile project management optional
  • optional, not held ICT project management methodologies optional
  • optional, not held Process-based management optional
  • optional, not held lean project management optional
  • optional, not held product data management optional
Table 4

Table 4 · Where to start

The 3 entries a data warehouse designer 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 65 skills that carry over
Skill Type
  • already held ICT security legislation knowledge
  • already held analyse business requirements skill
  • already held apply ICT systems theory skill
  • already held assess ICT knowledge skill
  • already held business process modelling knowledge
  • already held create database diagrams skill
  • already held database development tools knowledge
  • already held define technical requirements skill
  • already held design database scheme skill
  • already held information structure knowledge
  • already held manage database skill
  • already held resource description framework query language knowledge
  • already held systems theory knowledge
  • already held use databases skill
  • already held use markup languages skill
  • already held web programming knowledge
  • already held ABAP knowledge
  • already held AJAX knowledge
  • already held APL knowledge
  • already held ASP.NET knowledge
  • already held Assembly (computer programming) knowledge
  • already held C# knowledge
  • already held C++ knowledge
  • already held COBOL knowledge
  • already held CoffeeScript knowledge
  • already held Common Lisp knowledge
  • already held Erlang knowledge
  • already held Groovy knowledge
  • already held Haskell knowledge
  • already held Java (computer programming) knowledge
  • already held JavaScript knowledge
  • already held LINQ knowledge
  • already held Lisp knowledge
  • already held MATLAB knowledge
  • already held ML (computer programming) knowledge
  • already held Microsoft Visual C++ knowledge
  • already held N1QL knowledge
  • already held Objective-C knowledge
  • already held OpenEdge Advanced Business Language knowledge
  • already held PHP knowledge
  • already held Pascal (computer programming) knowledge
  • already held Perl knowledge
  • already held Prolog (computer programming) knowledge
  • already held Python (computer programming) knowledge
  • already held R knowledge
  • already held Ruby (computer programming) knowledge
  • already held SAP R3 knowledge
  • already held SAS language knowledge
  • already held SPARQL knowledge
  • already held Scala knowledge
  • already held Scratch (computer programming) knowledge
  • already held Smalltalk (computer programming) knowledge
  • already held Swift (computer programming) knowledge
  • already held TypeScript knowledge
  • already held VBScript knowledge
  • already held Visual Basic knowledge
  • already held build business relationships skill
  • already held computer programming knowledge
  • already held data science knowledge
  • already held define database physical structure skill
  • already held manage cloud data and storage skill
  • already held store digital data and systems skill
  • already held unstructured data knowledge
  • already held use back-up and recovery tools skill
  • already held use query languages skill
33 supplementary skills, helpful but not required
Skill to acquire Tier
  • optional, not held develop reporting software optional
  • optional, not held Agile project management optional
  • optional, not held CA Datacom/DB optional
  • optional, not held DB2 optional
  • optional, not held Filemaker (database management systems) optional
  • optional, not held IBM Informix optional
  • optional, not held ICT project management methodologies optional
  • optional, not held LDAP optional
  • optional, not held MDX optional
  • optional, not held MarkLogic optional
  • optional, not held Microsoft Access optional
  • optional, not held MySQL optional
  • optional, not held ObjectStore optional
  • optional, not held OpenEdge Database optional
  • optional, not held Oracle Relational Database optional
  • optional, not held PostgreSQL optional
  • optional, not held Process-based management optional
  • optional, not held SQL Server optional
  • optional, not held Teradata Database optional
  • optional, not held TripleStore optional
  • optional, not held XQuery optional
  • optional, not held data models optional
  • optional, not held design database backup specifications optional
  • optional, not held design database in the cloud optional
  • optional, not held design user interface optional
  • optional, not held lean project management optional
  • optional, not held use access control software optional
  • optional, not held apply technical communication skills optional
  • optional, not held data visualisation software optional
  • optional, not held perform data analysis optional
  • optional, not held perform resource planning optional
  • optional, not held product data management optional
  • optional, not held respond to customers' inquiries optional
24 held skills the data warehouse designer role does not ask for
Skill Type
  • not needed by the target role ICT project management knowledge
  • not needed by the target role business intelligence knowledge
  • not needed by the target role cloud technologies knowledge
  • not needed by the target role cognitive psychology knowledge
  • not needed by the target role create semantic trees skill
  • not needed by the target role data engineering knowledge
  • not needed by the target role data mining knowledge
  • not needed by the target role decision support systems knowledge
  • not needed by the target role design application interfaces skill
  • not needed by the target role implement a virtual private network skill
  • not needed by the target role information architecture knowledge
  • not needed by the target role information categorisation knowledge
  • not needed by the target role information extraction knowledge
  • not needed by the target role manage ICT semantic integration skill
  • not needed by the target role manage business knowledge skill
  • not needed by the target role manage digital documents skill
  • not needed by the target role natural language processing knowledge
  • not needed by the target role principles of artificial intelligence knowledge
  • not needed by the target role systems development life-cycle knowledge
  • not needed by the target role task algorithmisation knowledge
  • not needed by the target role use an application-specific interface skill
  • not needed by the target role use spreadsheets software skill
  • not needed by the target role utilise decision support system skill
  • not needed by the target role visual presentation techniques knowledge
28 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 data warehouse required
  • required, not held database management systems required
  • required, not held query languages required
  • required, not held database required
  • optional, not held Agile project management optional
  • optional, not held CA Datacom/DB optional
  • optional, not held DB2 optional
  • optional, not held Filemaker (database management systems) optional
  • optional, not held IBM Informix optional
  • optional, not held ICT project management methodologies optional
  • optional, not held LDAP optional
  • optional, not held MDX optional
  • optional, not held MarkLogic optional
  • optional, not held Microsoft Access optional
  • optional, not held MySQL optional
  • optional, not held ObjectStore optional
  • optional, not held OpenEdge Database optional
  • optional, not held Oracle Relational Database optional
  • optional, not held PostgreSQL optional
  • optional, not held Process-based management optional
  • optional, not held SQL Server optional
  • optional, not held Teradata Database optional
  • optional, not held TripleStore optional
  • optional, not held XQuery optional
  • optional, not held data models optional
  • optional, not held lean project management optional
  • optional, not held data visualisation software optional
  • optional, not held product data management optional
Index

Other moves recorded from knowledge engineer

Full index of moves from knowledge 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.