BI Developer (SQL Stack - SSRS, SSIS, SSAS)

TLP Consultancy Ltd.
Bury St. Edmunds
£27000 - £45000 per annum + package
16 Mar 2017
15 Apr 2017
Contract Type
Full Time
SQL BI Developer
Woolpit, Suffolk (Between Bury St Edmunds and Stowmarket)
£27,000 - £45,000 + package

An opportunity has arisen to work at my client's offices in the historic village of Woolpit in Suffolk.

They are currently recruiting for a Business Intelligence Developer to provide business intelligence design, development, integration and support skills.

Job Purpose

The Business Intelligence Developer will work as part of the Business Intelligence team formed in 2015. They will be primarily responsible for developing SQL Server 2016 Data warehouses, Reporting Services reports, SSIS ETL process and in the future Analysis Services cubes. The candidate will have a deep understanding of Microsoft SQL server and will be experienced at writing complex but efficient queries to build reports and dashboards. Experience in data warehousing and star schemas would be advantageous. The role will include training and mentoring IT developers & business users.

Key Objectives and Responsibilities

Primary Objective:

Design, develop and maintain SQL Server 2016 Data Warehouses including ETL processes using SQL Server 2016 SSIS.
Design and development of Business Intelligence reports.
Data interrogation and analysis to support project team and business users.
Support the controls around data management and warehouse & cube refreshes.
Support the maintenance of the business rules in the Business Intelligence warehouse.
Explore new ways of presenting information and communicating this to the business.
Maintaining all software and database objects in the appropriate source/version control systems and working with colleagues to ensure these are secured adequately.
Maintain System user access and release control in accordance with IT policies.
Ensure the integrity and control of the Business Intelligence system and reports created to ensure compliance to business process.
As part of the Business Intelligence team - support the roll out of business intelligence into new business areas, including carrying out business analysis.

Additional Objectives:

Assisting with the testing and reconciliation of data to multiple source systems.
Support the business through analysis, implementation, UAT and post go live support.
Training of business super users to ensure understanding of the system.
Working with the business to identify opportunities to explore how information can optimise business processes and practices.
Work with the DBA to ensure Business Intelligence developments comply with company standards.
Act as a deputy for the DBA when required.

Knowledge & Experience


Experience with Microsoft SSRS (SQL Server Reporting Services 2016) required, SSIS (SQL Server Integration Services), and SSAS (SQL Server Analysis Services) preferred.
Experience with SQL Server 2014 and SQL Server 2016 with strong emphasis on SQL programming, T-SQL, stored procedures, and performance tuning.
Experience with BI tools, including Microsoft Business Intelligence Development Studio and Microsoft Visual Studio.
Experience designing and building data warehouses.
Able to performance tune queries and databases.
Experience using source control software, and deploying reports and dashboards from Visual Studio.
Strong problem solving and analytical skills.
Excellent verbal and written communication skills.
Data analysis and data mining skills.
Customer service orientated.
Ability to work independently or as part of a team.
Highly organised and self-motivated.

Your skills and knowledge should also include some of the below:

Knowledge of non-Microsoft relational databases [My SQL / Postgres/ Oracle].
Knowledge of non-Microsoft Business Intelligence tools.
Knowledge of SSAS cubes including MDX query language and relational data modelling.
Knowledge of Data Analysis Expressions (DAX).
Knowledge and Experience with report subscriptions (including data driven).
Building web applications with ASP.NET C#.
Knowledge of 'R' - business intelligence programming language.
Understanding of Financial processes.
Knowledge of Microsoft Dynamics AX 2012, or another finance system.
Experience of training software developers and/or end users on business intelligence.

Locations: Woolpit, Bury St Edmunds, Suffolk.

Please send me your CV for an immediate turnaround!

TLP Consultancy Ltd is acting as an Employment Agency in relation to this vacancy.