Datawarehouse Developer

Capita Resourcing
£30000 - £38000/annum
11 Jun 2017
11 Jul 2017
Contract Type
Full Time
Capita IT Resourcing is currently working with an Enterprise Service Provider in their search for a Datawarehouse Developer. Working on an important account, the role will be a member of the team that develops and maintains the Reporting and Business Intelligence solutions for our client. As a Data Warehouse Developer within an Agile Team, the role will be involved for the successful delivery and evolution of our client's solution with the expectation that they'll play a role in increasing the quality of the system.

To be an excellent team player that participates in projects, sprints and work-packages as and when required. Share knowledge through collaboration with peers and other team members.

The Data Warehouse Developer role relies on the candidate having strong experience of Data Warehouse development, Business Intelligence and MI reporting. Exceptional SQL Server development skills and good experience of SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) will be very important to success in the role.


The main responsibilities are detailed below, although the post holder would also be expected to perform any other duties which might reasonably be required:

* Work as part of an agile team to deliver high quality solutions based on the Microsoft stack
* Work with the Business to generate reports and enhance the Business Intelligence Solutions
* Work alongside client stakeholders and business analysts to ensure delivery to client expectations
* Work with Service Management to resolve production issues
* Apply industry best practise within development and associated delivery processes
* Champion new tools and frameworks to improve productivity and software quality
* Input into application design and technical strategy
* Produce clear, relevant and concise implementation and support documentation to support change and project delivery
* Work with team leads and project managers on the delivery of defined project tasks and activities, reporting progress against plan, reporting any risks and issues accordingly

The person who fulfils this role must have a willingness to learn and understand new technologies, with a pragmatic approach to how we can include this within the application. They should be keen to promote the solution to the business, and also be an activist on how new technologies could further our clients ability to delivery to their customers.

Essential Skills and Experience

The role must have the following skills and experience:

* 3+ years' experience in implementing complex solutions in a professional development environment
* Strong design and development skills in the Microsoft SQL Server platform, including SSIS and SSRS
* Strong skills in the T-SQL Language and developing for performance
* Strong experience in developing ETL solutions from complex backend systems
* Strong knowledge in Data Warehouse solutions and Data Architecture
* Strong ability to build relationships with the business to provide fit for purpose solutions
* A proven aptitude for developing high quality solutions
* Strong problem solving skills and ability to adapt to new situations
* Excellent listening, verbal and written communication skills
* A strong customer focussed, pragmatic and motivated individual
* Excellent organisational skills
* Proficient with relevant design principles and development best practice
* Proficient with tools that automate or assist the development process
* Troubleshooting complex software issues including issues in unfamiliar code

Desirable Skills and Experience

It would assist if the role has the following skills and experience:

* A wide exposure to the Microsoft stack, including SSAS, Excel, PowerBI Desktop and SharePoint
* Knowledge in cloud technologies, particularly Office 365, PowerBI Services and Microsoft Azure
* Development skills for the Microsoft Stack, specifically to support Reporting and BI Technologies
* Agile delivery practices (preferably Scrum) and working as part of an Agile team
* Proficient in more than one database technology e.g.) Oracle, MySQL, MS SQL Server
* Knowledge in Continuous Integration and Continuous Deployment (Jenkins/Puppet)
* Exposure to or experience of industry standards (OWASP, ISO 9001)

If you would like to apply for the role, please send me your updated CV for immediate consideration.

Capita IT Resourcing welcome applications from all suitably qualified people regardless of gender, race, disability, age or sexual orientation.

Capita IT Resourcing is a trading name of Capita Resourcing Ltd. Services offered are those of an Employment Agency and Employment Business. Applicants will be required to register with us.

Transfer of information overseas

Your information may be shared with subsidiaries of Capita plc who are involved in carrying out functions related to the services administration including such subsidiaries which are outside the EEA in countries which do not have similar protections in place regarding the information and its use. We shall ensure that any such subsidiary has put in place proper security measures to ensure at least the same level of protection of the personal data as is required under UK data protection legislation