Senior Data Engineer

This job has now expired please search on the home page to find live IT Jobs.

Reporting to the Data Engineering Manager the post holder will be responsible for the management and ongoing development of the organisations data assets including the data warehouse, the data visualisation and development tools and the management of data quality.Client DetailsNHS Resolution is an arm's-length body of the Department of Health and Social Care. We provide expertise to the NHS on resolving concerns and disputes fairly, sharing learning for improvement and preserving resources for patient care. We are currently going through an exciting IT transformation led by the organisation's Chief Information Officer. The Digital, Data and Technology Directorate, (DDaT) is an exciting high performing function with a challenging programme of work and a department structure aimed at progression, development and high operational and strategic outputs. As a result we are looking for talented DDaT professionals to join us on this journey. DescriptionManagement of the Business Intelligence infrastructure for NHS Resolution including SQL databases, data warehouse and reporting tools.Working with the IT team to plan and manage BI Infrastructure changes and upgrades.Responsibility for the ongoing performance and security of the NHS Resolution's BI Systems.Lead on the development and maintenance of the database systems including the underlying design, ETL processes, data marts, reporting layers and documentation.Management of the definition process for BI standards, guidelines and principles for all BI design and solutions within the organisation and responsibility for ensuring they are implemented.Responsibility to ensure constant data integrity throughout the data landscapeExpert knowledge of the case management systems used within NHS Resolution and the underlying data sets.Review new datasets and data sources and assess implications for improving analytical methods and widening the analytical output of NHS Resolution.Manage the integrity of the data systems in relation to projects including the data warehouse project, the core systems project and other IT infrastructure and business change projects.Ensure thorough documentation of team Standard Operating Procedures and maintain documented library of bespoke analyses and queries to ensure output can be audited and repeated as required.ProfilePlease note - to be considered for this role you must have experience of SQL and SSISSkills & AbilitiesAbility to collate, analyse and interpret extremely complex datasets.Proven ability explain complex analytical methods to non-analytical peopleProven ability to manage multiple stakeholdersAbility to identify underlying problems by analysing information and find effective solutionsAbility to manage a workflow and achieve short deadlines.ExperienceAdvance Level of MS ExcelIntermediate Level of MS Access, Word, Outlook, Visio and SharePointExperience of managing multiple databasesExperience of designing, developing and managing data warehouses or other complex relational databasesExperience of designing, developing and managing ETL ProcessesExperience of using Power BI and creating reports/analyzing data using it.Extensive experience of analysing complex datasets effectively in a variety of settingsExperience of working with and combining data contained within different data sourcesExtensive experience of complex SQL code to include development of scripts, functions and proceduresExperience of using and implementing SSRS and SSISExperience of using and building Azure or other cloud based solutionsExperience of supporting and enabling AI technologiesExperience of working with a range of internal and external stakeholders to better understand their data and reporting requirementsKnowledge & UnderstandingKnowledge and understanding of confidentiality within the workplace (particularly within the NHS)Knowledge and understanding of Equality Act (2010)Knowledge and understanding of Freedom of Information Act (2000)Knowledge and understanding of Data Protection Act/General Data Protection Regulations (2018)In depth specialist knowledge of statistical and information data analysisJob OfferFlexible working with commitment to travel to London or Leeds minimum 1 day a week / 4 days a month will also receive an additional London Weighting of £6890Salary of £38,890- £44,503 (plus London Weighting of £6890).You will be entitled to a large range of benefits to include: NHS pensionsFlexible workingHealth and Social Security Recreational Association (HASSRA)Season ticket loan schemeEye care vouchers for SpecSavers24 hours employee assistance programme from Health Assured (EAP)Joint negotiating committeeHealth service discountsCycle to work schemeVictoria privilege cardSugarman health serviceApplications: To apply for this position, please submit your CV ensuring details of where you meet the essential criteria required for the role are clearly demonstrated. Application deadline is 23:55pm, on 10th August 2021