Senior BI Developer / SQL Server SSIS / SSRS / Database

Recruiter
I3 Resourcing Limited
Location
London (Greater)
Posted
10 Feb 2018
Closes
15 Feb 2018
Contract Type
Permanent
Hours
Full Time

Senior BI Developer / SQL Server SSIS / SSRS / Database - £60,000-£70,000 basic + benefits, Lloyd's Insurance Market

SQL / OLTP / OLAP / SSIS / SSAS / SDLC / ETL / SQL 2012 / SQL 2016 / CI/CD / TFS/GIT / Microsoft Azure SQL / Agile /

My client is one of the world's leading specialist insurers - a fast growing, modern and highly prestigious London Market Insurer (Lloyds Managing Agent, London Market Syndicate).

Senior level SQL Developer with at least 5 years of commercial experience.

Insurance experience is highly desired!

Must have skills:

  • Expertise in database design and development using OLTP and OLAP systems using MS SQL Server 2008R2 or higher including experience of SSIS and SSAS.

  • Create and maintain database objects such as Tables, Views, Stored Procedures & UDFs to support new product functionality and optimize existing ones for performance.

  • Follow SDLC standards, source-code management, and release-management procedures.

  • Design and implement ETL process using tools such as SSIS.

  • Make datasets available for reporting purposes.

  • Star/snowflake schema design & development.

  • Positive proactive attitude, willing to turn their hand to any problem, and willing to work things out when they fall outside their area of direct expertise.

  • Query tuning to improve performance and reduce complexity/increase supportability.

Nice to have skills:

  • MS-MDS installation & configuration.

  • Low level SQL optimisations such as implementing partitioning schemes, sharding strategies and implementing columnstore Indexes in SQL 2012 - SQL 2016

  • Experience with deploying SQL changes in a repeatable, reliable manner (CI/CD experience a big plus)

  • Experience working with TFS/GIT for source control, deployment / builds, backlog and task management.

  • PowerShell Knowledge

  • SSRS experience especially diagnosing & fixing performance bottlenecks.

  • Experience working with Microsoft Azure SQL

  • Experience working in AGILE teams

Senior BI Developer / SQL Server SSIS / SSRS / Database - £60,000-£70,000 basic + benefits, Lloyd's Insurance Market

SQL / OLTP / OLAP / SSIS / SSAS / SDLC / ETL / SQL 2012 / SQL 2016 / CI/CD / TFS/GIT / Microsoft Azure SQL / Agile /


This job was originally posted as www.jobsite.co.uk/job/960131394

Similar jobs

Similar jobs