Business Intelligence Developer - Nottingham

Would you like to work for an East Midlands professional services business with one of the most impressive office environments in the region? Our client has a company wide agile working policy, this encourages flexibility and collaborative working across the organisation. Then there's the unique style meeting rooms and break out spaces, not to mention the luxurious staff restaurant with a minimum of three chefs serving you the finest food all day, everyday. 

The role itself will play a key part in the central business intelligence team, developing the firm’s business intelligence (BI) solutions including extract transform and load (ETL), data warehousing and analytics. The candidate will be have the skills needed to develop solutions using the Microsoft BI technologies and will have a  proven experience in applying best practices for delivering business critical BI and reporting services.

The business recently completed a large programme of change which included the replacement of the finance solution and a new BI capability. The role presents an exciting opportunity to support a new approach in a rapidly changing market as well as keeping up to date with continuous improvement.

Key Responsibilities: 

• Design, development and maintenance of the enterprise data warehouse including:
  • Definition of dimensions,their attributes, hierarchies and relationships
  • Cube calculations,aggregations,KPIs, partitioning and processing strategy 
  • Implementation of data security
  • Integration with BI analytics tools and reporting
• Where required; design, development and maintenance of:
  • Reporting
  • BI Analysts tools and dashboards
  • Collaborate in the definition, communication,and governance of the data architecture
  • Collaborate with other colleagues in the IT department to deliver solutions which implement the data architecture
  • Active involvement in daily scrums
  • Testing and peer reviews
  • Concise technical documentation
  • Training IT technical and support teams in relevant aspects of new solutions
  • Promoting, encouraging and supporting best practice
• Technical skills Deep knowledge of Microsoft BI technologies including:
  • SSAS
  • SSIS
  • TSQL
  • SSRS
• Experience of:
  • MDX / DAX
  • SQL Server 2016
  • developing and maintaining enterprise grade BI solutions
  • BI systems analysis
• Will have been part of a team which was responsible for the successful delivery of at least one major BI solution
• Proven ability to deliver projects on time, with strong organizational, time and task management skills
• A natural enthusiasm for technology and the ability to excite and engage colleagues about BI
• Good knowledge of the principles and best practice in BI development