SQL Analyst

Your new company

This organisation is one of Birmingham's largest and most famous employers with over 7000 staff working in both customer-facing and behind-the-scenes roles.
The core values of this organisation include being curious, dedicated, inclusive, respectful and supportive, and these core values guide how their colleagues treat each other as they serve customers with safety and security as their top priority.

Your new role
Working in a technology team of 15, you will work within the Data team alongside the infrastructure and service delivery team responsible for supporting and maintaining existing data infrastructure. Your role will be to extract data, build reports and create data pipelines.
Other day-to-day tasks will include database administration as well as designing and implementing new pipelines.You will perform standard DBA and IT administration tasks such as Domain Security Administration, Domain User administration, Database Backup/Restore, Transaction Log Management and engage with end-user departments to fully understand and document their data analytics requirements.
Once you have fully understood their requirements, you will translate these into BI solutions, using generic SQL Server and third-party tools (such as SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Azure, AWS) and to integrate them into the business.

What you'll need to succeed
The successful applicant will need at least 3 years practical experience in an IT environment carrying out the administration of SQL databases in a commercial environment.
Creation of SQL Jobs, Stored Procedures, Web Services and other automation mechanisms and building data warehouses and multidimensional cubes.
You will ideally hold a degree qualification within a technology-related field, but this is not essential if you can demonstrate strong SQL skills along with the ability to manipulate complex data.
Detailed knowledge of Microsoft SQL Server 2017 and above including SSMS, SSRS, SSAS, SSIS, SQL Language, writing database queries, triggers and stored procedures along with experience of distributing results using differing technologies.
Previous experience within a similar role as a data analyst is required, and you may need, at times, to liaise with senior stakeholders and other members of the organisation, so an outgoing and confident personality would fit in well.

What you'll get in return
A competitive salary and good range of benefits are available with this role.
Future career progression on exciting new technology projects is also available as the organisation upgrades its technology systems. Hybrid working of 3 days a week on site is available after your initial probation period. What you need to do now If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now. If this job isn't quite right for you but you are looking for a new position, please contact us for a confidential discussion on your career.

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at (url removed)