SQL Data Analyst
DBS Data is currently looking for a SQL Data Analyst to join their data management team. This is an exciting time to join a team with a nice family feel and excellent working environment. The SQL Data Analyst will be working on incoming requirements from new and existing clients.
The SQL Data Analyst will need to be familiar with creating TSQL statements as well as using stored procedures and functions.
You should be a resourceful professional with good problem-solving skills and experience of at least one form of SQL server software.
Responsibilities
Running scripts to extract data from in-house databases including:
- De-duplication and Data cleansing
- File matching
- Verifying criteria
Assist in the handling of clients including but not limited to:
- Receiving internal enquiries
- Researching and analysing data
- Recommending solutions based on analysis
- Running counts on in-house databases
Creating, developing and supporting system processes:
- T-SQL scripts (Microsoft SQL Server)
- SQL objects (tables, views, functions, procedures etc.)
- SSIS packages for importing/exporting data
- C# processes for automation
- Support existing processes, analysing faults, housekeeping, reporting
Required Skills
- T-SQL Scripting
- MS-Office (Especially Excel)
- Programming knowledge (Any e.g. VBA, .NET, C)
- Attention to detail
- Good logical problem-solving skills
- Good communication skills
Desirable Skills
- Microsoft SQL Server T-SQL coding (Procedures/Views/Functions etc)
- C# or other Object-Oriented programming language
Job Type: Full-time
Salary: £20,000.00 to £28,000.00 /year
Experience:
- Sql: 1 year (Preferred)
Education:
- Bachelor’s (Preferred)