Period
to 21 January 2022

The median annual salary for a SQL Analyst was £60,000 in advertised job vacancies in the City of London during the 6 months to 21 January 2022.

The first table below provides salary benchmarking and summary statistics including a comparison to same period in the previous 2 years.

SQL Analyst
Central London > City of London
6 months to
21 Jan 2022
Same period 2021 Same period 2020
Rank 172 192 265
Rank change year-on-year +20 +73 -22
Permanent jobs requiring a SQL Analyst 88 32 47
As % of all permanent jobs advertised in the City of London 1.41% 0.75% 0.51%
As % of the Job Titles category 1.50% 0.80% 0.54%
Number of salaries quoted 82 30 44
10th Percentile £32,500 £43,625 £39,250
25th Percentile £41,250 £47,500 £44,375
Median annual salary (50th Percentile) £60,000 £56,250 £55,000
Median % change year-on-year +6.67% +2.27% -
75th Percentile £68,750 £71,250 £66,250
90th Percentile £72,500 £81,000 £70,000
Central London median annual salary £60,000 £60,000 £55,000
% change year-on-year - +9.09% -

The following table is for comparison with the above and includes summary statistics for all permanent IT job vacancies advertised in the City of London. Most job vacancies include a discernible job title that can be normalized. As such, the figures in the second row provide an indication of the number of permanent jobs in our overall sample.

All Permanent IT Job Vacancies
City of London
Permanent vacancies in the City of London with a recognized job title 5,865 3,994 8,764
% of permanent IT jobs with a recognized job title 94.07% 93.34% 95.23%
Number of salaries quoted 5,176 3,500 7,670
10th Percentile £42,375 £42,916 £36,250
25th Percentile £55,000 £53,750 £48,750
Median annual salary (50th Percentile) £72,500 £70,000 £65,000
Median % change year-on-year +3.57% +7.69% -
75th Percentile £92,500 £87,500 £82,500
90th Percentile £110,000 £103,750 £97,500
Central London median annual salary £70,000 £70,000 £65,000
% change year-on-year - +7.69% +4.00%

SQL Analyst
Job Vacancy Trend in the City of London

Job postings that featured SQL Analyst in the job title as a proportion of all IT jobs advertised in the City of London.

Job vacancy trend for SQL Analyst in the City of London

SQL Analyst
Salary Trend in the City of London

3-month moving average salary quoted in jobs citing SQL Analyst in the City of London.

Salary trend for SQL Analyst in the City of London

SQL Analyst
Salary Histogram in the City of London

Salary distribution for jobs citing SQL Analyst in the City of London over the 6 months to 21 January 2022.

Salary histogram for SQL Analyst in the City of London

SQL Analyst Skill Set
Top 30 Co-occurring IT Skills in the City of London

For the 6 months to 21 January 2022, SQL Analyst job roles required the following IT skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the City of London region featuring SQL Analyst in the job title.

1 83 (94.32%) SQL
2 38 (43.18%) SQL Server Integration Services
3 35 (39.77%) Finance
4 31 (35.23%) SQL Server
5 28 (31.82%) Microsoft Excel
5 28 (31.82%) Requirements Gathering
6 27 (30.68%) T-SQL
7 26 (29.55%) ETL
8 24 (27.27%) XML
9 22 (25.00%) Microsoft
10 21 (23.86%) Business Intelligence
10 21 (23.86%) Stakeholder Management
11 18 (20.45%) Data Warehouse
11 18 (20.45%) Agile Software Development
11 18 (20.45%) SDLC
12 17 (19.32%) Kimball Methodology
12 17 (19.32%) Problem-Solving
12 17 (19.32%) Change Management
13 16 (18.18%) Salesforce.com
13 16 (18.18%) Information Management
13 16 (18.18%) Visualisation
13 16 (18.18%) Portfolio Management
14 15 (17.05%) Confluence
14 15 (17.05%) JIRA
14 15 (17.05%) Data Visualisation
14 15 (17.05%) Data Quality
15 14 (15.91%) Analytics
15 14 (15.91%) SQL Server Reporting Services
15 14 (15.91%) Data Entry
16 13 (14.77%) XSLT

