Salary: 40,000 - 70,000 GBP per year Requirements:
* We are looking for a SQL Developer with advanced knowledge of Microsoft SQL Server 2016+ and T-SQL. You should have expertise in performance tuning for T-SQL queries and proficiency with SSRS, SSIS, and Visual Studio (BI Stack). A strong understanding of data warehousing principles and database design is essential, along with experience in database management, capacity planning, and performance optimisation. Advanced Excel skills, including Power Pivot, are also required. We value excellent data analysis and visualisation capabilities, familiarity with N-Tier Architecture, design patterns, and best practices, and experience with unit testing frameworks and dependency injection/inversion of control.
Responsibilities:
* In this role, you will enhance our existing data warehouse to reduce manual tasks and integrate inbound data streams while automating secure data loading processes. You will monitor and oversee incoming and outgoing data submissions to ensure accuracy and completion. Applying business logic to data loads, including de-duplication, error correction, and handling invalid data, will be crucial. You'll improve the preparation and timeliness of data submissions to underwriters and client money transfers and collaborate with teams to streamline reconciliation processes between underwriting and finance. Additionally, you will develop mechanisms to identify and correct data rule breaches to enable continuous improvement, execute database queries, perform analyses, create reports or visualisations, and maintain and update technical documentation.
Technologies:
* Business Intelligence
* Data Warehouse
* SQL
* SSIS
* Visual Studio
More:
This is a fantastic opportunity for a talented SQL Developer to play a pivotal role in maintaining and further developing a robust data warehouse and associated processes built using SQL and SSIS. We are a dynamic organisation offering a fixed-term contract of 6 to 12 months. If you're interested in making a significant impact within our Business Intelligence team, we encourage you to apply!