Senior SQL Developer

Simply Executive

North London — Hertfordshire


19 June 2017

Apply now
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
group projects.

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
and compression.

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.

Educational Background:

Ideally you have a degree in Computer Science, Software Engineering, Information Technology or
Mathematics / Physics related discipline (or equivalent) from a recognised University.

The latest features from Asset Servicing Times
The Financial Conduct Authority’s study of the asset management industry revealed issues around pricing and transparency, and uncovered cracks in some managers’ methodologies. Stephanie Palmer explores the findings
In a climate of regulatory change, cost pressures and cyber threats, the network management industry will be at its strongest if it sticks together. Stephanie Palmer reports from The Network Forum in Warsaw
Join Our Newsletter

Sign up today and never
miss the latest news or an issue again

Subscribe now
Regulation and technology were still the hottest topics in town at Fund Forum International in Berlin. Stephanie Palmer reports
As the active-passive fund debate reaches fever pitch, there is a third option, says Broadridge’s Stephanie Clarke
Asset managers are increasingly relying on data, and the service providers that can manage it, heard attendees at London’s TSAM conference
As the long-standing Barclays Point risk analytics solution winds down to retirement, investment managers have some tricky decisions to make, according to Confluence’s Katie Kiss
Fund administrators could be best off leaving back-office technology upgrades to the professionals, says Kelly Ashe of Pacific Fund Systems
In the search for alpha, appointing an investment fund and a management company can bring myriad benefits, says Eduard von Kymmel of VP Bank
View features section
Country profiles
The latest country profiles from Asset Servicing Times
The Asian market may be improving on the harmonisation front, but the situation is still far from ideal. Experts discuss what there is still left to do
Brazil is hogging the limelight from its South American neighbours. But, although reforms are in full swing, there is still work to be done
Securities Lending Times

Visit our sister site
for all the latest securities lending news and analysis

No nation is an island, and the Polish CSD has post-trade services to cater to all of Central and Eastern Europe, says KDPW’s Iwona Sroka
In a region as geographically, culturally and economically diverse as Asia, funds passports have a tricky road ahead if they’re to redefine the industry
Amid cross-border restrictions and tightened belts, Luxembourg’s kingdom of real estate investment won’t be crumbling any time soon
The Chinese market has taken a knock to its confidence, but despite its size, it is still merely an emerging market, and must take these setbacks in its stride
Rich in sunshine, cork hats and tired clichés, Australia’s funds industry doesn’t buck the trend, boasting record levels of assets under custody
As the Saudi Arabian stock exchange finally opens its doors to foreign investments, the influx from abroad will be in baby steps, not leaps and bounds
View country profiles section
The latest interviews from Asset Servicing Times
When it comes to technology, the payments industry should not be too focused on winning the race, says Mike Laven of Currencycloud
Real Estate Investment Times

Visit our sister site
for all the latest real estate investment news

View interviews section