Data Warehouse & BI Architect

  • Location


  • Sector:


  • Job type:


  • Contact:

    Dominic Wolfe

  • Contact email:

  • Contact phone:


  • Salary high:


  • Salary low:


  • Job ref:


  • Published:

    about 3 years ago

  • Expiry date:


Responsible for the design, development, and delivery of data for an established data warehouse already in operation. Expand the scope of BI reports and cubes by collaborating with the business, increasing the added value of our BI systems across the group.
Maintain the logical and physical Data Models for the Data Warehouse as well as monitor the data accuracy by using data quality rules from a number of different data sources.

Main Resposibilities:
  • Owner of Data warehouse
  • Update and development Sales scorecard
  • Update and development Purchasing Scorecard
  • Owner of Group data Collection
  • Owner Design, maintain business cubes
  • Support Integration of other data sources e.g. Group ERP, CRM
  • Analyse business needs with key users from within the business
  • Support IT Director with running and managing Projects
  • Monitor data Accuracy
Person Specification:
  • Microsoft SQL Database Development / Business Intelligence experience
  • Minimum of 2 years working within a similar industry
  • Expert level SQL Server experience including heavy background with the Microsoft tools SSRS, SSAS, SSIS and Power BI
  • Experience with extracting data from a number of data sources in to one common data warehouse
  • Experience with applying slowly changing dimensions
Solsbury Solutions is an equal opportunities employer.