The first table below looks at the demand for Dimensional Modelling skills in IT jobs advertised across the UK. Included is a guide to the average salaries offered in IT jobs that have cited Dimensional Modelling over the 3 months to 17 May 2013 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Processes & Methodologies category.

Location
3 months to
17 May 2013
Same period 2012 Same period 2011
Dimensional Modeling
Rank 564 552 637
Rank change year-on-year
-12 +85
Permanent jobs citing Dimensional Modelling 308 369 239
As % of all permanent IT jobs located in the UK 0.286% 0.305% 0.194%
As % of the Processes & Methodologies category 0.374% 0.409% 0.263%
Number of salaries quoted 227 330 173
Average salary £52,500 £55,000 £47,500
Average salary % change year-on-year
-4.54% +15.78%
90% offered a salary of more than £35,000 £41,500 £39,000
10% offered a salary of more than £70,000 £77,500 £72,500
UK excluding London average salary £43,000 £47,500 £52,500
% change year-on-year
-9.47% -9.52%
All Processes & Methodologies
UK
Permanent IT job ads with a match in the
Processes & Methodologies category
82363 90112 90953
As % of all permanent IT jobs located in the UK 76.41% 74.51% 73.67%
Number of salaries quoted 67577 76622 76058
Average salary £45,000 £47,500 £47,500
Average salary % change year-on-year
-5.26% -
90% offered a salary of more than £30,000 £30,000 £30,000
10% offered a salary of more than £70,000 £75,000 £75,000
UK excluding London average salary £40,000 £41,000 £40,000
% change year-on-year
-2.43% +2.50%

Dimensional Modelling
Jobs Demand Trend

This chart provides the 3-month moving total of permanent IT jobs citing Dimensional Modelling within the UK as a proportion of the total demand within the Processes & Methodologies category.

Dimensional Modelling Jobs Demand Trend

Dimensional Modelling
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Dimensional Modelling within the UK.

Dimensional Modelling Salary Trend

Dimensional Modelling
Salary Histogram

This chart provides a salary histogram for IT jobs citing Dimensional Modelling over the 3 months to 17 May 2013 within the UK.

Dimensional Modelling Salary Histogram

Dimensional Modelling
Top 30 Job Locations

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing Dimensional Modelling within the UK over the 3 months to 17 May 2013. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click each for more statistics)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
England -15 292 £50,000 -13.04%
London -57 153 £52,500 -12.50%
South East +12 42 £47,500 -5.00%
Hertfordshire +34 40 £75,000 +87.50%
East of England +31 40 £75,000 +87.50%
Yorkshire +15 35 £36,500 +4.28%
West Yorkshire +30 32 £38,000 +1.33%
St Albans +21 32 £36,250 -
Leeds +10 29 £35,000 -6.66%
City of London -62 24 £56,500 -5.83%
Oxford - 15 £43,000 -
Oxfordshire - 15 £43,000 -
Kent - 7 £36,000 -
Berkshire +5 6 £50,000 -
West Midlands -13 6 £33,500 -10.66%
South West - 6 £32,500 -
Staffordshire - 5 £33,500 -
Midlands +17 4 £75,000 +66.66%
Surrey +14 4 £50,000 +5.26%
Edinburgh +1 4 £37,500 +7.14%
Scotland -11 4 £37,500 -6.25%
East Sussex - 4 £42,500 -
Reading 0 3 £50,000 +3.62%
Buckinghamshire -6 3 £50,000 -9.09%
Bromley - 3 £50,000 -
East Midlands - 3 £35,000 -
Sheffield +7 2 £35,000 +7.69%
South Yorkshire +5 2 £35,000 +7.69%
North West -11 2 £75,000 +66.66%
Lincoln - 2 £35,500 -

Dimensional Modelling
Top 30 Related IT Skills

For the 6 months to 17 May 2013, IT jobs within the UK citing Dimensional Modelling also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited Dimensional Modelling.

