SQL Data Analyst/ SSRS /SSAS

£30k - 40k per year
14 Jul 2017
13 Aug 2017
Contract Type
Full Time
Key Skills: SQL Server / T-SQL / SSRS / SSIS / Data Analysis / Microsoft BI Stack / Business Intelligence / Microsoft SQL query language / MDX

My client based in Southampton, Hampshire are currently seeking a Data Analyst to join their IT team. After attaining a large amount of financial backing and working with a number of brand new clients across the UK. With their initiative bespoke reporting system. The main aim is to now expand into the European market in the next 12-18 months. With this in place bringing in a new DBA to look after their systems has become a critical requirement.

Key responsibilities for the Data Analyst:

* Manage and support the Business Intelligence solution, including management of the data warehouse. Develop front end reporting tools which will allow users to self-serve
* Work with key stakeholders to convert functional specifications into technical specification that deliver the outputs agreed with the report owners
* Automate the production of KPI's, including a monthly corporate scorecard and real-time departmental dashboards
* Create a technical platform which enables the team to model and interpret our data, and make future-looking business decisions using high-value analytical insights
* Provide teams with models to aid targeting and understanding of customer behaviour
* Support and assist data owners with regular audit reports to identify data quality issues. Provide support to clean any errors
* Act as a data migration specialist on any major system project

Key Skills for the Data Analyst:

* Advanced technical knowledge of Microsoft SQL query language
* Experienced in T-SQL (Transact SQL) with the ability to write Stored Procedures
* Experience in SSRS (SQL Server Report Services) ideally with MS Business Intelligence Studio
* Process and manipulate datasets
* Technical expertise regarding data models and database design
* Strong analytical skills with the ability to collect, organise, analyse and disseminate significant amounts of information with attention to detail and accuracy

Desirable Skills

* Exposure to Microsoft BI Stack (SSAS,SSIS and SSRS)
* Exposure to MDX query language (Multidimensional Expressions)

They're looking to pay up to £40,000 for the position, with initial phone interviews lined up from the 17th July.