Our client, based in Guildford, is looking for an experienced SQL DBA / Business Intelligence Developer.
Business Intelligence Development, Database Management and Administration.
Design and Development of Data Warehouse and associated ETL processes, cubes and dashboards.
Work with stakeholders to define reporting requirements and translate them into dimensional models.
Troubleshooting SQL errors/issues on Production and Development Environments.
SQL Server Performance Tuning / Optimisation.
Automation of Administrative Tasks utilising T-SQL and PowerShell.
Database Design and Architecture.
Responsible for the security and availability of the SQL Server environment.
Review and improve existing processes, procedures and infrastructure.
Degree in Computing or equivalent desirable.
MCP, MCSA or MCSE in Data / Analytics desirable
Design and development of solutions utilising the Microsoft Business Intelligence Stack (SQL, SSIS, SSAS, SSRS and Power BI).
Kimball data warehousing methodology and dimensional modelling.
SQL Server Administration (performance tuning, optimisation, HA/DR and backups) in versions from 2008 R2 to 2016.
Knowledge of C# ASP.NET MVC web application development to assist in communication with other developers would be beneficial.
Knowledge & Skills:
Microsoft BI Stack - T-SQL, SSIS (with BIML), SSAS (Tabular), SSRS, Power BI and DAX
Power BI Report Server.
SQL Server Administration (performance tuning, optimisation, HA/DR and backups).
Failover Clustering and AlwaysOn Availability Groups.
Microsoft Team Foundation Server.
Agile development (Kanban).
Exposure to other Microsoft software (SharePoint and Dynamics).
Index Recruitment Ltd is acting as an Employment Agency in relation to this vacancy.
If you would like to apply please send your CV together with your salary requirements, notice period and reasons for leaving past and present employment.
"Due to the high volume of applications we currently receive, we are unable to respond to all candidates. If you do not hear from a Consultant within 5 working days unfortunately you have been unsuccessful on this occasion".