Data Migration: o Design, develop, and implement SQL scripts as part of the project data migration processes.
O Ensure data integrity and consistency throughout the migration process.
O Cleanse, transform, and load data from the legacy, on-premise housing system (Capita Open Housing) into the on-premise, NEC Housing System that is being implemented.
Responsible for the quality of the design, build, test, implementation and support solutions in MSSQL Server, SSIS and Tableau, packaging and delivering new service offerings developed by the developer or peers is performed in line with all relevant guidelines and data protection regulations.
Design and create objects such as tables, stored procedures and ETL packages using SSIS.
Engage middle manager and peer level staff across the group and promote the appropriate development of business analytics usage within the respectivedepartments.
Venn Group is currently working with an NHS London Trust who are recruiting for a SQL Developer/DBA who is responsible for providing technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long-term perspective on the relationship of database technology to the business opportunities.
Agency Reference Number: J81531
Job Responsibilities
Responsible for the performance, integrity and security of the databases - include planning, development and troubleshooting.
I am currently partnered with a Local Government agency in London on a long-term programme of work & they require a Developer experienced in Data and Analytics solution design and implementation using Agile and equivalent methodologies who will be working as part of a development team whose responsibility is to deliver complex data and BI products.
Along with good knowledge of data schema structures, design and how they can be correctly applied to deliver robust solutions that meet specifications.
Detailed knowledge of ETL, data warehousing, data modelling and experience dealing with big data is expected.