BI Designer / Developer (Data Integration Project)

Recruiter
Certes Computing Limited
Location
Durham
Salary
£375 - £500 p day
Posted
07 Nov 2017
Closes
15 Nov 2017
Contract Type
Contract
Hours
Full Time
Business Intelligence Designer/Developer
6 month contract
Inside IR35
Durham
Tech skills - Oracle, Oracle Financial, Discoverer, SSIS, SSAS, SSRS, SSMS, BI reporting, ETL

Role
Development using SQL Server 2016 to build, design and implement an enterprise-wide business intelligence and reporting service.
You will be responsible for the design and development of the ETL processes and contribute to the dimensional design of the enterprise data store.

Project
My client wish to deliver a high quality "self-service" reporting service using a common set of reporting tools, and in addition to build capacity and capability within the reporting team.
It is important that there is a consistent set of methods and working practices and that the outputs of the service are well documented to facilitate effective "self-service".

Responsibilities
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
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

ESSENTIAL

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

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

SKILLS AND COMPETENCIES
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

Certes Computing (and all of its subsidiary companies) is committed to promoting equality and diversity in its business operations.
This job was originally posted as www.jobsite.co.uk/job/959474819