Business Intelligence Developer

Allen Lane are delighted to be supporting a local authority based in London in their search for a BI Developer.
Please read the following job description thoroughly to ensure you are the right fit for this role before applying.
The council is expanding its corporate business intelligence and reporting capacity and are recruiting for an experienced warehousing and data management specialist. The department employs Business Objects and Microsoft technologies as key platforms and is in the phase of deploying a master data management capability.
You must have excellent reporting and data warehousing skills and will have the opportunity to train on leading Master Data Management and Microsoft analytical products.
Please note this is not a remote position, it is hybrid with 2 days per week required on-site in London.
You will have the following experience and qualifications.
Excellent proven experience in:
Ability to maintain and develop complex data warehouses
ETL techniques (using SSIS or similar tools)
Handling multiple data sources and reconciling records across systems
Writing complicated functions, procedures and call outs in T-SQL and Procedural T-SQL
Visual Studio or similar development platforms
SQL Server and SQL – Server Management Studio
ORACLE SQL/PL-SQL and Oracle Developer or similar
SSRS
MS Data Quality Services (DQS) or similar
Ability to build reports using dashboards, drill-downs and visualisation techniques
Excellent communication, requirements gathering and business analysis skills
Good functional and UAT testing skills
Hands on usage of PowerBI and knowledge of Business Objects to PowerBI integration
Awareness of:
Azure warehousing and analytics
Business Objects Series 3/4 administration and support facilities or similar
BO universes or similar semantic layers
Building reports in Webi or similar
What you get in return
A salary of £55,000 - £63,684 plus a range of excellent benefits.