Description
MS SQL BI Developer
CPL Solutions currently have an urgent requirement for a Senior MS SQL BI Developer to work a 6 month contract role. The successful candidate will deliver solutions to the business stakeholders using the Microsoft Business Intelligence stack. S/he must work according to Data Warehouse, Data Mart and ETL best practices using the Microsoft SQL Server toolset.
Key Skills
Expert knowledge of T-SQL and SSMS: additional experience of other relational database technologies (Oracle/DB2/MySQL) will be considered
Ability to write and understand complex SQL queries
Ability to develop stored procedures and routines that perform well on large volumes of data
Excellent knowledge of SQL Agent/Job scheduling
Performance Tuning, eg Index Creation and Optimisation
Good working knowledge of SQL Server Integration Services
Good working knowledge of SQL Reporting Services
Working knowledge of SQL Analysis Services
Unit/System Testing and Data Auditing/Validation
Experience in the full development life cycle of an enterprise data warehouse/mart adhering to star-schema design principles
A systematic approach to development and the ability to work in a fast-paced environment in a small, highly focused team
If you are interested in the position please contact Michael.