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
- 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