• Location: Portsmouth, England
  • Salary: £45000 - £50000 per annum + Bonus
  • Technology: Microsoft BI Jobs
  • Job Type: Permanent
  • Date Posted: 5th Jun, 2019
  • Reference: 050619da

SQL Developer / DBA - Portsmouth - £50k

A growing financial organisation in the Portsmouth area is looking to recruit a SQL Developer / DBA to join their small IT team focused on developing and upgrading their data warehouse, assisting in the company-wide roll-out of Power BI, and assisting in plans to migrate to MS Azure.

The Role

The main focus of this role is to be responsible for the development and maintenance of the data warehouse. You will ensure that the business needs are met by supporting the company model built around Data Science, people, and technology.

You will be responsible for ensuring the integrity, security and recoverability of the data warehouse whilst supporting operational teams in implementing new systems from a reporting perspective. As the data warehouse environment evolves you will be required to document the data structure and processes which are utilised within the data warehouse. You will also support the wider BI team in ad hoc data analysis.

This role is varied and requires somebody who will be ready to hit the ground running from day one. Your responsibilities will include:

  • Maintenance of the data warehouse.

  • Data warehouse development.

  • Development of SSIS packages.

  • Developing and maintaining SSAS reporting cubes.

  • Creation of technical documentation.

  • Creating reports in Power BI.

  • Ad hoc data analysis.

The Company

This company is a financial services organisation currently undergoing a digital transformation and has a big focus on ensuring that they are up to date with the latest technology. They are currently working with Power BI and have a view to migrate their existing on-premise data warehouse to MS Azure in the very near future. As such, this role offers the opportunity to work with the latest technology and develop your skill-set.


To be a good fit for this role you should be hardworking and ready to take on a challenge. As you will work as part of a small team you should be confident working both closely with colleagues and independently. You should have the following technical skills:

  • Very experienced maintaining/building data warehouses.

  • Very experienced with SQL Server plus T-SQL.

  • Strong experience with SSIS.

  • Experience working with SSRS.

  • Experience developing or maintaining SSAS reporting cubes.

  • Power BI or MS Azure exposure.

If you think that you would be a good fit for this role then apply today - Interviews are taking place next week! Submit your CV or contact David Airey on 0191 338 7508 or at d.airey@nigelfrank.com.