BI Engineer

BMC Recruitment Group
Newcastle Upon Tyne, Tyne And Wear
08 Jul 2017
07 Aug 2017
Contract Type
Full Time

The Role:

  • Designing and testing ETL processes using Pentaho Data Integration

  • Designing and performance tuning Enterprise Data Warehouse and cube schema

  • Working with business users to improve analytics toolset

  • Assisting business users with generating self service reports

This role will be responsible for driving forward the Data Warehouse implementation and associated analytics tools which covers:

  • ETL building and maintenance

  • Data warehouse schema design

  • Working with enterprise messaging

  • Data warehouse performance tuning

  • Cube design

The Individual:

  • Thorough understanding of SQL

  • Experience working with ETL processes (any off the shelf solutions)

  • Ability to interpret complex business requirements

    Desirable skills:

  • Experience working with Pentaho

  • Experience tuning SQL Server

  • Demonstrable experience with OLAP concepts & MDX

  • Understanding of DataVault pattern

  • Experience with Near Real Time Reporting

  • Experience in working with Multi-Terabyte Data Warehouse projects

  • Understanding of Agile approaches to project management.

  • Experience with Brokered Messaging