Global specialist data and analytics business with detailed knowledge of the energy and utilities sector requires a Senior SQL Server Developer to be based in Borehamwood (North London / Hertfordshire).
We are looking for a candidates that have solid SQL development experience with a background in business intelligence.
The role requires the successful candidates to build, maintain, update and optimise elements of our current in house proprietary software package that will require skills in T-SQL stored procedures, SSIS packages and SSRS reports.
Further to this, you will be involved with the design and development of the new version of the software that went into development less than 12 months ago.
In addition to the above we are looking for candidates that can assist in the development of a data warehouse and associated SSAS analytics cubes.
Experience & Knowledge:
Excellent Analytical Skills
Proven ability to act as a mentor to the junior members of the team and lead the development on
SQL Server development environment and associated tools (e.g. Management Studio, SQL Profiler,
Performance Monitor). Legacy system is in SQL 2005, the new SaaS system is in SQL 2014 (soon
migrating to SQL 2016).
T-SQL programming and troubleshooting, query performance optimisation/tuning, primary and foreign
keys, indexes, views, stored procedures, functions.
Understanding of database schema design and concepts, security and user management, partitioning
Design, build and operation of ETL packages using Integration Services (SSIS) and Data
Transformation Services (DTS). Experience processing large data sets.
Documentation of processes.
Creation and support of reports using Reporting Services (SSRS) and Excel.
Design and implementation of Data Warehouses and Dimensional Modelling.
Knowledge in Building and maintaining OLAP cubes with Analysis Services (SSAS). Some MDX
experience is desirable.
Understanding of Software Development Lifecycle and Quality Processes.
Strong problem solving capability.
Any experience with the .NET programming languages and statistical languages such as R would be
desirable but not mandatory.
Ideally you have a degree in Computer Science, Software Engineering, Information Technology or
Mathematics / Physics related discipline (or equivalent) from a recognised University.