Table 1Transition record

data warehouse designertoartificial intelligence engineer

A data warehouse designer already meets 53% of what the artificial intelligence engineer role asks for. The move turns on 19 required skills not yet in the profile.

From data warehouse designer

53%

Overlap1

To artificial intelligence engineer

55 Skills carried over

19 Required, not held

60.8 Difficulty2

Career overlap Partial match

53%

Learning distance Substantial retraining

60.8/ 100

Easy adjacentmoderatesubstantialcareer change Hard

1 Share of the artificial intelligence engineer role’s weighted skill requirement already met by the data warehouse designer 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 artificial intelligence engineer role treats 12 of its required skills as things a data warehouse designer already does. These are the ones it depends on most.

Python (computer programming)
analyse business requirements
apply ICT systems theory
business process modelling
computer programming
create data sets

What stands in the way is 19 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 55 skills that carry over, these are the ones fewest other occupations ask for. A artificial intelligence engineer role needs them, and most people applying for one will not have them already. This is the part of a data warehouse designer background worth leading with.

Skill the target role also needs Area

already held create data sets information skills
already held apply ICT systems theory working with computers
already held assess ICT knowledge management skills
already held database development tools information and communication technologies (icts)
already held design database scheme communication, collaboration and creativity
already held data science information and communication technologies (icts)

All 55 carried skills, including the 12 the artificial intelligence engineer role treats as required.

Table 3

Table 3 · What you would need to learn

The 34 missing skills fall into 9 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, 2 supplementary

required, not held data mining required
required, not held information architecture required
required, not held information extraction required
required, not held principles of artificial intelligence required
required, not held algorithms required
required, not held artificial neural networks required
required, not held computer simulation required
required, not held systems development life-cycle required
required, not held task algorithmisation required

optional, not held computer vision optional
optional, not held deep learning optional

02 working with computers 4 required, 5 supplementary

required, not held digital data processing required
required, not held creatively use digital technologies required
required, not held develop statistical software required
required, not held use data processing techniques required

optional, not held build recommender systems optional
optional, not held manage ICT data classification optional
optional, not held manage ICT semantic integration optional
optional, not held utilise machine learning optional
optional, not held perform dimensionality reduction optional

03 communication, collaboration and creativity 3 required, 2 supplementary

required, not held deliver visual presentation of data required
required, not held design process required
required, not held develop creative ideas required

optional, not held design application interfaces optional
optional, not held apply systemic design thinking optional

04 information skills 1 required, 1 supplementary

required, not held analyse big data required

optional, not held build predictive models optional

05 arts and humanities 1 required

required, not held visual presentation techniques required

06 social sciences, journalism and information 1 required

required, not held information categorisation required

3 further areas in the appendix

Table 4

Table 4 · Where to start

The 3 entries a artificial intelligence engineer 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 55 skills that carry over

Skill Type

already held Python (computer programming) knowledge
already held analyse business requirements skill
already held apply ICT systems theory skill
already held business process modelling knowledge
already held computer programming knowledge
already held create data sets skill
already held data models knowledge
already held data science knowledge
already held define technical requirements skill
already held information structure knowledge
already held resource description framework query language knowledge
already held unstructured data knowledge
already held Agile project management 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 ICT project management methodologies 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 Process-based management knowledge
already held Prolog (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 assess ICT knowledge skill
already held build business relationships skill
already held database development tools knowledge
already held design database scheme skill
already held lean project management knowledge

The 3 learning areas not shown above

Skill to acquire Tier

07 business, administration and law 2 supplementary

optional, not held business intelligence optional
optional, not held operational research optional

08 management skills 2 supplementary

optional, not held identify processes for re-engineering optional
optional, not held manage business knowledge optional

09 natural sciences, mathematics and statistics 1 supplementary

optional, not held business analytics optional

15 supplementary skills, helpful but not required

Skill to acquire Tier

optional, not held build recommender systems optional
optional, not held build predictive models optional
optional, not held business analytics optional
optional, not held design application interfaces optional
optional, not held manage ICT data classification optional
optional, not held manage ICT semantic integration optional
optional, not held utilise machine learning optional
optional, not held apply systemic design thinking optional
optional, not held business intelligence optional
optional, not held computer vision optional
optional, not held deep learning optional
optional, not held identify processes for re-engineering optional
optional, not held manage business knowledge optional
optional, not held operational research optional
optional, not held perform dimensionality reduction optional

55 held skills the artificial intelligence engineer role does not ask for

Skill Type

not needed by the target role ABAP knowledge
not needed by the target role AJAX knowledge
not needed by the target role APL knowledge
not needed by the target role ASP.NET knowledge
not needed by the target role CA Datacom/DB knowledge
not needed by the target role DB2 knowledge
not needed by the target role Filemaker (database management systems) knowledge
not needed by the target role IBM Informix knowledge
not needed by the target role ICT security legislation knowledge
not needed by the target role LDAP knowledge
not needed by the target role MDX knowledge
not needed by the target role MarkLogic knowledge
not needed by the target role Microsoft Access knowledge
not needed by the target role MySQL knowledge
not needed by the target role ObjectStore knowledge
not needed by the target role OpenEdge Database knowledge
not needed by the target role Oracle Relational Database knowledge
not needed by the target role PostgreSQL knowledge
not needed by the target role SQL Server knowledge
not needed by the target role Teradata Database knowledge
not needed by the target role TripleStore knowledge
not needed by the target role XQuery knowledge
not needed by the target role apply technical communication skills skill
not needed by the target role create database diagrams skill
not needed by the target role create software design skill
not needed by the target role data visualisation software knowledge
not needed by the target role data warehouse knowledge
not needed by the target role database knowledge
not needed by the target role database management systems knowledge
not needed by the target role define database physical structure skill
not needed by the target role design database backup specifications skill
not needed by the target role design database in the cloud skill
not needed by the target role design user interface skill
not needed by the target role develop automated migration methods skill
not needed by the target role develop reporting software skill
not needed by the target role identify software for warehouse management skill
not needed by the target role manage cloud data and storage skill
not needed by the target role manage database skill
not needed by the target role manage standards for data exchange skill
not needed by the target role migrate existing data skill

15 further entries not listed here

16 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 mining required
required, not held information architecture required
required, not held information categorisation required
required, not held information extraction required
required, not held principles of artificial intelligence required
required, not held visual presentation techniques required
required, not held algorithms required
required, not held artificial neural networks required
required, not held computer simulation required
required, not held systems development life-cycle required
required, not held task algorithmisation required
optional, not held business analytics optional
optional, not held business intelligence optional
optional, not held computer vision optional
optional, not held deep learning optional
optional, not held operational research optional

Index

Other moves recorded from data warehouse designer

Full index of moves from data warehouse designer

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.