SQL Developer

 A Reading based claims management firm are looking for an SQL Developer to join the team. You will report to the Development Team Manager and will help to develop and support core business systems. You will develop complex ETL solutions for data integration, data migration and data ETL processes, manage and expand current ETL framework for enhanced functionality and expanded sourcing, carry out data analysis to understand source data, develop SSIS packages, code complex T-SQL routines and set up SQL server jobs, develop and execute relevant test plans and SQL processes, T-SQL query performance tuning and optimisation, identify and test for bugs and bottlenecks in ETL solutions and provide third line support for existing ETL solution systems, fault finding, troubleshooting and maintenance.

The SQL Server position essential Skills:

  • Experienced on the development and maintenance of Microsoft SQL Server 2012 (or above) ETL solutions
  • Understanding of Relational Database schemas and Data Warehouse fundamentals.
  • Very strong T-SQL programming, Stored Procedures, Views, Triggers, ETL, SSIS capabilities
  • Solid knowledge and development experience in ETL with T-SQL stored procedures
  • Solid knowledge and development experience in ETL with Microsoft SSIS packages
  • Excellent oral and written communication skills
  • Detail-orientated, good organization, comprehensive logical analysis

This additional experience for the SQL Server role is not necessary but would be advantageous:

  • Report Development - SSRS
  • Data Visualisation – Power BI
  • Knowledge of multidimensional and tabular cube models with MDX\DAX programming
  • Experience with Cluster, Always-On Availability
  • Experience of SAP Business Objects xi3/4

The salary is £40-50k + excellent benefits