Career Overlap Transition record
RecordMove

Data analyst to database integrator

A data analyst already meets 30% of what the database integrator role asks for. The move turns on 11 required skills not yet in the profile.

Fig. 1 · Skill transfer ESCO v1.2.1 · directional
From data analyst
30 % overlap
Distant match
To database integrator
18 You already bring
11 Still to learn
67 Skills in the target role2
Learning distance A rebuild

76.8/ 100

1 How much of what a database integrator is expected to do is already part of a data analyst’s work. Directional: the figure for the reverse move differs, because moving into a speciality is not the same problem as moving out of one. 2 Every skill the database integrator role is recorded as needing, required and optional together. What these numbers mean.

Why

Why this move works

A database integrator role treats 6 of its required skills as things a data analyst already does. You would walk in with these on day one.

  • information structure
  • integrate ICT data
  • manage data
  • perform data cleansing
  • query languages
  • resource description framework query language

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

Skill the target role also needs Area
  • already held integrate ICT data working with computers
  • 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 manage cloud data and storage information skills

All 18 carried skills, including the 6 the database integrator role treats as required.

Table 3

Table 3 · What you may need to learn

The 49 missing skills fall into 5 areas of the ESCO skill hierarchy, numbered in the order worth working in. Areas carrying the most required skills come first, and inside each one the required skills sit above the optional ones. Nothing here is a verdict on you: it is a list of what this particular job asks for that your current one does not.

Skill to pick up Tier
01 working with computers 5 required, 3 supplementary
  • still to learn use interface description language required
  • still to learn balance database resources required
  • still to learn execute integration testing required
  • still to learn implement data warehousing techniques required
  • still to learn manage ICT legacy implication required
  • optional, not held apply ICT systems theory optional
  • optional, not held manage ICT semantic integration optional
  • optional, not held use scripting programming optional
02 information and communication technologies (icts) 4 required, 29 supplementary
  • still to learn ICT debugging tools required
  • still to learn database management systems required
  • still to learn domain name service required
  • still to learn data extraction, transformation and loading tools 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 InfoSphere DataStage optional
  • optional, not held IBM InfoSphere Information Server optional
  • optional, not held IBM Informix optional
  • optional, not held Informatica PowerCenter 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 Data Integrator optional
  • optional, not held Oracle Relational Database optional
  • optional, not held Oracle Warehouse Builder optional
  • optional, not held Pentaho Data Integration optional
  • optional, not held PostgreSQL optional
  • optional, not held QlikView Expressor optional
  • optional, not held SAP Data Services optional
  • optional, not held SAS Data Management optional
  • optional, not held SQL Server optional
  • optional, not held SQL Server Integration Services optional
  • optional, not held Teradata Database optional
  • optional, not held TripleStore optional
  • optional, not held inter-organisational middleware system optional
  • optional, not held system design optional
  • optional, not held systems theory optional
  • optional, not held digital systems optional
  • optional, not held systems development life-cycle optional
03 communication, collaboration and creativity 1 required, 4 supplementary
  • still to learn create database diagrams required
  • optional, not held define integration strategy optional
  • optional, not held design application interfaces optional
  • optional, not held write database documentation optional
  • optional, not held create solutions to problems optional
04 information skills 1 required, 1 supplementary
  • still to learn verify formal ICT specifications required
  • optional, not held execute ICT audits optional
05 management skills 1 supplementary
  • optional, not held perform project management optional
Table 4

Table 4 · Where to start

The 3 entries a database integrator 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 18 skills that carry over
Skill Type
  • already held information structure knowledge
  • already held integrate ICT data skill
  • 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 business intelligence knowledge
  • already held data engineering knowledge
  • already held database knowledge
  • already held define data quality criteria skill
  • already held manage cloud data and storage skill
  • already held perform data mining skill
