SQL Data Analyst Permanent

F4P; Welwyn Garden City; On-site; GBP 40,000 - 60,000; Full time

Job summary

A technology solutions provider in the UK is seeking a data analyst with strong expertise in SQL Server programming to assist clients with data analysis and reporting. The successful candidate will liaise with clients, migrate data, and provide ongoing insights to improve reporting. Strong analytical skills and proficiency in data management are essential for this role, which involves client interactions and project meetings at the Surrey office. Competitive compensation and an engaging work environment are offered.

Qualifications

• Excellent knowledge of Microsoft SQL Server programming including query, stored procedure, and function development.
• Strong analytical and presentation skills.
• Understanding of other RDBMS reporting and analytical tools is beneficial.

Responsibilities

• Assist clients in analysis and reporting of data from various systems.
• Provide insights into customer’s data.
• Migrate data and manage data imports.

Skills

Microsoft SQL Server programming (T-SQL)

SQL Reporting Services

SQL Analysis Services

SQL Integration Services

Advanced Microsoft Excel

Data conversion / data migration

PowerBI

Tools

Microsoft .Net Visual Basic

C#

Visual Basic for Applications

Job description

What do you need?

• An excellent knowledge of Microsoft SQL Server programming (T‑SQL) including excellent query, stored procedure, view and function development skills
• A complete understanding of SQL Reporting Services
• Strong knowledge of other SQL Analysis Services and SQL Integration Services
• Advanced Microsoft Excel
• Strong analytical and presentation skills
• Demonstrate skills in data conversion / data migration
• Knowledge of other RDBMS reporting and analytical tools would be useful
• Any understanding of Microsoft .Net Visual Basic or C# and Visual Basic for Applications would be useful
• An understanding of PowerBI

What will you be doing?

• The role will involve helping client in the analysis and reporting of data from an application, data warehouse and the client’s own database systems.
• Provide ongoing reporting and insight into the customer’s data.
• Assistance in other tasks such as report and system training, writing and managing data imports
• Migrating data will also form part of this strong client facing role.
• You’ll join the product team a number of times per month at Surrey based offices for project meetings, training, and events.
• Identify and suggest improvements in data collection to improve data reporting