Java & Data Analysis Engineer

Job Introduction

At the heart of our upcoming strategy lies the need to drive changes within our IS department to support our transition to a cloud technology stack that supports our data strategy, and to enhance the way we support new and current information systems. Fundamental to this process is to make identify and implement improvements to better support our data, and systems used for our fundraising, memberships management, beneficiaries, volunteers, and supporter activities.

We have a friendly and inclusive working environment here at Diabetes UK and are proud of our ‘Connected Working’ framework which allows great flexibility in the way that we work. This means that you can balance your working time between home and the office, subject to the needs of your role of course. We do not dictate the number of days you have to attend the office.

Interview Date: week commencing 3 October 2022

Please note that all job offers are subject to you providing acceptable evidence of your eligibility to work in the UK.  You might find the following resources useful:

• To view a full list of accepted documents and the checks employers are required to make click here
• To view guidance on proving your right to work to an employer click here

 If you have any questions, please contact HRAdvice@diabetes.org.uk   

Role Responsibility

This is one of two roles required to work in IS to deliver organisation-wide ELT, data import, master data management, semantic modelling and BI in cloud technologies. This will be done while fostering an entrepreneurial and creative work ethic, and willingness to learn and adapt to emerging technologies. This role will work closely with a Senior Data Developer to support the delivery of robust, consistent integrations, and new technical analytics tools for insight leads in teams across the organisation to be able to build reports and dashboards. In turn we know this will lead to better relationships between Diabetes UK and those who benefit from our services and those dedicated to supporting our cause of working towards a world where Diabetes can do no harm. 

We need your expertise to ensure the integrity of our data, that the value of our data is maximised and to provide excellent technical advice and internal customer service to your colleagues in IT, Engagement & Fundraising, and Customer Care Centre. 

In return, our migration to cloud offers a clear pathway to transfer those skills into the most up-to-date technologies and working practices, so the role requires someone who can master our existing environment and inspire our future.

The Ideal Candidate

You are comfortable working in a busy IS department in a not-for-profit environment and have knowledge of managing data between systems which manage memberships, events and helpline call centres. 

You have at least 2 years’ data engineering experience and are proficient in using SQL (Selects, Stored Procedures, Functions, Views, Permissions), SSIS, SSRS, Azure Active Directory, experienced with Git / Azure DevOps for version control, Visual Studio, VS Code, SSMS, MySQL Workbench, Power BI and comfortable working with VM. Some experience of Azure Synapse and Data factory desirable.

You will be required to:

• Develop API using Object Oriented Languages, exposure to Java 8 is preferred
• Improve ETL Processes
• Understanding of cloud architectures, including supporting cloud migration to Azure
• Review on-premises data warehouse build processes to help build up reporting capabilities (SSIS, SSRS & PowerBI)
• CRM Data/Gap Analysis to ensure that we achieve optimal records for our supporters/members
• Knowledge of CRM systems, ideally Dynamics 365 or Salesforce
• Attention to detail and motivated by identifying root causes and managing problems efficiently & swiftly to resolution

You are eager to learn and work with the new Microsoft Azure data stack and develop your technical skills to support our Data engineers and Developers.

You are a confident member of an IT team having used ITIL and continuous improvement processes for increasing the quality-of-service delivery to our stakeholders. 

Package Description

What we can offer you: 

• Generous annual leave starting at 25 days plus bank holidays 
• A Cash Healthcare Plan (giving you up to £1,500 towards a range of out of pocket health expenses like new glasses, dentist, chiropractor or osteopath appointments) 
• Early finish Friday and flexible working as part of our approach to activity based working
• Discounts on gym membership
• Employee assistance programme to give you support on any issues that come up in life  
• Annual season ticket loan* (on completion of your probation period and if contract is permanent or longer than 12 months)
• Very active social scene including sport teams, gardening and other activities 
• Generous pension provision, life assurance and income protection insurance
• Cycle to work scheme* (eligible for scheme if contract is permanent or longer than 12 months)

*Some benefits aren't available until you've passed your probation period and are dependent on the length of contract.

About the Company

For nearly 5 million people with diabetes in the UK, there’s no day off. At Diabetes UK, we fight day in, day out for better care, treatment and support. We won’t stop until diabetes can do no harm.

With more people than ever living with diabetes and millions more at risk of developing type 2, our work has never been more needed. We make sure they get the care and support needed to live well with diabetes and avoid devastating complications.

We fund critical research, which has led to life-changing discoveries – like the first insulin pen and programmes to put type 2 diabetes into remission. Now, we want to do this for everyone and find a cure.

We can’t do any of this without you. Our staff are passionate and determined about helping everyone affected by diabetes. For over 85 years, they’ve been behind vital policy changes, as well as new treatments and technologies to make living with diabetes easier every day.

But there’s more to do. And you can be part of it.

We’re a really diverse bunch and we recognise and respect your value as an individual. As well as helping people with diabetes, you’ll be part of one of the top 30 Best UK Charities to Work For, and one of the top 75 Best Large Companies in London.

We’re committed to protecting and promoting the welfare of children and adults at risk, and we need our staff and volunteers to support this.

Our vision is a world where diabetes can do no harm. Join us today, and together, we can make that a reality.

To find out more about what we do, check out our website.

Diabetes UK