Period
to 19 July 2018

The following table provides summary statistics for permanent job vacancies advertised in Livingston with a requirement for SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited SQL over the 6 months to 19 July 2018 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
West Lothian > Livingston
6 months to
19 Jul 2018
Same period 2017 Same period 2016
Rank 1 3 2
Rank change year-on-year +2 -1 -1
Permanent jobs citing SQL 29 31 18
As % of all permanent IT jobs advertised in Livingston 47.54% 34.07% 30.00%
As % of the Programming Languages category 65.91% 46.27% 48.65%
Number of salaries quoted 29 25 12
Livingston median annual salary £40,000 £29,500 £33,750
Median salary % change year-on-year +35.59% -12.59% -14.56%
10th Percentile £28,500 £24,000 £24,000
90th Percentile £50,700 £41,800 £47,500
West Lothian median annual salary £40,000 £32,500 £37,500
% change year-on-year +23.08% -13.33% -5.06%

SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Livingston with a requirement for coding skills.

All Programming Languages
Livingston
Permanent vacancies with a requirement for coding skills 44 67 37
As % of all permanent IT jobs advertised in Livingston 72.13% 73.63% 61.67%
Number of salaries quoted 39 55 23
Livingston median annual salary £40,000 £36,500 £37,500
Median salary % change year-on-year +9.59% -2.67% -1.96%
10th Percentile £30,600 £24,000 £24,200
90th Percentile £50,700 £51,500 £47,500
West Lothian median annual salary £42,500 £36,500 £37,500
% change year-on-year +16.44% -2.67% -3.85%

SQL
Job Vacancy Trend in Livingston

Job postings citing SQL as a percentage of all IT jobs advertised in Livingston.

Job vacancy trend for SQL in Livingston

SQL
Salary Trend in Livingston

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing SQL in Livingston.

Salary trend for SQL in Livingston

SQL
Salary Histogram in Livingston

The salary distribution of IT jobs citing SQL in Livingston over the 6 months to 19 July 2018.

Salary histogram for SQL in Livingston

For the 6 months to 19 July 2018, IT jobs citing SQL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Livingston region with a requirement for SQL.

1 15 (51.72%) Oracle
1 15 (51.72%) XML
2 12 (41.38%) JavaScript
3 11 (37.93%) PL/SQL
3 11 (37.93%) jQuery
4 10 (34.48%) Oracle APEX
4 10 (34.48%) Ajax
4 10 (34.48%) Business Development
4 10 (34.48%) Finance
4 10 (34.48%) Retail
4 10 (34.48%) HTML
4 10 (34.48%) Toad
5 9 (31.03%) Agile Software Development
6 8 (27.59%) Team Foundation Server
6 8 (27.59%) Microsoft
7 7 (24.14%) Windows
8 6 (20.69%) Microsoft Azure
9 5 (17.24%) Windows Server
9 5 (17.24%) Opscode Chef
9 5 (17.24%) Ansible
9 5 (17.24%) .NET
9 5 (17.24%) C#
9 5 (17.24%) SQL Server
9 5 (17.24%) Project Management
10 4 (13.79%) HP
10 4 (13.79%) Business Intelligence
10 4 (13.79%) CRM
10 4 (13.79%) IIS
10 4 (13.79%) Unix
10 4 (13.79%) Software Engineering

