Table 1Transition record

data warehouse designertoICT system architect

A data warehouse designer already meets 59% of what the ICT system architect role asks for. The move turns on 13 required skills not yet in the profile.

From data warehouse designer

59%

Overlap1

To ICT system architect

61 Skills carried over

13 Required, not held

55.5 Difficulty2

adjacent 0–30

moderate 30–55

substantial 55–75

career change 75–100

this move, 55.5

This move: 55.5 of 100 · substantial

1 Share of the ICT system architect 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.

Table 2

Table 2 · What you already bring

Of the 61 skills that carry over, these are the ones fewest other occupations ask for. A ICT system architect 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 manage standards for data exchange management skills
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
already held database development tools information and communication technologies (icts)
already held design database scheme communication, collaboration and creativity

All 61 carried skills, including the 10 the ICT system architect role treats as required.

Table 3

Table 3 · What you would need to learn

The 31 missing skills fall into 8 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 working with computers 5 required, 4 supplementary

required, not held acquire system component required
required, not held align software with system architectures required
required, not held implement ICT security policies required
required, not held integrate system components required
required, not held use an application-specific interface required

optional, not held develop with cloud services optional
optional, not held plan migration to cloud optional
optional, not held use object-oriented programming optional
optional, not held solve ICT system problems optional

02 information and communication technologies (icts) 4 required, 6 supplementary

required, not held hardware platforms required
required, not held system design required
required, not held digital systems required
required, not held systems development life-cycle required

optional, not held ICT process quality models optional
optional, not held ICT system integration optional
optional, not held ICT system programming optional
optional, not held Oracle WebLogic optional
optional, not held image recognition optional
optional, not held task algorithmisation optional

03 communication, collaboration and creativity 2 required, 3 supplementary

required, not held design enterprise architecture required
required, not held design information system required

optional, not held design cloud architecture optional
optional, not held design for organisational complexity optional
optional, not held design process optional

04 information skills 1 required, 1 supplementary

required, not held create data models required

optional, not held provide cost benefit analysis reports optional

05 constructing 1 required

required, not held manage system testing required

06 engineering, manufacturing and construction 2 supplementary

optional, not held model based system engineering optional
optional, not held security engineering optional

2 further areas in the appendix

Table 4

Table 4 · Where to start

The 3 entries a ICT system architect 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 61 skills that carry over

Skill Type

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 database development tools knowledge
already held define technical requirements skill
already held manage database skill
already held systems theory knowledge
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 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 ICT security legislation knowledge
already held Java (computer programming) knowledge
already held JavaScript knowledge
already held Lisp knowledge
already held MATLAB knowledge
already held ML (computer programming) knowledge
already held Microsoft Visual C++ 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 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 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 apply technical communication skills skill
already held build business relationships skill
already held computer programming knowledge
already held design database in the cloud skill
already held design database scheme skill
already held information structure knowledge
already held lean project management knowledge
already held manage cloud data and storage skill
already held manage standards for data exchange skill
already held perform resource planning skill

The 2 learning areas not shown above

Skill to acquire Tier

07 management skills 1 supplementary

optional, not held manage staff optional

08 services 1 supplementary

optional, not held defence standard procedures optional

18 supplementary skills, helpful but not required

Skill to acquire Tier

optional, not held ICT process quality models optional
optional, not held ICT system integration optional
optional, not held ICT system programming optional
optional, not held Oracle WebLogic optional
optional, not held defence standard procedures optional
optional, not held design cloud architecture optional
optional, not held design for organisational complexity optional
optional, not held develop with cloud services optional
optional, not held plan migration to cloud optional
optional, not held use object-oriented programming optional
optional, not held design process optional
optional, not held image recognition optional
optional, not held manage staff optional
optional, not held model based system engineering optional
optional, not held provide cost benefit analysis reports optional
optional, not held security engineering optional
optional, not held solve ICT system problems optional
optional, not held task algorithmisation optional

49 held skills the ICT system architect role does not ask for

Skill Type

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 LDAP knowledge
not needed by the target role LINQ 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 N1QL 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 SPARQL 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 create data sets 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 models knowledge
not needed by the target role data science knowledge
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 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 migrate existing data skill
not needed by the target role operate relational database management system skill
not needed by the target role perform data analysis skill
not needed by the target role product data management knowledge
not needed by the target role query languages knowledge

9 further entries not listed here

13 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 hardware platforms required
required, not held system design required
required, not held digital systems required
required, not held systems development life-cycle required
optional, not held ICT process quality models optional
optional, not held ICT system integration optional
optional, not held ICT system programming optional
optional, not held Oracle WebLogic optional
optional, not held defence standard procedures optional
optional, not held image recognition optional
optional, not held model based system engineering optional
optional, not held security engineering optional
optional, not held task algorithmisation 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.