1 543 (89.31%) Business Intelligence
2 456 (75.00%) Data Warehouse
3 415 (68.26%) SQL
4 364 (59.87%) ETL
5 352 (57.89%) SQL Server
6 284 (46.71%) SQL Server Integration Services
7 270 (44.41%) SQL Server Reporting Services
8 251 (41.28%) SQL Server Analysis Services
9 242 (39.80%) T-SQL
10 208 (34.21%) Microsoft
11 203 (33.39%) SQL Server 2008
12 189 (31.09%) Data Modelling
12 189 (31.09%) MS Excel
13 174 (28.62%) Oracle
14 147 (24.18%) Finance
15 138 (22.70%) OLAP
16 134 (22.04%) MDX
17 124 (20.39%) Business Objects
18 120 (19.74%) SQL Server 2005
19 102 (16.78%) Informatica
20 86 (14.14%) Kimball Methodology
21 84 (13.82%) Oracle 11g
22 79 (12.99%) Cognos
23 74 (12.17%) Oracle BI EE
24 72 (11.84%) PL/SQL
25 63 (10.36%) Migration
26 62 (10.20%) SAP
27 61 (10.03%) .NET
27 61 (10.03%) BusinessObjects
28 60 (9.868%) Degree

Dimensional Modelling
Top Related IT Skills by Category

For the 6 months to 17 May 2013, IT jobs within the UK citing Dimensional Modelling also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited Dimensional Modelling. Up to 20 skills are shown per category.

