Data Engineer

at  Lincolnshire Partnership NHS Foundation Trust

To carry out specific packages of work, with support, involving the design and development of reporting solutions with particular emphasis on T-SQL, and Business Intelligence tools to meet the emerging needs of LPFT. Using T-SQL, complex stored procedures, views to access data in the data warehouse and in EPR front end. To contribute to the planning, creation, implementation, maintenance and development of Master Data Management and linked data sets which are sourced from a variety of information systems. Ensuring Technical Specifications and Documentation is created and maintained.
Contributing to the maintenance of any Master Data Management, linked data sets or other data structures to ensure data is stored efficiently and inline with Information Governance Policy Track down data related issues to their root cause, recommend fixes and be capable of implementing the required changes. Design, code, test and implement efficient and robust database schemas, T- SQL Queries, views, stored procedures as part of Business Intelligence infrastructure development Maintain an awareness of the latest software tools, keeping up to date with technological sources and innovations. Adhere to robust change management procedures, including but not limited to version control, writing of technical guidance and adoption of best practices Liaise with third party IT service to provide support with back up, restoring, and disaster recovery

Please refer the Job description for details