Register with us online today
Submit your CV through email
Looking to recruit
If you are planning to recruit click this link to send us your enquiry

Business Intelligence Data Designer / Developer

Ref: 29
Job Type:Permanent
Salary: £39,609 pa
Location: Durham
Closing Date:


Job Description

Business Intelligence Data Designer / Developer
Durham, North East

The role holder will be part of a major development using Microsoft SQL Server 2017 SSIS, SSAS and Power BI (with some SSRS) to design, build and implement an enterprise-wide business intelligence and reporting service for the organisation.

You will be responsible for the design and development of the ETL processes and the data (including the dimensional databases, cubes and tabular models) required to support decision making.

Key responsibilities of this post are as follows:

• Translate user requirements provided by business users, business analysts, subject matter experts and working groups into technical designs and documentation
• Work directly with colleagues in other departments to understand and refine information and reporting requirements
• Design the dimensional databases to hold the reporting data
• 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 and security
• Work with the presentation layer designers and SMEs to design and build the cubes and tabular models 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, tabular model creation / load

Experience Required:

• Excellent knowledge and significant hands-on experience of designing, building, testing and deploying complex ETL solutions using SSIS in a medium / large organisation

• Significant hands on experience of creating views and writing SQL Server stored procedures

• Knowledge and experience of dimensional database design and deployment experience in a Microsoft BI environment

• Experience of working in a formal team with established working practices on business intelligence / data warehouse projects

• Experience of ETL development using SQL Server 2012 or later

• Experience of Oracle and Oracle Financials reporting tools such as Discoverer

• Thorough understanding of Data Warehouse methods and practices

• A good understanding information security principles and implications of legislation such as GDPR
The role requires the ability to develop strong relationships within the team and developers will be expected to share knowledge and experience and work closely together regularly reviewing each other’s work.

Should you welcome expressing your interest in the opening, please contact the consultant (James Lord) managing the role. James.lord@gempartnership.com