Find More Than 10K+
United Kingdom Jobs

Data Warehouse Developer

A leading corporation that positively changes the lives of thousands of people across the UK is searching for a Data Warehouse Developer who has capabilities in Data Warehousing, Dashboard production and Mobile Reporting coupled with internal and external ad-hoc development requests relating to BI requirements. The chosen developer will have 3-5 years’ recent experience in SSAS, SQL Server Model/Warehouse, SQL and SSIS/SSAS/SSRS within an enterprise corporation. Our client is paying a basic salary of £50,000 to £53,000 with remote working (occasional visits to office) in Ashford, Kent with excellent benefits.

This is an exciting role, where you play a crucial part in the digital transformation era leading on the design, development and maintenance of tabular models, APIs, and repositories with version control within GitHub.

Core responsibilities:

Work as part of the BI&A Team to ensure the smooth running of the service, and to project the professional image of the organisation.

Design and develop data warehouses, ETL processes, and data models to meet business requirements.

Develop and maintain database objects such as tables, views, stored procedures, triggers, functions, etc.

Provide technical expertise on the use of database technologies.

Monitor data warehouse performance and suggest improvements when necessary.

Develop technical documents such as design specifications and test plans.

Troubleshoot problems with existing databases/ETL processes.

Analyse source systems to assess data quality issues.

Lead in the creation and maintenance of data warehouse and other data analytical toolsets including the SQL Reporting Services platform (including associated Web Report Repository). Design and maintain data dictionaries, meta data and use best practice methodologies in warehouse design. Supporting and educating others in this area.

Develop and lead in the creation SAAS Tabular models and Kimball Data Warehouse methodology.

Essential skill set:

3-5 years’ experience in Data Warehouse position with SAAS tabular

Kimball Datawarehouse methodology

Expert in SQL Server with reporting services – SSIS, SSRS, SSAS

Strong capabilities in querying data and developing dashboards in Power BI Suite

API Development

Experience of Relational and Multidimensional Database theory and best practice

Two stage remote interview process via MS teams.