The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for Data Transformation skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Data Transformation over the 3 months to 25 June 2017 with a comparison to the same period in the previous 2 years.

Data Transformation
London / City of London
3 months to
25 Jun 2017
Same period 2016 Same period 2015
Rank 212 251 274
Rank change year-on-year +39 +23  
Permanent jobs citing Data Transformation 19 10 32
As % of all permanent IT jobs advertised in the City of London 0.37% 0.16% 0.31%
As % of the Processes & Methodologies category 0.41% 0.18% 0.35%
Number of salaries quoted 18 5 22
Median salary £65,000 £50,000 £52,500
Median salary % change year-on-year +30.00% -4.76%  
90% offered a salary of more than £60,000 £50,000 £45,000
10% offered a salary of more than £86,000 £64,700 £79,500
UK excluding London median salary £47,500 £42,500 £42,500
% change year-on-year +11.76% -  

Data Transformation is in the process and methodology skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in the City of London with a requirement for process and methodology skills.

Process & Methodology Skills
City of London
Permanent job vacancies with a requirement for process and methodology skills 4596 5702 9233
As % of all permanent IT job vacancies advertised in the City of London 89.29% 90.61% 89.22%
Number of salaries quoted 4057 5205 7905
Median salary £62,500 £60,000 £57,500
Median salary % change year-on-year +4.16% +4.34%  
90% offered a salary of more than £40,000 £40,000 £39,000
10% offered a salary of more than £85,000 £81,000 £85,000
UK excluding London median salary £45,000 £45,000 £44,000
% change year-on-year - +2.27%  

Data Transformation
Job Vacancy Trend in the City of London

The job posting trend of jobs advertised in the City of London citing Data Transformation as a proportion of all permanent or contract IT jobs with a match in the Processes & Methodologies category.

Job vacancy trend for Data Transformation in the City of London

Data Transformation
Salary Trend in the City of London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Data Transformation in the City of London.

Salary trend for Data Transformation in the City of London

Data Transformation
Salary Histogram in the City of London

The salary distribution of IT jobs citing Data Transformation in the City of London over the 3 months to 25 June 2017.

Salary histogram for Data Transformation in the City of London

For the 6 months to 25 June 2017, IT jobs citing Data Transformation also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the City of London region with a requirement for Data Transformation.

1 24 (68.57%) SQL
1 24 (68.57%) Finance
2 16 (45.71%) Relational Database
3 15 (42.86%) Workflow
4 13 (37.14%) Microsoft
5 12 (34.29%) T-SQL
5 12 (34.29%) SQL Server
6 9 (25.71%) Data Security
6 9 (25.71%) Java
7 7 (20.00%) XML
7 7 (20.00%) Oracle
7 7 (20.00%) SQL Server Integration Services
7 7 (20.00%) Unit Testing
7 7 (20.00%) Data Quality
7 7 (20.00%) Data Governance
7 7 (20.00%) Big Data
7 7 (20.00%) Analytical Skills
8 6 (17.14%) ISO 20022
8 6 (17.14%) Hadoop
8 6 (17.14%) Visualisation
8 6 (17.14%) JIRA
8 6 (17.14%) FIX Protocol
8 6 (17.14%) Maven
8 6 (17.14%) Data Analysis
8 6 (17.14%) Data Modelling
8 6 (17.14%) Code Coverage
8 6 (17.14%) XSD
8 6 (17.14%) .NET
8 6 (17.14%) PL/SQL
8 6 (17.14%) Sybase