SQL
Co-occurring IT Skills in Livingston 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 (13.79%) IIS
2 2 (6.90%) SAS
Business Applications
1 1 (3.45%) Oracle Applications
1 1 (3.45%) Oracle EBS
1 1 (3.45%) Oracle ERP
Cloud Services
1 6 (20.69%) Microsoft Azure
2 1 (3.45%) SaaS
Communications & Networking
1 2 (6.90%) TCP/IP
2 1 (3.45%) Firewall
Database & Business Intelligence
1 5 (17.24%) SQL Server
2 4 (13.79%) Oracle Database
3 2 (6.90%) Relational Database
3 2 (6.90%) SQL Server Analysis Services
3 2 (6.90%) SQL Server Integration Services
3 2 (6.90%) SQL Server Reporting Services
4 1 (3.45%) Oracle Reports
4 1 (3.45%) SQL Server 2008
4 1 (3.45%) SQL Server 2012
4 1 (3.45%) SQL Server 2014
Development Applications
1 10 (34.48%) Oracle APEX
1 10 (34.48%) Toad
2 8 (27.59%) Team Foundation Server
3 2 (6.90%) Visual Studio
4 1 (3.45%) ProC
General
1 10 (34.48%) Finance
1 10 (34.48%) Retail
2 2 (6.90%) Electronics
2 2 (6.90%) Manufacturing
2 2 (6.90%) Telecoms
Job Titles
1 11 (37.93%) Analyst
1 11 (37.93%) Developer
2 10 (34.48%) Oracle Developer
3 7 (24.14%) SQL Analyst
4 3 (10.34%) Functional Tester
4 3 (10.34%) Technical Analyst
4 3 (10.34%) Tester
5 2 (6.90%) Applications Support
5 2 (6.90%) Applications Support Analyst
5 2 (6.90%) C++ Software Engineer
5 2 (6.90%) Cloud Technical Analyst
5 2 (6.90%) Data Analytics Manager
5 2 (6.90%) Embedded C/C++ Engineer
5 2 (6.90%) Embedded C/C++ Software Engineer
5 2 (6.90%) Embedded C++ Engineer
5 2 (6.90%) Embedded C++ Software Engineer
5 2 (6.90%) Embedded Software Engineer
5 2 (6.90%) Report Analyst
5 2 (6.90%) Software Engineer
5 2 (6.90%) Support Analyst
Libraries, Frameworks & Software Standards
1 15 (51.72%) XML
2 11 (37.93%) jQuery
3 10 (34.48%) Ajax
3 10 (34.48%) HTML
4 5 (17.24%) .NET
5 3 (10.34%) XML Messaging
6 1 (3.45%) ASP.NET
6 1 (3.45%) WCF
6 1 (3.45%) Web Services
Miscellaneous
1 2 (6.90%) Optoelectronics
2 1 (3.45%) Data Centre
2 1 (3.45%) Fintech
Operating Systems
1 7 (24.14%) Windows
2 5 (17.24%) Windows Server
3 4 (13.79%) Unix
4 1 (3.45%) Windows Server 2008
4 1 (3.45%) Windows Server 2012
Processes & Methodologies
1 10 (34.48%) Business Development
2 9 (31.03%) Agile Software Development
3 5 (17.24%) Project Management
4 4 (13.79%) API Testing
4 4 (13.79%) Business Intelligence
4 4 (13.79%) CRM
4 4 (13.79%) Functional Testing
4 4 (13.79%) SDLC
4 4 (13.79%) Software Engineering
4 4 (13.79%) Test Automation
4 4 (13.79%) Test Planning
4 4 (13.79%) Test Scripting
4 4 (13.79%) Waterfall
5 3 (10.34%) Deployment Automation
5 3 (10.34%) Validation
6 2 (6.90%) Data Management
6 2 (6.90%) ETL
6 2 (6.90%) Physics
6 2 (6.90%) Predictive Modelling
6 2 (6.90%) Scrum
Programming Languages
1 12 (41.38%) JavaScript
2 11 (37.93%) PL/SQL
3 5 (17.24%) C#
4 3 (10.34%) PowerShell
4 3 (10.34%) T-SQL
5 2 (6.90%) C
5 2 (6.90%) C++
5 2 (6.90%) Python
Qualifications
1 3 (10.34%) Degree
Quality Assurance & Compliance
1 1 (3.45%) ISO 9001
1 1 (3.45%) ISO/IEC 27001
System Software
1 2 (6.90%) Firmware
Systems Management
1 5 (17.24%) Ansible
1 5 (17.24%) Opscode Chef
2 4 (13.79%) HP Quality Center
3 3 (10.34%) HP ALM
4 2 (6.90%) Munin
4 2 (6.90%) Nagios
4 2 (6.90%) Prometheus
Vendors
1 15 (51.72%) Oracle
2 8 (27.59%) Microsoft
3 4 (13.79%) HP
4 2 (6.90%) New Relic
4 2 (6.90%) Tableau