BI Developer (Data & Integration)

Experis Ltd
£30k - £37k pa
18 Oct 2016
17 Nov 2016
Contract Type
BI Designer/ Developer, Business Intelligence, BI, Data, Integration, SSAS, SSRS, ETL, Database, Microsoft BI, SQL, SSIS, Public Sector, Education, Data Quality, Cleansing, Security, Durham.


- Translate user requirements provided by business areas, business analysts, subject matter experts and working groups into technical designs and documentation
- Design the dimensional databases to hold the reporting data taking into account considerations such as - the need to load the data into SSAS multidimensional and tabular models
- ability to report from the data using SSRS
- tracking of changed data,
- conformance of the data with other processes,

- Design the data extract, transformation and load (ETL) processes to support the reporting service, working with subject matter experts - Taking into account considerations such as data quality, cleansing, security

- Work with the presentation layer designers and SMEs to design the multidimensional database dimensions and cubes to support the business reporting requirements and enable efficient data load
- Carry out the build and test work associated with the ETL processes, database creation / load and cube creation / load
- Work with DBAs to size the databases, tune the performance and ensure the sustainability of of the end to end solution
- Define and create views and write stored procedures
- Produce standardised documentation associated with each of the above tasks and ensure that these are published as appropriate
- Implement, support and maintain the database load and integration processes
- Comply with the client change management processes
- Identify and report on any risks associated with the design and implementation process
- Other activities related to the reporting services as appropriate

Person Specification



- Be a graduate, or have an equivalent professional qualification in an IT related discipline.


- Experience of translating business requirements into technical design
- Significant hands-on experience designing and building ETL solutions
- Dimensional database design experience in a Microsoft BI environment
- Significant experience of developing and deploying ETL and dimensional / multidimensional database and OLAP solutions


- SSIS design and build
- SQL Server
- SQL, creation of views, writing of stored procedures
- Understanding of industry standard approaches to dimensional design and ETL


- Produce dimensional and multidimensional models and designs
- Produce efficient ETL designs
- Develop, test and implemement ETL packages
- Develop and deploy SSIS and solutions
- Work with DBAs to size and tune the dimensional databases objects
- Work well within a team and used to supporting / advising / mentoring other team members
- Excellent written communications ability, specifically in relation to the creation of system and user documentation

- High levels of self-motivation, initiative and ability to promote and demonstrate a flexible 'can do' attitude.
- Excellent listening skills with the ability to understand end user requirements and translate into technical solutions.
- Excellent planning and organizational skills
- Ability to quickly comprehend the functions and capabilities of new technologies
- Good interpersonal skills and be an excellent team player
- Ability to provide realistic estimates and manage workload effectively within time constraint
- Ability to work in a small team with both internal staff and external suppliers to achieve results.


- Project Management


- Oracle and Oracle Financials reporting tools such as Discoverer
- Reporting and business intelligence in a University setting
- Experience of leading teams comprising of multi-skilled technical and non-technical staff.
- Experience of writing standards / designing templates for design / development processes


A good understanding information security principles and implications of legislation such as Data Protection, Freedom of Information Acts.


Ability to carry out overall data architecture design