Java & Data Analysis Engineer - 12 Month FTC

City, London Diabetes UK
SummaryAt 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 2022Please note that all job offers are subject to you providing acceptable evidence of your eligibility to work in the UK. PackageWhat 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 workingDiscounts on gym membershipEmployee 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 insuranceCycle 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.Main ResponsibilitiesThis 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.Ideal CandidateYou 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 preferredImprove ETL ProcessesUnderstanding of cloud architectures, including supporting cloud migration to AzureReview 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/membersKnowledge of CRM systems, ideally Dynamics 365 or SalesforceAttention to detail and motivated by identifying root causes and managing problems efficiently & swiftly to resolutionYou 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.