BI Engineer

Recruiter
BMC Recruitment Group Ltd
Location
Newcastle upon Tyne
Salary
£30000 - £40000/annum
Posted
07 Jul 2017
Closes
06 Aug 2017
Contract Type
Permanent
Hours
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