Senior BI and Data Warehouse Developer

Job content

Job OverviewAn exciting opportunity exists to join the Business Intelligence and Warehouse Development team, as a Senior BI and Data Warehouse Developer at Somerset Foundation Trust, to support the development and implementation of information system.This role is currently fixed term for 24 months, the role has a central Taunton base location with good access to public transport links and free parking on a first come first serve basis. Flexible working arrangements are available which could include remote working requiring occasional attendance at face to face meetings in Somerset.Working in the BI & Analytics service you will be working in a team of like-minded individuals, supporting the development and delivery of diverse information from across the newly merged organisation.Experience and or knowledge of Acute, Community and Mental Health data would be advantageous but not essential, you will support the business as usual needs, along with delivering the challenges of merging two data warehouse solutions and strategic needs of the service.Experience in Microsoft products (including SQL Server 2012 and upwards, SSIS, Visual Studio) is essential. Experience in using web based reporting tools, like Power BI and Report Builder together with Source Control solutions like TFS would be an advantage. Some knowledge of General Data Protection Regulation, along with designing, developing and implementing systems using the Agile/Scrum approach would be helpful.Main duties of the jobTake a significant role in the development, testing and deployment of the Trust’s BI & Data Warehouse solution.Investigate, diagnose and undertake maintenance development of Data Warehouse and Reporting processes.Testing and deploying BI Solutions.Working for our organisationAs an organisation, the NHS offers a wide range of benefits including flexible working, fantastic pension contributions, market leading annual leave allowance, career progression and regular conversations, not to mention our Blue Light Card and NHS exclusive discounts.The benefits of working in Somerset include the idyllic countryside, with our areas of outstanding beauty and stunning coastlines. You will get to enjoy these perks whilst still only being a stone’s throw away from bustling city centres like Bristol, Bath and Exeter and only two hours away from London.There are excellent educational facilities in the area and, when compared to other regions, house prices are reasonable. You will to experience the best of both in Somerset, the countryside and the cosmopolitan – there is truly something for everyone!If you are successful for interview, you will be required to bring the following with you: Proof of any essential qualifications stated on the Job Description, proof of NHS payslip if coming from another NHS Organisation and Photo ID to prove your identity and Right to Work (More details will follow for successful applicants invited to interview)Our values are simple: Outstanding Care, Working Together, Listening and Leading.BenefitsWith this in mind, we offer a range of colleague benefits includingWe recognise that our colleagues are our most valuable resource, we are proud of the excellent levels of service our Trust provides to our service users and the dedication and conscientious of our colleagues.Excellent annual leave entitlementEnhanced rates of payNHS Pension SchemeFree parking on most of our sitesNHS discountsTraining and developmentFlexible workingPaid registration fees for the 1st year for newly qualified colleaguesFor more information please contact the recruitment team via email: SomersetNHSJobs@SomersetFT.nhs.ukBy submitting your application to NHS Jobs/Trac, you are giving your consent for elements of your application data to be transferred to the NHS Electronic Staff Record (ESR) and other secure, internal NHS Workforce systems in order to support and manage your recruitment and employment within your employing organisation; to be used by Recruitment for purposes of checking your Professional Registration online (where applicable), any previous NHS service details including all electronically held sickness information, via the Inter Authority Transfer process on the national Electronic Staff Record (ESR).These processes are in line with Fair and Lawful processing and with the Data Protection Act (2018) standards especially those in relation to your personal or sensitive personal data ( sensitive personal data is defined as any declared physical or mental health conditions, racial or ethnic origin, sexual orientation, trade union membership, political opinion, religious beliefs). Other principles under Data Protection will be observed such as use of data for specific, defined purposes, and use of data that is relevant and not excessive whilst practicing data accuracy and security of all held personal identifiable information (PII).Our trust has been awarded HSJ Mental Health Trust of the Year for 2021, This award follows a busy time for Somerset FT, now in its second year as a trust providing mental health and learning disability services, community and acute hospital services following a merger in April 2020. For more information on this fantastic award, please click herePlease Note: Our Trust is undergoing a merger to enable Yeovil Hospital NHS Foundation Trust and Somerset NHS Foundation Trust to become one combined organisation in April 2023. If you are successful in securing employment with the Trust we wanted to make you aware of this proposed merger. If this merger is confirmed, your employment will continue as part of the newly formed Trust.