Lead Integration, SQL and BI Developer

Recruiter
Stott and May
Location
Bath, Somerset
Salary
40000.0000
Posted
08 Jul 2017
Closes
07 Aug 2017
Contract Type
Permanent
Hours
Full Time
Lead Integration, SQL and BI Developer

A Lead Integration, SQL and BI Developer is required by a utilities giant based in Bath, where you will play a key role in supporting the technology team to effectively and continually improve the business software.

As the Lead Integration, SQL and BI Developer you will evaluate and classify data, in order to define and clarify information structures which describe the relationships between real world entities. You will evaluate and classify data, to define and clarify information structures which describe the relationships between real world entities.

* Manage the investigation of corporate data requirements, documenting them according to the required standards utilising the prescribed methods and tools. Plans and manages improvements and maintenance of databases to include new releases and upgrades to ensure best performance for the business.
* Evaluates and recommends new database technologies.
* Develops and contributes towards to delivery of Business Intelligence and Business Discovery solutions

Along with at least 2-3 years' experience working as a Lead Integration, SQL and BI Developer, you will also have the following:

Non-Technical Requirements:
* Relating these to simpler or better understood concepts, models or previous experiences.
* Cross-functional and inter-disciplinary awareness. Understanding the needs, objectives and constraints of those in other disciplines and functions with IS and the wider business.
* Planning and Organisation. Determining a course of action by breaking it down into smaller steps and by planning and resourcing each of these, making allowance for potential problems.
* Data Analysis techniques. Expert in techniques which help in modelling and understanding a business and its operation. Examples, relational data modelling, use case.

Technical Requirements:
* RDBMS used: Microsoft SQL Server (2008R2, 2012, 2014), Postgres (9.1).
* SQL Server Components: Reporting Services, Analysis Services and Integration Services.
* Reporting Tools: Report Builder, Visual Studio and QlikView (version 11).
* Transact-SQL: Complex queries, stored procedures, views and functions.
* Source Control (Microsoft Team Foundation Server) and Visual Source Safe.
* Visual Studio product family (includes BIDS / SQL Data Tools).
* Testing tools, including Microsoft Test Manager.

This position would suit an individual who is looking for a long-term opportunity. This position reports to the Data, Integration and BI Team Leader and is expected to work closely with the other team members across Service Development, and the wider S&NM department.

Send your CV for immediate consideration. Interviews to be held as early as next week.