38 supplementary skills, helpful but not required
Skill to pick up Tier
  • optional, not held CA Datacom/DB optional
  • optional, not held DB2 optional
  • optional, not held Filemaker (database management systems) optional
  • optional, not held IBM InfoSphere DataStage optional
  • optional, not held IBM InfoSphere Information Server optional
  • optional, not held IBM Informix optional
  • optional, not held Informatica PowerCenter 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 Data Integrator optional
  • optional, not held Oracle Relational Database optional
  • optional, not held Oracle Warehouse Builder optional
  • optional, not held Pentaho Data Integration optional
  • optional, not held PostgreSQL optional
  • optional, not held QlikView Expressor optional
  • optional, not held SAP Data Services optional
  • optional, not held SAS Data Management optional
  • optional, not held SQL Server optional
  • optional, not held SQL Server Integration Services optional
  • optional, not held Teradata Database optional
  • optional, not held TripleStore optional
  • optional, not held apply ICT systems theory optional
  • optional, not held define integration strategy optional
  • optional, not held design application interfaces optional
  • optional, not held execute ICT audits optional
  • optional, not held inter-organisational middleware system optional
  • optional, not held manage ICT semantic integration optional
  • optional, not held system design optional
  • optional, not held systems theory optional
  • optional, not held use scripting programming optional
  • optional, not held write database documentation optional
  • optional, not held create solutions to problems optional
  • optional, not held digital systems optional
  • optional, not held perform project management optional
  • optional, not held systems development life-cycle optional
49 held skills the database integrator role does not ask for
Skill Type
  • not needed by the target role Hadoop knowledge
  • not needed by the target role analyse big data skill
  • not needed by the target role apply statistical analysis techniques skill
  • not needed by the target role business analytics knowledge
  • not needed by the target role cloud technologies knowledge
  • not needed by the target role collect ICT data skill
  • not needed by the target role create data models skill
  • not needed by the target role data ethics knowledge
  • not needed by the target role data mining knowledge
  • not needed by the target role data models knowledge
  • not needed by the target role data quality assessment knowledge
  • not needed by the target role data science knowledge
  • not needed by the target role data storage knowledge
  • not needed by the target role data visualisation software knowledge
  • not needed by the target role deliver visual presentation of data skill
  • not needed by the target role digital data processing skill
  • not needed by the target role documentation types knowledge
  • not needed by the target role establish data processes skill
  • not needed by the target role execute analytical mathematical calculations skill
  • not needed by the target role game theory knowledge
  • not needed by the target role gather data for forensic purposes skill
  • not needed by the target role handle data samples skill
  • not needed by the target role healthcare analytics knowledge
  • not needed by the target role image recognition knowledge
  • not needed by the target role implement data quality processes 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 confidentiality knowledge
  • not needed by the target role information extraction knowledge
  • not needed by the target role interpret current data skill
  • not needed by the target role make data-driven decisions skill
  • not needed by the target role manage data collection systems skill
  • not needed by the target role manage quantitative data skill
  • not needed by the target role marketing analytics knowledge
  • not needed by the target role multidisciplinary research knowledge
  • not needed by the target role normalise data skill
  • not needed by the target role online analytical processing knowledge
  • not needed by the target role report analysis results skill
  • not needed by the target role research design knowledge
  • not needed by the target role social network analysis knowledge

9 further entries not listed here

33 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 pick up Tier
  • still to learn ICT debugging tools required
  • still to learn database management systems required
  • still to learn domain name service required
  • still to learn data extraction, transformation and loading tools 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 InfoSphere DataStage optional
  • optional, not held IBM InfoSphere Information Server optional
  • optional, not held IBM Informix optional
  • optional, not held Informatica PowerCenter 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 Data Integrator optional
  • optional, not held Oracle Relational Database optional
  • optional, not held Oracle Warehouse Builder optional
  • optional, not held Pentaho Data Integration optional
  • optional, not held PostgreSQL optional
  • optional, not held QlikView Expressor optional
  • optional, not held SAP Data Services optional
  • optional, not held SAS Data Management optional
  • optional, not held SQL Server optional
  • optional, not held SQL Server Integration Services optional
  • optional, not held Teradata Database optional
  • optional, not held TripleStore optional
  • optional, not held inter-organisational middleware system optional
  • optional, not held system design optional
  • optional, not held systems theory optional
  • optional, not held digital systems optional
  • optional, not held systems development life-cycle optional
Index

Other moves recorded from data analyst

Full index of moves from data analyst

FAQ

Common questions about this move

Can a data analyst become a database integrator?

Yes, and it is a career change move. A data analyst already covers 30% of what a database integrator is expected to do: 18 skills carry over, 6 of which the database integrator role treats as required.

What skills does a data analyst need to become a database integrator?

11 required skills are missing, plus 38 optional ones. They fall into 5 areas of the ESCO skill hierarchy, led by working with computers. The single most important is use interface description language.

How hard is the move from data analyst to database integrator?

Its learning distance is 76.8 out of 100, which is the career change band. That accounts for both how much is missing and how specialised those skills are.

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.