- Sorry, this job is no longer available! -

Data Support Analyst - SQL SSRS SSIS - Famous Institution

London - London

£35,000 - £42,000   10% Pension + Hols + more

Data Support Analyst - SQL Server, SSRS, SSIS - Famous London Arts Institution

A world-renowned arts institution based in South Kensington is looking for a SQL/SSRS/SSIS Data Support specialist to join an IT department of circa 20 staff. The environment is large scale; 3,000 devices and 1,200 end users.

Purpose of job
The role will be responsible primarily for the development of SQL reporting using a combination of tools including SQL Reporting Services (SSRS), SQL Service Integration Services (SSIS), Power BI and more. The key driver for this role is our client's Microsoft Dynamics CRM platform. Understanding and reporting against the data in that system is critical to the driving of revenue.

You will use your SQL knowledge to build report, transform data and integrate data with other systems. You will need to work also as a business analyst to capture requirements and translate those requirements into viable action plans. You will also need to understand how to migrate data from one system to another as our client is actively consolidating systems to provide more unified customer experiences and reporting capabilities.

Other areas of focus will be assisting with current manual data manipulation and finding more automated solutions for this. This will need an ability to interact with business users to get requirements and to convert them into technical solutions. You will work together with the DBA to find solutions to data reporting for many areas of the business butwill work primarily with the IT and CRM teams.

In the longer term, you will receive training in Microsoft Dynamics CRM and take on greater responsibilities of data management and workflow development within that product.

Main tasks
* Transform and migrate data using T-SQL scripting, SSIS and other SQL tools
* Perform the role of Business Analyst to capture requirements, build use cases and prepare project justification documents
* To identify and resolve potential data integrity issues
* Present data from various systems in custom portals delivered via web, SharePoint or SSRS
* Create and maintain SSRS reports
* Develop PowerShell and other scripts for data gathering and manipulation
* Liaise with technical support departments, both internally and externally, in order to implement services and troubleshoot access issues
* Understand and comply with the IT organisation requirements, processes, procedures and policies

Essential requirements
* SQL Server 2008-2016 development experience (including ETL using SSIS and SSRS)
* Experience integrating and manipulating data using SQL and other reporting tools
* Ability to demonstrate initiative and innovation and to complete projects effectively
* Good communication skills including an ability to explain concepts, ideas and technologies in a clear and understandable manner to technical and non-technical persons
* Ability to produce clear written material
* Strong analysis and decision-making skills

Desirable Requirements
* Experience developing PowerShell scripts for data collection and manipulation
* Use of Microsoft PowerBI to deliver data in an easy to read format
* Developing reports using Jet Enterprise (Jet Analytics) tools
* Data management in Microsoft Dynamics CRM
* Using Scribe Insight for data integration tasks
* PHP, Python, PowerShell, Java, Ruby
* Working knowledge of ITIL processes


  • 28 days holiday
  • 10% Co. Pension - no personal contrib needed
  • Season Ticket Loan
  • Cycle to Work Scheme
  • Heavily subsidised Staff Canteen
  • 36 Working Hour Week with a degree of flex

This is an amazing company to work for and they are looking for someone to start ASAP!

Data Support Analyst - SQL Server, SSRS, SSIS - Famous London Arts Institution

Data Analyst SSRS SSIS SQL ServerSQL

Updated: Thu May 23 2019 01:30:00 GMT+0000 (Coordinated Universal Time)