BI Developer

  • Permanent
  • Nottingham , United Kingdom
  • £45,000

BI Developer

A national professional services company who champion inclusion and diversity are growing again!

They have several new openings within the wider tech function and now have a BI Developer opening within their growing Data function. The company strive to create meaningful personal and professional development opportunities and offer flexible working in support of a good work-life balance.

We’re looking for BI enthusiasts to develop the company’s business intelligence (BI) solutions, including extract, transform and load (ETL), data warehousing and analytics. You will 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.

What you’ll be doing:

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
  • Concise technical documentation
  • Training IT technical and support teams in relevant aspects of new solutions
  • Promoting, encouraging and supporting best practice

What you can bring:

Deep knowledge of Microsoft BI technologies including:

  • MDX
  • SSAS
  • SSIS
  • TSQL
  • SSRS
  • SQL Server 2016 / 2019
  • Developing and maintaining enterprise grade BI solutions
  • BI systems analysis
  • Proven ability to deliver projects on time, with strong organisational, time and task management skills
  • Good knowledge of the principles and best practice in BI development

Desirable experience includes:

  • BI application architecture
  • The data vault (DV2.0) data architecture paradigm
  • Business intelligence mark-up language (BIML)
  • BIML Flex
  • Visual Studio Team Services
  • Using Visual Studio database projects to manage source control of data assets
  • Working as part of an agile development team (SCRUM)
  • Power BI
  • Master data management/ Master Data Services
  • Continuous integration
  • Knowledge of design patterns
  • Exposure to Microsoft Azure

It would be great if you could bring further skills and experience in:

  • Actively collaborates with others, working towards a shared goal
  • Sound analytical mind with the capability to articulate sometimes complex technical concepts
  • Ability to manage their own time to ensure delivery of projects within defined timescales
  • A flexible approach, able to cope with several projects at any one time
  • Commitment to learning new technologies
  • Willing to ask questions and share knowledge
  • Willing to assist colleagues and take a proactive approach to solving problems
  • A natural enthusiasm for technology

This is an excellent time to get on board with an industry leader who offer bespoke development plans for each individual that joins.