Application Development
1 134 (22.04%) MDX
2 61 (10.03%) .NET
3 18 (2.961%) COM
4 14 (2.303%) SAP XI
5 13 (2.138%) ASP.NET
6 8 (1.316%) XML
7 7 (1.151%) XSLT
8 5 (0.822%) Middleware
8 5 (0.822%) Web Services
8 5 (0.822%) Oracle Fusion
9 4 (0.658%) CSS
9 4 (0.658%) jQuery
10 3 (0.493%) JPA
10 3 (0.493%) XML Schema
10 3 (0.493%) HTML
10 3 (0.493%) XSD
11 2 (0.329%) Oracle ADF
12 1 (0.164%) Velocity
Application Platforms
1 57 (9.375%) SharePoint
2 11 (1.809%) SAS
3 5 (0.822%) WebLogic
4 3 (0.493%) Oracle Application Server
4 3 (0.493%) SharePoint Server
4 3 (0.493%) Windows Azure
4 3 (0.493%) BizTalk Server
5 1 (0.164%) Oracle Workflow
Applications
1 189 (31.09%) MS Excel
2 43 (7.072%) PowerPivot
3 9 (1.480%) MS Office
4 5 (0.822%) MS Visio
5 3 (0.493%) MS PowerPoint
6 2 (0.329%) SPSS
Business Applications
1 45 (7.401%) Oracle EBS
2 42 (6.908%) Cognos Business Intelligence
3 26 (4.276%) HFM
4 10 (1.645%) Cognos Planning
5 9 (1.480%) SAP BPC
6 7 (1.151%) Oracle Applications
7 6 (0.987%) Oracle EBS R12
8 4 (0.658%) Bond Adapt
9 3 (0.493%) Oracle BPM
10 2 (0.329%) Siebel Analytics
10 2 (0.329%) Dynamics CRM
11 1 (0.164%) Oracle 11i
11 1 (0.164%) SAP FI
11 1 (0.164%) SAP FI/CO
11 1 (0.164%) SAP CO
Communications & Networking
1 29 (4.770%) Broadband
2 7 (1.151%) Internet
3 5 (0.822%) LDAP
4 3 (0.493%) HTTP
5 1 (0.164%) HTTPS
Database & Business Intelligence
1 456 (75.00%) Data Warehouse
2 352 (57.89%) SQL Server
3 284 (46.71%) SQL Server Integration Services
4 270 (44.41%) SQL Server Reporting Services
5 251 (41.28%) SQL Server Analysis Services
6 203 (33.39%) SQL Server 2008
7 138 (22.70%) OLAP
8 120 (19.74%) SQL Server 2005
9 84 (13.82%) Oracle 11g
10 74 (12.17%) Oracle BI EE
11 61 (10.03%) BusinessObjects
12 58 (9.539%) Microsoft Analysis Services
13 52 (8.553%) BODI
14 41 (6.743%) SAP Data Services
15 39 (6.414%) QlikView
16 37 (6.086%) Oracle Reports
17 32 (5.263%) RDBMS
17 32 (5.263%) BusinessObjects XI
18 31 (5.099%) SQL Server 2012
19 30 (4.934%) Star Schema
Development Applications
1 13 (2.138%) ERwin
2 10 (1.645%) Oracle APEX
3 9 (1.480%) Team Foundation Server
4 5 (0.822%) QuickTest Pro
5 1 (0.164%) Oracle Forms
5 1 (0.164%) Talend Open Studio
General
1 147 (24.18%) Finance
2 43 (7.072%) Marketing
3 32 (5.263%) Banking
4 28 (4.605%) Telecoms
5 26 (4.276%) Retail
6 23 (3.783%) Investment Banking
7 19 (3.125%) Front Office
8 9 (1.480%) Manufacturing
8 9 (1.480%) Publishing
9 7 (1.151%) Advertising
10 4 (0.658%) Games
11 2 (0.329%) Automotive
12 1 (0.164%) German Language
12 1 (0.164%) Retail Banking
12 1 (0.164%) Aerospace
12 1 (0.164%) Back Office
12 1 (0.164%) Pharmaceutical
Job Titles
1 360 (59.21%) Developer
2 184 (30.26%) Business Intelligence Developer
3 116 (19.08%) Consultant
4 91 (14.97%) SQL Developer
5 68 (11.18%) Business Developer
6 65 (10.69%) Analyst
7 54 (8.882%) Business Intelligence Consultant
7 54 (8.882%) Microsoft Developer
8 44 (7.237%) Architect
8 44 (7.237%) Business Intelligence Analyst
9 43 (7.072%) Data Warehouse Developer
10 37 (6.086%) Business Analyst
11 35 (5.757%) Business Consultant
12 33 (5.428%) OBIEE Consultant
13 32 (5.263%) ETL Developer
14 30 (4.934%) Oracle Consultant
15 27 (4.441%) SQL Server Developer
16 26 (4.276%) Senior Developer
17 21 (3.454%) Oracle BI Consultant
18 20 (3.289%) Oracle Developer
Miscellaneous
1 45 (7.401%) Data Integration
2 18 (2.961%) Computer Science
3 15 (2.467%) Clustering
4 12 (1.974%) Management Information System
5 10 (1.645%) Digital Media
6 9 (1.480%) PMI
7 6 (0.987%) Oracle Exalytics
8 5 (0.822%) Enterprise Software
8 5 (0.822%) SaaS
9 3 (0.493%) FMCG
9 3 (0.493%) Visualisation
9 3 (0.493%) Mathematics
9 3 (0.493%) Physics
9 3 (0.493%) W3C
10 2 (0.329%) Statistics
10 2 (0.329%) Replication
10 2 (0.329%) Data Extraction
11 1 (0.164%) Hedge funds
11 1 (0.164%) Fixed Income
11 1 (0.164%) NHS
Operating Systems
1 28 (4.605%) UNIX
2 22 (3.618%) Linux
3 4 (0.658%) Windows
Processes & Methodologies
1 543 (89.31%) Business Intelligence
2 364 (59.87%) ETL
3 189 (31.09%) Data Modelling
4 86 (14.14%) Kimball Methodology
5 63 (10.36%) Migration
6 54 (8.882%) Unit Testing
7 46 (7.566%) Data Migration
8 38 (6.250%) Analytics
9 33 (5.428%) Agile Software Development
10 32 (5.263%) Scrum
10 32 (5.263%) Data Cleansing
11 30 (4.934%) CRM
12 26 (4.276%) Change Management
13 25 (4.112%) Validation
14 23 (3.783%) Data Management
15 20 (3.289%) Data Analysis
16 19 (3.125%) Stakeholder Management
16 19 (3.125%) Business Analysis
16 19 (3.125%) Data Governance
17 18 (2.961%) Requirements Analysis
Programming Languages
1 415 (68.26%) SQL
2 242 (39.80%) T-SQL
3 72 (11.84%) PL/SQL
4 58 (9.539%) C#
5 25 (4.112%) Shell Script
6 17 (2.796%) Bash shell
7 16 (2.632%) VB
8 12 (1.974%) JavaScript
8 12 (1.974%) Korn
9 10 (1.645%) R
10 8 (1.316%) VBA
11 7 (1.151%) Java
11 7 (1.151%) VB.NET
12 4 (0.658%) PowerShell
13 3 (0.493%) ABAP
13 3 (0.493%) PHP
13 3 (0.493%) XPath
14 2 (0.329%) Python
15 1 (0.164%) C++
Qualifications
1 60 (9.868%) Degree
2 25 (4.112%) Security Cleared
3 9 (1.480%) PMI Certification
4 7 (1.151%) Oracle Certification
5 6 (0.987%) SC Cleared
6 4 (0.658%) DV Cleared
6 4 (0.658%) ISEB
7 1 (0.164%) Microsoft Certification
7 1 (0.164%) MCITP
7 1 (0.164%) NVQ Level 3
Quality Assurance & Compliance
1 38 (6.250%) Data Quality
2 17 (2.796%) QA
3 1 (0.164%) SLA
3 1 (0.164%) COBIT
System Software
1 10 (1.645%) Oracle RAC
Systems Management
1 7 (1.151%) Data Guard
2 4 (0.658%) HP Quality Center
3 1 (0.164%) Control-M
Vendors
1 208 (34.21%) Microsoft
2 174 (28.62%) Oracle
3 124 (20.39%) Business Objects
4 102 (16.78%) Informatica
5 79 (12.99%) Cognos
6 62 (10.20%) SAP
7 36 (5.921%) IBM
8 31 (5.099%) MicroStrategy
9 27 (4.441%) Ab Initio
9 27 (4.441%) Hyperion
10 21 (3.454%) Sybase
11 17 (2.796%) Teradata
12 8 (1.316%) TIBCO
13 7 (1.151%) Hitachi
13 7 (1.151%) Netezza
13 7 (1.151%) Tableau
14 5 (0.822%) Actuate
15 4 (0.658%) VMware
15 4 (0.658%) UC4
15 4 (0.658%) Twitter
High Wycombe, Buckinghamshire
2X BI Developer- Data Warehouse... General tasks: *Developing optimised and quality SSIS packages, stored procedures and SQL code *Evangelise SSIS as the single ETL tool within the company *...
Pertemps IT
Salary: £40,000 - £50,000
Posted: 13 May 2013
London
Working within a fast paced and challenging environment as a SQL BI developer, you will be responsible for the full end-to-end development lifecycle from requirement gathering...
Real Staffing
Salary: £50000 - £70000 per annum + BENEFITS
Posted: 15 May 2013
Skipton, Yorkshire
Business Intelligence Developer - Skipton - £29kMy client is looking to recruit a SQL Server Business Intelligence Developer to join their team in Skipton.The successful candidate will have experience...
Mint
Salary: £26000 - £29000 per annum
Posted: 30 April 2013
Lincoln
toolset (SSMS, SSIS, SSAS, SSRS) and will provide exposure along the full length of the development life cycle from ETL, through data warehousing to dashboard and report development.
University of Lincoln
Salary: £25,504 per annum + generous benefits
Posted: 19 May 2013
Lincoln, Lincolnshire
Planning and Business Intelligence... using SQL Server 2008 R2... To be successful in this position you will need experience of SQL Server 2005/2008 R2, SSRS, SSIS and...
University of Lincoln
Salary: £25,504 per annum + generous benefits
Posted: 7 May 2013
South East
A strong Oracle BI Business Intelligent OBIEE 11g and OBIA Specialist required for a permanent role based at various locations around the UK offering in the region of £...
Fusion Experience
Salary: From £65,000 to £75,000 per annum
Posted: 13 May 2013
Leeds, West Yorkshire
The full Microsoft B.I. stack, using SSMS, SSIS, SSAS,SSRS, Master Data Services, Data Quality Services and MS Excel are required for this position... solutions are essential...
The Bridge Ltd
Salary: From £40,000 to £45,000 per annum
Posted: 17 May 2013
Maidenhead, Thames Valley
A need has arisen for a SQL Server Data Warehouse Developer to join a medium sized Financial Services organisation to work as part of the Business Intelligence team...
Brightred Resourcing
Salary: £40000 - £50000 per annum + bonus and benefits
Posted: 11 May 2013
Maidenhead, Berkshire
Must have a good understanding of dimensional modelling. Minimum of 3 years SQL Server 2008 experience. A proven capability of delivering optimised SSIS packages within a BI environment...
Brightred Resourcing Limited
Salary: £40000 - £50000 per annum + bonus and benefits
Posted: 17 May 2013
Hertfordshire
You must be familiar with the Microsoft Business Intelligence stack, and have experience of using it in an operational environment and be proficient with SSMS, T-SQL, BIDS (...
PNG Recruitment Solutions
Salary: £35,000 per annum
Posted: 17 May 2013
East Sussex, South East
To manage and develop an existing Risk Data Mart, specifically the dimensional presentation layer component and business objects layer... ThirdNormalForm, Dimensional Modelling. ETL principles and best practice Kimble /...
Orgtel
Salary: £41000 - £58000 per annum + benefits
Posted: 16 May 2013
London
Expert knowledge of MicroStrategy Ability to write well-structured T-SQL Good knowledge of MicroStrategy architecture Experience of dimensional modeling, Data Warehousing techniques, methodologies, and data modeling tools...
bridgenoble
Salary: £50000 - £60000 per annum + Bonus + Benefits
Posted: 23 April 2013
Leeds, West Yorkshire
SQL Server 2005/2008r2... Desirable Skills Microsoft BI Certifications. SSIS (SQL Server Integration Services) SSAS ( SQL Server Analysis Services ) An appreciation of Cognos BI v10.1. MS Dynamics...
Venturi
Salary: £30000 - £40000 per annum + Benefits
Posted: 16 May 2013
Hertfordshire
Strong knowledge of SSAS / SSIS / SSRS / SQL Server / Sharepoint is essential, and knowledge of Powerpivot will be an advantage Must demonstrate excellent written and verbal communication... Preferably educated...
Sky
Posted: 15 May 2013
Hertfordshire, South East
Job Title - Microsoft Solution ArchitectLocation - St AlbansWe are currently looking for a Microsoft Solution Architect to join our Change & Delivery team in St Albans. The role will take...
SkyIQ
Posted: 19 May 2013
Manchester, North West
A leading e-commerce firm based in Greater Manchester are actively seeking experienced business intelligence & data-warehousing developers to join their growing BI team. This is a role...
Computer Futures
Salary: £35000 - £40000 per annum
Posted: 15 May 2013
City of London
Proven experience of MDX and creating MDX driven SSRS reports Experience of designing and developing high quality SSRS reports using the Microsoft BI toolset... Must have commendable T-...
Salt
Salary: £50000 - £55000 per annum + Bonus + Benefits
Posted: 18 May 2013
London
Lead Business Intelligence Developer Business Objects/Business Intelligence/BI/Lead/Manager/ Data WarehousingLead Business Intelligence Developer is required by our multinational Financial client to join their BI team...
Computer Futures
Salary: £60000 - £70000 per annum + Benefits
Posted: 15 May 2013
City of London
Key skills Must have a least 3 years in Microsoft SQL server tools, integration services , analysis services and report services. (SSIS, SSRS, SSRS). Knowledge of Microsoft SQL server...
Progressive Recruitment
Salary: £50000 - £55000 per annum
Posted: 15 May 2013
Edinburgh & Lothians
Min 5 yrs SQL Server BI including 2005 and 2008 - SSIS/SSAS/SSRS/ T-SQL/MDX - Dimensional modelling skills - SharePoint 2010 BI including Performance Point Services - Experience of...
Sopra Group Ltd
Salary: Attractive, plus flexible benefits
Posted: 10 May 2013
Brighton, East Sussex
One of our leading financial clients is looking for a Senior/Manager Data Warehouse Developer for a permanent position based in Brighton... The successful candidate is needed to...
Search Consultancy
Posted: 13 May 2013
Burton-On-Trent, Staffordshire
A leading FMCG company is looking for a SSAS / SSIS - BI Development Analyst to join their IT and business systems team. As the BI Development Analyst your main...
EU Solutions
Salary: £30000 - £35000 per annum + excellent training
Posted: 13 May 2013
West London
Dunnhumby is looking for a Technical/ Data Modeller with Physical Modelling experience to join them on a permanent basis in West London. Your role will involve drawing up/...
Dunnhumby
Posted: 26 April 2013
UK Wide - Consulting
Our Client a leading, dynamic International Consultancy is looking for a Terdata Physical Data Modelling Consultant and a Logical Data Modelling Consultant. The Physical Data Modeller is responsible...
SK Consultancy Solutions
Salary: £55,000 - £85,000 per year + Flexible Benefits + Bonus + Pension
Posted: 3 May 2013
London
o Microstrategy OLAP Services... - Strong database skills (SQL Server or Oracle) including T-SQL/PLSQL... - Experience of one or more ETL tools (Ab Initio, SSIS, Informatica, OWB, BODI...
Sopra Group Ltd
Salary: Attractive, plus flexible benefits
Posted: 1 May 2013
UK
Informatica Administration: capacity planning, installation and administration - Reporting tools such as Business Objects, OBIEE and SAS Role will require strong analysis and documentation skills; any exposure to banking...
NBS Recruitment
Salary: £40,000 - £70,000 per year
Posted: 8 May 2013
South East
Oracle Business Intelligence Consultant required for a large Blue Chip IT Company... Candidates must have Oracle Business Intelligence Foundation Specialist certification. Experience in designing and implementing BI Security...
Lorien Resourcing
Salary: OFFER COMPETITIVE PACKAGE
Posted: 17 May 2013
London
The practice is technology agnostic and has capability across a range of technologies, including products from SAP, Oracle, IBM and Microsoft as well as more specialist technology providers...
Atos
Salary: £1 - £2 per annum + Benefits
Posted: 24 April 2013
London
SAP Business Objects Designer (Universe Development) Advanced reporting with Webi, Deski, Crystal Reports, Explorer. Crystal Dashboard Design (formerly Xcelsius) Business Objects Explorer... Elements of the Sybase Analytics suite.
Venturi
Salary: £60000 - £90000 per annum + Bonus / Benefits
Posted: 17 May 2013
London
Essential Skills * Informatica ETL development skills using PowerCenter o At least version 8.6.1; experience of v9.x an advantage * Informatica Data Quality v9 experience would be...
Asset Resourcing Ltd
Salary: £50000 - £75000 per annum + Excellent Benefits Package
Posted: 15 May 2013
Edinburgh, Midlothian
Senior Developer Consultant - Oracle Business Intelligence... Oracle Discoverer... Data Warehouse design and ETL principles... Dimensional modelling... Kimball methodology... * Office - Excel, Word, PowerPoint, and Visio... * Experience of complimentary OBI...
Asset Resourcing Ltd
Salary: £50000 - £75000 per annum + Excellent Benefits Package + Bonus
Posted: 17 May 2013