BI Developer (BBBH590) Birmingham, England
Salary: | GBP35000 - GBP45000 per annum + Car allowance |
*Some travel around the UK will be required*
Looking for an experienced BI SQL Developer to join the Business System team to design, build and evolve a scalable SQL Server data warehouse.
Responsibilites:
- Design, build and test data tables and support ETLs that organise the data into re-useable data mart tables for consumption
- Recommend and implement data warehouse best practice through a consistent and documented approaches to the design and build of the data warehouse
- Create a repeatable set of processes for analysing, on-boarding and provisioning new data sources in a consistent manner
- Design, build and test data quality rules and enrichment procedures inline with business requirements
- Recommend and implement performance tuning to optimise the data warehouse
- Up-skilling the wider business systems team on SQL Server
Essential:
- SSRS, SSAS, SSIS experience
- Experience of developing and supporting BI applications on SQL Server 2008/2012/2016.
- Excellent knowledge of latest SQL developments
- Excellent knowledge of SQL queries, stored procedures and triggers
- Ability to perform key DBA functions on SQL Server