Transact-SQL
North West > Lancashire
The following table provides summary statistics for permanent job vacancies advertised in Lancashire with a requirement for T-SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited T-SQL over the 6 months to 2 June 2024 with a comparison to the same period in the previous 2 years.
| 6 months to 2 Jun 2024 |
Same period 2023 | Same period 2022 | |
|---|---|---|---|
| Rank | 82 | 61 | 119 |
| Rank change year-on-year | -21 | +58 | -60 |
| Permanent jobs citing T-SQL | 10 | 15 | 10 |
| As % of all permanent jobs advertised in Lancashire | 0.70% | 2.12% | 0.75% |
| As % of the Programming Languages category | 3.02% | 7.58% | 2.53% |
| Number of salaries quoted | 5 | 9 | 6 |
| 10th Percentile | £33,450 | - | £50,250 |
| 25th Percentile | £41,250 | - | - |
| Median annual salary (50th Percentile) | £42,500 | £45,000 | £58,000 |
| Median % change year-on-year | -5.56% | -22.41% | +45.00% |
| 75th Percentile | £61,250 | £53,750 | - |
| 90th Percentile | - | - | - |
| North West median annual salary | £50,000 | £52,000 | £50,000 |
| % change year-on-year | -3.85% | +4.00% | +8.70% |
All Programming Languages
Lancashire
T-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 Lancashire with a requirement for coding skills.
| Permanent vacancies with a requirement for coding skills | 331 | 198 | 395 |
| As % of all permanent jobs advertised in Lancashire | 23.03% | 27.97% | 29.63% |
| Number of salaries quoted | 261 | 125 | 111 |
| 10th Percentile | £31,250 | £35,750 | £30,000 |
| 25th Percentile | £40,000 | £40,000 | £40,000 |
| Median annual salary (50th Percentile) | £50,000 | £47,500 | £45,000 |
| Median % change year-on-year | +5.26% | +5.56% | +12.50% |
| 75th Percentile | £65,000 | £55,000 | £58,000 |
| 90th Percentile | £80,000 | £60,000 | £58,945 |
| North West median annual salary | £55,000 | £55,000 | £55,000 |
| % change year-on-year | - | - | +15.79% |
T-SQL
Job Vacancy Trend in Lancashire
Job postings citing T-SQL as a proportion of all IT jobs advertised in Lancashire.
T-SQL
Salary Trend in Lancashire
3-month moving average salary quoted in jobs citing T-SQL in Lancashire.
T-SQL
Salary Histogram in Lancashire
Salary distribution for jobs citing T-SQL in Lancashire over the 6 months to 2 June 2024.
T-SQL
Job Locations in Lancashire
The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing T-SQL within the Lancashire region over the 6 months to 2 June 2024. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.
| Location | Rank Change on Same Period Last Year |
Matching Permanent IT Job Ads |
Median Salary Past 6 Months |
Median Salary % Change on Same Period Last Year |
Live Jobs |
|---|---|---|---|---|---|
| Preston | +6 | 5 | £57,500 | +27.78% | |
| Lancaster | - | 2 | £42,500 | - | |
| Blackburn | - | 1 | £29,500 | - | |
| T-SQL North West |
|||||
T-SQL
Co-occurring Skills and Capabilities in Lancashire by Category
The follow tables expand on the table above by listing co-occurrences grouped by category. The same employment type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories: