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

database integratortodata quality specialist

A database integrator already meets 38% of what the data quality specialist role asks for. The move turns on 13 required skills not yet in the profile.

From database integrator
38%
Overlap1
To data quality specialist
16 Skills carried over
13 Required, not held
65.1 Difficulty2
Career overlap Distant match

38%

Learning distance Substantial retraining

65.1/ 100

1 Share of the data quality specialist role’s weighted skill requirement already met by the database integrator 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 quality specialist role treats 7 of its required skills as things a database integrator already does. These are the ones it depends on most.

  • database
  • define data quality criteria
  • information structure
  • manage data
  • perform data cleansing
  • query languages

What stands in the way is 13 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 16 skills that carry over, these are the ones fewest other occupations ask for. A data quality specialist role needs them, and most people applying for one will not have them already. This is the part of a database integrator background worth leading with.

Skill the target role also needs Area
  • already held perform data cleansing working with computers
  • already held data engineering information and communication technologies (icts)
  • already held define data quality criteria management skills
  • already held database information and communication technologies (icts)
  • already held execute ICT audits information skills
  • already held LDAP information and communication technologies (icts)

All 16 carried skills, including the 7 the data quality specialist role treats as required.

Table 3

Table 3 · What you would need to learn

The 24 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, 1 supplementary
  • required, not held utilise regular expressions required
  • required, not held establish data processes required
  • required, not held normalise data required
  • required, not held implement data quality processes required
  • required, not held use data processing techniques required
  • optional, not held perform data analysis optional
02 information skills 4 required, 1 supplementary
  • required, not held handle data samples required
  • required, not held manage database required
  • required, not held process data required
  • required, not held report analysis results required
  • optional, not held execute analytical mathematical calculations optional
03 communication, collaboration and creativity 2 required, 3 supplementary
  • required, not held design database scheme required
  • required, not held address problems critically required
  • optional, not held design database in the cloud optional
  • optional, not held build business relationships optional
  • optional, not held train employees optional
04 arts and humanities 1 required, 1 supplementary
  • required, not held data ethics required
  • optional, not held visual presentation techniques optional
05 management skills 1 required, 1 supplementary
  • required, not held manage standards for data exchange required
  • optional, not held manage schedule of tasks optional
06 business, administration and law 2 supplementary
  • optional, not held data quality assessment optional
  • optional, not held business processes optional

2 further areas in the appendix

Table 4

Table 4 · Where to start

The 3 entries a data quality specialist 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 16 skills that carry over
Skill Type
  • already held database knowledge
  • already held define data quality criteria skill
  • already held information structure knowledge
  • already held manage data skill
  • already held perform data cleansing skill
  • already held query languages knowledge
  • already held resource description framework query language knowledge
  • already held LDAP knowledge
  • already held LINQ knowledge
  • already held MDX knowledge
  • already held N1QL knowledge
  • already held SPARQL knowledge
  • already held XQuery knowledge
  • already held data engineering knowledge
  • already held execute ICT audits skill
  • already held perform project management skill
The 2 learning areas not shown above
Skill to acquire Tier
07 health and welfare 1 supplementary
  • optional, not held healthcare analytics optional
08 natural sciences, mathematics and statistics 1 supplementary
  • optional, not held statistics optional
11 supplementary skills, helpful but not required
Skill to acquire Tier
  • optional, not held data quality assessment optional
  • optional, not held design database in the cloud optional
  • optional, not held healthcare analytics optional
  • optional, not held visual presentation techniques optional
  • optional, not held build business relationships optional
  • optional, not held business processes optional
  • optional, not held execute analytical mathematical calculations optional
  • optional, not held manage schedule of tasks optional
  • optional, not held perform data analysis optional
  • optional, not held statistics optional
  • optional, not held train employees optional
51 held skills the data quality specialist 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 InfoSphere DataStage knowledge
  • not needed by the target role IBM InfoSphere Information Server knowledge
  • not needed by the target role IBM Informix knowledge
  • not needed by the target role ICT debugging tools knowledge
  • not needed by the target role Informatica PowerCenter 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 Data Integrator knowledge
  • not needed by the target role Oracle Relational Database knowledge
  • not needed by the target role Oracle Warehouse Builder knowledge
  • not needed by the target role Pentaho Data Integration knowledge
  • not needed by the target role PostgreSQL knowledge
  • not needed by the target role QlikView Expressor knowledge
  • not needed by the target role SAP Data Services knowledge
  • not needed by the target role SAS Data Management knowledge
  • not needed by the target role SQL Server knowledge
  • not needed by the target role SQL Server Integration Services knowledge
  • not needed by the target role Teradata Database knowledge
  • not needed by the target role TripleStore knowledge
  • not needed by the target role apply ICT systems theory skill
  • not needed by the target role balance database resources skill
  • not needed by the target role business intelligence knowledge
  • not needed by the target role create database diagrams skill
  • not needed by the target role create solutions to problems skill
  • not needed by the target role data extraction, transformation and loading tools knowledge
  • not needed by the target role database management systems knowledge
  • not needed by the target role define integration strategy skill
  • not needed by the target role design application interfaces skill
  • not needed by the target role digital systems knowledge
  • not needed by the target role domain name service knowledge
  • not needed by the target role execute integration testing skill
  • not needed by the target role implement data warehousing techniques skill
  • not needed by the target role integrate ICT data skill
  • not needed by the target role inter-organisational middleware system knowledge

11 further entries not listed here

6 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 ethics required
  • optional, not held data quality assessment optional
  • optional, not held healthcare analytics optional
  • optional, not held visual presentation techniques optional
  • optional, not held business processes optional
  • optional, not held statistics optional
Index

Other moves recorded from database integrator

Full index of moves from database integrator

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.