London Borough of Newham
Location
Newham, Greater London | United Kingdom
Job description
Job Category : Interims
Location : London Borough of Newham
Hours Per Week : 36.00
Start Date : Immediate Start
Start Time : 09:00
End Time : 17:00
Salary: £316.33 per day
SQL Server Developer required to assist in the continued development of the OneSource Data Warehouse solution.
Skills required are SQL Server coding (T-SQL, procedures, views) and SQL Server Integration Studio (SSIS)
Understanding of Visual Studio (for source code control) and Power BI would be an advantage.
Role will be working remotely, connecting into the OneSource servers via internet connection.
The Data Warehouse is built using SSIS packages which take data from a number of different sources using either SSIS developed packages, or T-SQL insert queries from connected servers. The role is to:
• Add some additional feeds into the data warehouse,
• Or update the existing feeds to add additional information (tables and columns).
• Assist in the coding of new, or the improvement of, core Data Warehouse functions through SQL Server T-SQL procedures and functions
• Assist in the development of SQL Server views for business reporting
• Depending on skill set, may also need to develop a small number of simple Power BI reports for end users
• Carry out data discovery sessions with end users, or on own from a ring fenced data source
Job tags
Salary