SQL Analyst Skill Set
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 15 (17.05%) Confluence
2 1 (1.14%) IIS
2 1 (1.14%) Tomcat
Applications
1 28 (31.82%) Microsoft Excel
Cloud Services
1 9 (10.23%) Azure
2 8 (9.09%) AWS
3 7 (7.95%) AWS Lambda
3 7 (7.95%) AWS Step Functions
3 7 (7.95%) Serverless
4 6 (6.82%) Power Platform
5 1 (1.14%) Collibra
5 1 (1.14%) GCP
5 1 (1.14%) SaaS
Database & Business Intelligence
1 38 (43.18%) SQL Server Integration Services
2 31 (35.23%) SQL Server
3 18 (20.45%) Data Warehouse
4 14 (15.91%) SQL Server Reporting Services
5 13 (14.77%) Relational Database
6 9 (10.23%) Metadata
7 8 (9.09%) SQL Server 2017
7 8 (9.09%) SSDT
8 7 (7.95%) Amazon Athena
9 6 (6.82%) Power BI
10 4 (4.55%) Tableau
11 1 (1.14%) Big Data
11 1 (1.14%) BusinessObjects
11 1 (1.14%) Looker
11 1 (1.14%) QlikView
11 1 (1.14%) SQL Server Analysis Services
Development Applications
1 15 (17.05%) JIRA
2 8 (9.09%) Team Foundation Server
2 8 (9.09%) Visual Studio
2 8 (9.09%) Visual Studio Team System
3 1 (1.14%) Atlassian Bamboo
3 1 (1.14%) Git (software)
General
1 35 (39.77%) Finance
2 13 (14.77%) Analytical Skills
3 8 (9.09%) Presentation Skills
3 8 (9.09%) Social Skills
4 7 (7.95%) Banking
5 5 (5.68%) Documentation Skills
5 5 (5.68%) Front Office
6 2 (2.27%) Back Office
7 1 (1.14%) Law
7 1 (1.14%) Marketing
7 1 (1.14%) Organisational Skills
7 1 (1.14%) Public Sector
7 1 (1.14%) Retail
Libraries, Frameworks & Software Standards
1 24 (27.27%) XML
2 13 (14.77%) XSLT
3 5 (5.68%) JSON
4 3 (3.41%) .NET
5 2 (2.27%) Middleware
6 1 (1.14%) PySpark
6 1 (1.14%) Web Services
Miscellaneous
1 11 (12.50%) Reinsurance
2 8 (9.09%) Foreign Exchange (FX)
3 7 (7.95%) Management Information System
4 3 (3.41%) Algorithms
5 1 (1.14%) Analytical Mindset
5 1 (1.14%) Legacy Systems
5 1 (1.14%) SWIFT
Operating Systems
1 10 (11.36%) Windows
Processes & Methodologies
1 28 (31.82%) Requirements Gathering
2 26 (29.55%) ETL
3 21 (23.86%) Business Intelligence
3 21 (23.86%) Stakeholder Management
4 18 (20.45%) Agile Software Development
4 18 (20.45%) SDLC
5 17 (19.32%) Change Management
5 17 (19.32%) Kimball Methodology
5 17 (19.32%) Problem-Solving
6 16 (18.18%) Information Management
6 16 (18.18%) Portfolio Management
6 16 (18.18%) Visualisation
7 15 (17.05%) Data Visualisation
8 14 (15.91%) Analytics
8 14 (15.91%) Data Entry
9 13 (14.77%) Data Analytics
10 12 (13.64%) Data Analysis
10 12 (13.64%) Test Scripting
11 10 (11.36%) Data Protection
11 10 (11.36%) OOP
Programming Languages
1 83 (94.32%) SQL
2 27 (30.68%) T-SQL
3 13 (14.77%) C#
4 10 (11.36%) Java
5 8 (9.09%) XPath
6 2 (2.27%) Python
7 1 (1.14%) VBA
Qualifications
1 9 (10.23%) ITIL Certification
2 8 (9.09%) Computer Science Degree
2 8 (9.09%) Degree
3 1 (1.14%) PhD
Quality Assurance & Compliance
1 15 (17.05%) Data Quality
2 10 (11.36%) Solvency II
3 9 (10.23%) QA
3 9 (10.23%) SLA
Systems Management
1 10 (11.36%) Kubernetes
Vendors
1 22 (25.00%) Microsoft
2 16 (18.18%) Salesforce.com
3 9 (10.23%) Oracle
4 8 (9.09%) Bloomberg
4 8 (9.09%) MarketAxess
4 8 (9.09%) Tradeweb
5 1 (1.14%) DocuSign
5 1 (1.14%) PeopleSoft
5 1 (1.14%) SAP