Database Analyst Microsoft SQL

Job description
Job Summary: We are seeking a highly skilled Data Base Administrator to join our Analytics team. As a key member of the team, you will be responsible for managing our SQL Server databases, creating and maintaining systems and processes, and ensuring data compliance with GDPR and other relevant regulations.

The ideal candidate will have extensive experience with Microsoft tech stack, including SSIS/SSMS, and passion and aptitude for database development and new technologies. You will also need to demonstrate strong troubleshooting skills, ability to work effectively in a team environment, and good verbal and written communication skills.

Key Responsibilities:
• Managing the Data warehouse predominately using SSIS/T-SQL
• Acting as a gatekeeper maintainer of our data ecosystem
• Creating, developing and maintaining SQL Server systems and processes ensuring optimisation and stability.
• Developing and maintaining SSIS packages for task automation
• Developing and maintaining SQL Server Management Studio, SSRS Reports
• Defining database schema, tables, indexes, views, stored procedures triggers
• Testing database processes and performing bug fixes
• Writing complex SQL scripts from across multiple data sources
• Experience in dealing with Error Handling, Transaction Management and Query optimisation
• Assisting in the migration, optimisation and cleaning of data

Requirements:
• Extensive experience with Microsoft tech stack including SSIS/SSMS
• Passion and aptitude for database development and new technologies, ADF is an advantage
• Enthusiasm about data and the difference it can make
• Wants to take ownership of pieces of work and projects from requirement through to delivery
• Strong troubleshooting skills

Benefits:
• Annual pay reviews
• Town centre location
• Employee Assistance Programme (EAP)
• Progression opportunities
• 2 x Annual bonuses (up to 5% of annual salary based on individual and company performance)
• £350 Refer a friend programme
• Discounts E-Vouchers

Estimated Salary: £42,000 per annum Read more