modelling skills in designing data warehouses and datamarts Experience of migrating data from legacy on-prem systems to cloud architectures Knowledge of OLTP and OLAP principles and evidence of building such solutions Evidence of building and managing the evolution of entity relationship models, data dictionaries and ELT/ETL models more »
Aberdeen, Aberdeenshire, Scotland, United Kingdom Hybrid / WFH Options
In Technology Group Limited
All clients must have the relevant documents to work in the UK as sponsorship is not provided. Responsibilities: Databases in Microsoft SQL Server including OLAP-based reporting. Lifecycle management of SQL objects including queries, views, functions, triggers, and stored procedures. Business reporting in Excel and SSRS. Application databases and associated … reporting. Maintenance and development of OLAP reporting and data warehouse and related ETL routines (SSIS/SSAS). Work with the business ensuring all reporting and database needs are met. Database administration including data growth management, backups, indexing, performance tuning etc. Contribution to the execution of month end processing, systems more »