Senior Database Developer-EPIC Connect

The Trust has an outstanding reputation for information and has recently implemented a new digital health record, data warehouse and business intelligence solutions.The information team currently support management and clinicians throughout the organisation by providing information and analysis for planning, decision making, quality assurance and improvement. We are further developing our analytical tools and capabilities to rapidly increase the utilisation of anonymised clinical data to support research and maximise the use of clinical data to increase understanding of the disease and treatment. We are looking for motivated experienced developer to join our team, to play a pivotal role supporting the Data Infrastructure Manager and Data Architect to shape, develop, and maintain the Trusts new data ecosystem.You will be educated to degree level and have experience and expertise in developing and maintaining Microsoft based SQL data warehouses and producing technical documentation to support a wide range of users.You must be self-motivated and possess excellent interpersonal skills and the ability to establish effective working relationships with all levels of staff within and external to the organisation.You will need to be able to work on your own initiative, have a strong attention to detail, be a creative problem solver and be able to work under pressure.For more information, please contact Des Campbell, Information Development Manager at ##### duties of the job1.1 The post holder will be an integral member of the Trust's Informatics team, working to transform Trust data into timely accurate information. The primary role is to develop and maintain the corporate data warehouse, taking data from multiple sources. This will require excellent problem-solving skills, along with technical expertise.1.2 The postholder will, in conjunction with the Data Infrastructure Manager/Data Architect, ensure continuous access to data via the corporate data warehouse. Enabling the provision of accurate and timely data that drives several key areas including billing and income, contractual and statutory reporting and planning and analysis.1.3 The postholder will provide expertise regarding data ingestion & integration and will ensure information is presented in a clear comprehensible manner, conforming to Trust informatics standards.About usThe Royal Marsden NHS Foundation Trust is a world-leading cancer centre. Our role is to offer our patients the best cancer care available anywhere in the world, and to continue to make a global contribution to finding better ways of diagnosing and treating cancer. We employ over 4,500 staff in a diverse range of careers including nursing, medical, science, radiography, pharmacy, occupational therapy, finance and administrative services. We have two hospitals - one in Chelsea, London, and one in Sutton, Surrey - as well as a Medical Daycare Unit in Kingston Hospital.At The Royal Marsden, we deal with cancer every day, so we understand how valuable life is. When people entrust their lives to us, they have the right to demand the very best. That's why the pursuit of excellence lies at the heart of everything we do.At the heart of the hospital is our dedicated team. We offer a stimulating and dynamic working environment, a wide range of staff benefits, learning and development opportunities and clear career pathways. There are opportunities to work flexibly across a range of areas and specialities and we welcome flexible working requests from point of hire to support employees work life balance. We are looking for employees who aspire to excellence, share our values and can play a crucial role in our on-going achievements.Job descriptionJob responsibilitiesFor further information on this role, please see the attached detailed Job Description and Person Specification.2.1 Provide specialist technical advice on data warehouse administration and implementation, across the Trust.2.2 Support the Data Infrastructure Manager/Data Architect with the administration of the data warehouse. This includes user right management and being the point of contact for issue resolution.2.3 In conjunction with the Data Infrastructure Manager/Data Architect enhance and extend the RM data model.2.4 Contribute to the design, development and maintenance of data warehouse and Business Intelligence solutions.2.5 Ensure data is processed in accordance with guidelines provided by the Trusts Information Governance and cybersecurity leads.2.6 Maintain processes, documentation, concerning the development and optimisation of complex Extract, Transform & Load (ETL) / Extract, Load & Transform (ELT) data pipelines.2.7 Produce technical documentation to support the administration and management of the corporate data warehouse and Business Intelligence systems, including the Trusts collaborative research environment.2.8 Implement data warehouse changes resulting from changes and upgrades to the Trusts Digital Health Record (DHR) system. This will involve liaising with DHR configuration managers and the Digital Services integration team to ensure data synchronisation.Person SpecificationEducation/QualificationsEssentialEducated to degree level (or equivalent qualification/experience)DesirableMicrosoft certified: Azure Fundamentals Data Fundamentals Database Administrator Designing & implementing DevOps SolutionsEvidence of on-going professional developmentExperienceEssentialSignificant experience in a database developer role in a multi-professional organisationEvidence of having developed complex database systemsEvidence of having administered data warehouses including but not limited to: o SQL Server including SSIS, T-SQL o AzureKnowledge and understanding of modern data analytics platforms including but not limited to: o Python o QlikSenseExperience of presenting complex information so that it is understandable to usersDesirableExperience with NHS Data, Dataflows and integrating data from multiple sourcesAwareness of NHS issues and initiativesSkills Abilities/knowledgeEssentialStrong analytical and problem-solving skills including the ability to select an appropriate methodology when analysing data and developing the data model.Skills in SQL or similar database or programming toolsExcellent Data Analysis skillsPractical experience of PC Applications and good knowledge of MS Office productsAbility to design appropriate visualisations to the data context and audienceReport writing and written presentation skillsEmployer detailsEmployer nameThe Royal Marsden NHS Foundation TrustAddressThe Royal Marsden SuttonSuttonSM2 5PTAny attachments will be accessible after you click to apply.282-OD1245811 Create a job alert and receive personalised job recommendations straight to your inbox.
#J-18808-Ljbffr