Data Transformation
Co-occurring IT Skills in the City of London by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 4 (11.43%) Apache
2 2 (5.71%) IIS
3 1 (2.86%) Apache Spark
3 1 (2.86%) Confluence
3 1 (2.86%) Elasticsearch
3 1 (2.86%) Oracle Workflow
Applications
1 1 (2.86%) Microsoft Office
Cloud Services
1 2 (5.71%) Microsoft Azure
Database & Business Intelligence
1 16 (45.71%) Relational Database
2 12 (34.29%) SQL Server
3 7 (20.00%) Big Data
3 7 (20.00%) SQL Server Integration Services
4 6 (17.14%) Hadoop
5 4 (11.43%) Spotfire
6 2 (5.71%) Data Mart
6 2 (5.71%) Data Warehouse
6 2 (5.71%) SQL Server Reporting Services
7 1 (2.86%) Apache Hive
7 1 (2.86%) BusinessObjects
7 1 (2.86%) HBase
Development Applications
1 6 (17.14%) JIRA
1 6 (17.14%) Maven
2 5 (14.29%) Jenkins
3 4 (11.43%) Talend Open Studio
4 3 (8.57%) Subversion
5 2 (5.71%) Visual Studio
6 1 (2.86%) Appium
6 1 (2.86%) Cucumber
6 1 (2.86%) Git (software)
6 1 (2.86%) JIRA Agile
6 1 (2.86%) LoadRunner
General
1 24 (68.57%) Finance
2 6 (17.14%) Banking
3 5 (14.29%) Back Office
3 5 (14.29%) Investment Banking
4 1 (2.86%) Front Office
4 1 (2.86%) Publishing
Job Titles
1 14 (40.00%) Analyst
2 10 (28.57%) Applications Specialist
2 10 (28.57%) Applications Support
2 10 (28.57%) Applications Support Specialist
2 10 (28.57%) Support Specialist
3 4 (11.43%) Business Intelligence Analyst
3 4 (11.43%) Data Analyst
4 3 (8.57%) Developer
4 3 (8.57%) Murex Developer
4 3 (8.57%) Senior Analyst
4 3 (8.57%) Senior Data Analyst
5 2 (5.71%) Business Analyst
5 2 (5.71%) Commercial Analyst
5 2 (5.71%) Java Developer
5 2 (5.71%) Murex MxML Developer
5 2 (5.71%) Transformation Analyst
6 1 (2.86%) Business IT Analyst
6 1 (2.86%) Data Manager
6 1 (2.86%) Service Analyst
6 1 (2.86%) Test Analyst
Libraries, Frameworks & Software Standards
1 7 (20.00%) XML
2 6 (17.14%) .NET
2 6 (17.14%) FIX Protocol
2 6 (17.14%) FpML
2 6 (17.14%) XSD
3 4 (11.43%) D3.js
4 3 (8.57%) Murex MxML
5 2 (5.71%) Web Services
6 1 (2.86%) Gherkin
6 1 (2.86%) Middleware
6 1 (2.86%) Spring
6 1 (2.86%) XSLT
Miscellaneous
1 7 (20.00%) Analytical Skills
2 2 (5.71%) Equities
2 2 (5.71%) Foreign Exchange (FX)
2 2 (5.71%) User Experience
3 1 (2.86%) Computer Science
3 1 (2.86%) Data Structures
3 1 (2.86%) Management Information System
3 1 (2.86%) Mobile App
3 1 (2.86%) Mobile Banking
Operating Systems
1 3 (8.57%) Unix
2 1 (2.86%) Linux
Processes & Methodologies
1 15 (42.86%) Workflow
2 9 (25.71%) Data Security
3 7 (20.00%) Data Governance
3 7 (20.00%) Unit Testing
4 6 (17.14%) Code Coverage
4 6 (17.14%) Data Analysis
4 6 (17.14%) Data Modelling
4 6 (17.14%) Regression Testing
4 6 (17.14%) Visualisation
5 5 (14.29%) Business Intelligence
5 5 (14.29%) Fund Management
5 5 (14.29%) Information Management
5 5 (14.29%) Portfolio Management
6 4 (11.43%) Agile Software Development
6 4 (11.43%) Analytics
6 4 (11.43%) SDLC
7 3 (8.57%) Asset Management
7 3 (8.57%) Business Analysis
7 3 (8.57%) Test Automation
8 2 (5.71%) Open Source
Programming Languages
1 24 (68.57%) SQL
2 12 (34.29%) T-SQL
3 9 (25.71%) Java
4 6 (17.14%) PL/SQL
5 4 (11.43%) Python
5 4 (11.43%) R
5 4 (11.43%) VB
6 3 (8.57%) Shell Script
7 1 (2.86%) Bash Shell
7 1 (2.86%) C
Qualifications
1 1 (2.86%) Computer Science Degree
1 1 (2.86%) Degree
Quality Assurance & Compliance
1 7 (20.00%) Data Quality
2 6 (17.14%) ISO 20022
3 4 (11.43%) ISO 15022
4 2 (5.71%) QA
Vendors
1 13 (37.14%) Microsoft
2 7 (20.00%) Oracle
3 6 (17.14%) Sybase
4 5 (14.29%) Hortonworks
4 5 (14.29%) Tableau
5 4 (11.43%) Alteryx
5 4 (11.43%) Murex
5 4 (11.43%) Talend
6 1 (2.86%) Cloudera
6 1 (2.86%) HP
6 1 (2.86%) MapR
City, London
Best Practice Talent Solutions
Salary: From £25,000 to £35,000 per annum + health + pension + fast track prom
Posted: 4 days ago
City, London
Client Server
Salary: £45k to £55k + benefits
Posted: 3 days ago
City, London
Client Server
Salary: £55k to £65k + bonus + benefits
Posted: 5 days ago