Table 1Transition record

data warehouse designertocomputer-aided design operator

A data warehouse designer already meets 63% of what the computer-aided design operator role asks for. The move turns on 11 required skills not yet in the profile.

From data warehouse designer

63%

Overlap1

To computer-aided design operator

39 Skills carried over

11 Required, not held

53.3 Difficulty2

adjacent 0–30

moderate 30–55

substantial 55–75

career change 75–100

this move, 53.3

This move: 53.3 of 100 · moderate

1 Share of the computer-aided design operator 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 39 skills that carry over, these are the ones fewest other occupations ask for. A computer-aided design operator 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 CoffeeScript information and communication technologies (icts)
already held Erlang information and communication technologies (icts)
already held Smalltalk (computer programming) information and communication technologies (icts)
already held Microsoft Visual C++ information and communication technologies (icts)
already held ABAP information and communication technologies (icts)
already held APL information and communication technologies (icts)

All 39 carried skills, including the 38 the computer-aided design operator role treats as required.

Table 3

Table 3 · What you would need to learn

The 44 missing skills fall into 10 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 4 required, 4 supplementary

required, not held use automatic programming required
required, not held create CAD drawings required
required, not held use CAD software required
required, not held use CAM software required

optional, not held use CAE software optional
optional, not held use microsoft office optional
optional, not held use specialised design software optional
optional, not held use spreadsheets software optional

02 communication, collaboration and creativity 2 required, 13 supplementary

required, not held develop design concept required
required, not held design process required

optional, not held attend design meetings optional
optional, not held create architectural sketches optional
optional, not held develop jewellery designs optional
optional, not held develop product design optional
optional, not held adjust engineering designs optional
optional, not held collaborate with engineers optional
optional, not held create solutions to problems optional
optional, not held customise drafts optional
optional, not held design automation components optional
optional, not held design circuits using CAD optional
optional, not held design engineering components optional
optional, not held develop design plans optional
optional, not held use communication techniques optional

03 arts and humanities 2 required, 4 supplementary

required, not held design principles required
required, not held graphic design required

optional, not held imitation jewellery optional
optional, not held jewellery processes optional
optional, not held manufacturing of jewellery optional
optional, not held industrial design optional

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

required, not held trigonometry required
required, not held geometry required

optional, not held mathematics optional

05 information and communication technologies (icts) 1 required, 2 supplementary

required, not held CAD software required

optional, not held CAE software optional
optional, not held industrial software optional

06 engineering, manufacturing and construction 5 supplementary

optional, not held metalworking optional
optional, not held automation technology optional
optional, not held design drawings optional
optional, not held material mechanics optional
optional, not held woodworking processes optional

4 further areas in the appendix

Table 4

Table 4 · Where to start

The 3 entries a computer-aided design operator 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 39 skills that carry over

Skill Type

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 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 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 computer programming knowledge
already held apply technical communication skills skill

The 4 learning areas not shown above

Skill to acquire Tier

07 handling and moving 1 supplementary

optional, not held attend to detail regarding jewellery creation optional

08 information skills 1 supplementary

optional, not held adapt to new design materials optional

09 management skills 1 supplementary

optional, not held apply organisational techniques optional

10 social sciences, journalism and information 1 supplementary

optional, not held documentation types optional

33 supplementary skills, helpful but not required

Skill to acquire Tier

optional, not held adapt to new design materials optional
optional, not held attend design meetings optional
optional, not held attend to detail regarding jewellery creation optional
optional, not held create architectural sketches optional
optional, not held develop jewellery designs optional
optional, not held develop product design optional
optional, not held documentation types optional
optional, not held imitation jewellery optional
optional, not held jewellery processes optional
optional, not held manufacturing of jewellery optional
optional, not held metalworking optional
optional, not held use CAE software optional
optional, not held CAE software optional
optional, not held adjust engineering designs optional
optional, not held apply organisational techniques optional
optional, not held automation technology optional
optional, not held collaborate with engineers optional
optional, not held create solutions to problems optional
optional, not held customise drafts optional
optional, not held design automation components optional
optional, not held design circuits using CAD optional
optional, not held design drawings optional
optional, not held design engineering components optional
optional, not held develop design plans optional
optional, not held industrial design optional
optional, not held industrial software optional
optional, not held material mechanics optional
optional, not held mathematics optional
optional, not held use communication techniques optional
optional, not held use microsoft office optional
optional, not held use specialised design software optional
optional, not held use spreadsheets software optional
optional, not held woodworking processes optional

71 held skills the computer-aided design operator role does not ask for

Skill Type

not needed by the target role Agile project management 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 project management methodologies 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 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 Process-based management 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 analyse business requirements skill
not needed by the target role apply ICT systems theory skill
not needed by the target role assess ICT knowledge skill
not needed by the target role build business relationships skill
not needed by the target role business process modelling 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 development tools knowledge
not needed by the target role database management systems knowledge
not needed by the target role define database physical structure skill

31 further entries not listed here

18 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 trigonometry required
required, not held CAD software required
required, not held design principles required
required, not held geometry required
required, not held graphic design required
optional, not held documentation types optional
optional, not held imitation jewellery optional
optional, not held jewellery processes optional
optional, not held manufacturing of jewellery optional
optional, not held metalworking optional
optional, not held CAE software optional
optional, not held automation technology optional
optional, not held design drawings optional
optional, not held industrial design optional
optional, not held industrial software optional
optional, not held material mechanics optional
optional, not held mathematics optional
optional, not held woodworking processes 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.