Technical Consultant (ETL / SSIS) - Working from Home

£40 - 50K + £3.9K car allowance + Employee Benefits

Technical Consultant (ETL / SSIS) £40 – 50K (DOE) + £3.9K car allowance + Employee Benefits Location: Working from Home (with very occasional travel)   Summary   Our Clients leading Housing Management System meets a whole range of housing providers needs to connect people, data and property information.  We are seeking a Technical Consultant to join a busy and highly collaborative team who are defining and developing the data implementation processes for Customers who might be either onboarding the software, taking delivery of new modules, or merging existing systems etc.   This is a great time to join the team: The business has 2 new software modules being launched and the team are heavily involved in helping shape the new processes  The team operate a culture of continuous improvement, ideas are always welcome Technical training is readily available The team operate an agile approach to working so can offer a flexible working week   About our Client: Our Client is the largest provider of IT Solutions to the Public Sector in the UK. They develop and deliver a broad range of bespoke software solutions that they develop and deliver into Local Government, Central Government and the NHS.    About the role: To act as the Technical Lead on multiple implementations and provide technical support to customers and colleagues during the implementation process, migrating customer data and supporting Customers in the extraction of data from their legacy systems Develop integration solutions using stored procedures and SSIS packages To be responsible for the loading of customer data during the implementation process. Provide prompt feedback to the Project Manager, Technical Consultancy Team Manager regarding any issues arising from consultancy Support and advise other team members. Assist the Technical Consultancy Team Leader in the further development of the technical processes used to deliver projects. To ensure skills and product knowledge stay current and to learn new skills and share knowledge gained with the delivery team. Investigate and develop scripts for data corrections at live customer sites and manage their safe implementation   About You Essential Skills: 3+ years extensive knowledge of Microsoft SQL Server 2012 upwards. Particularly the development of complex Scripts, Views and Stored Procedures Extensive knowledge of SQL Server Integration Services (SSIS) and package creation Knowledge and understanding of the Extract, Transform and Load process (ETL) Good numeric and mathematical skills Strong Customer facing skills Ability to deliver workshops and consultancy to both technical and non-technical audiences. Ability to manage expectations and follow control change control processes. Able to speak with authority as subject matter expert to internal and external audiences Problem solving and fault-finding skills Awareness of SQL coding best practices and ability to peer review code against them   Experience of any of the following technologies would be preferred: MS Azure Blob storage SSRS/ Power BI, MS Analytics XML, HTML, JSON, CSS, SOAP UI or Web Services    

Job Type : Permanent

Job Role : Technical Imp / ETL

Job Unique ID: JOBID-109

Location Area : Home-Based

Closing Date : Mon, 04 Jul 2022 23:59:59 GMT

Posted By : Chris Jones

apply