Data Engineer

Job description

About FareShare FareShare now operates 21 Regional Centres around the UK. The majority of these are run by local charitable organisations we call our Delivery Partners. This enables us to be a UK-wide organisation yet also think and behave with local concerns at the heart of our actions. We support 10,943 local charities and groups – our Community Food Members and Associates. Over the past year 19,519 tonnes of food were redistributed by FareShare Regional Centres and FareShare Go nationwide, our charity network serves 924,000 people every week. In 2018 our impact was felt in at least 1,960 towns, cities and villages, helping UK charities and community groups avoid costs of more than £33m and delivering over £70m value to the UK taxpayer. Hunger is a growing issue in the UK and while there is surplus food that is otherwise going to waste, we believe that this food should be used to feed people first. Demand far outstrips supply. About FareShare Go FareShare and the Irish social enterprise FoodCloud have been working together since 2016 in a partnership designed to help UK retailers address the issue of edible surplus food they may have within their stores. This innovative partnership, known as FareShare Go, brings together a technology platform and FareShare’s knowledge of the UK charity food redistribution market. Using this App we are connecting charities with edible surplus foods. Initially this scheme has been working with Tesco, with a view to roll this service out to all retailers across the UK & Ireland in the longer term. Since launching the scheme last year we have already connected over 7,500 charities with over 2,700 stores. FareShare’s Strategy & Vision Vision : We have the vision of a UK where “No good food goes to waste”. Mission : To use surplus, fit for consumption, food to feed those who are vulnerable in the UK by supporting front line charitable organisations that tackle the cause and not just the symptoms of food poverty. Our Purpose: We are doers. We are a community. We change lives. Our Values: Passion – for our cause and the challenge that lies ahead Ambition – to go the extra mile and drive the change that must happen Respect – for ourselves, each other, our volunteers, our partners and our beneficiaries Collaboration – it’s only by working with others that we can be stronger Focus – on providing the best service possible so that we deliver and achieve the most for our clients/customers. The Role At FareShare we build relationships with thousands of charities and community groups, and support them with surplus food. When there’s an opportunity to do more, the Information Centre lends a hand to create or improve the tools to do the job. You will help the Information Centre identify time-consuming internal processes and build solutions that are reliable and scalable enough to work across all of FareShare. You listen to and translate needs into high-level technical specifications, design and develop systems and consult with leaders across FareShare to ensure smooth implementations. Whether handling large system rollouts or making small tweaks that make a big difference, you help FareShare improve and work more efficiently. As a Data Engineer, you’ll work within the Information Centre and lead on the creation and development of FareShare’s data pipeline. You’re a knowledgeable architect and proficient data wrangler, with experience in laking and warehousing, ready to enable FareShare’s next step on its journey to data maturity. You will support the Information Centre’s developers and analysts on all data initiatives, fostering confidence in data quality, efficiency in data management and innovation in data usage. FareShare believes that no good food should go to waste, and it is your job within the Information Centre to support a passionate team to achieve this. Whether finding new ways to make data driven decisions, proactively anticipating emergent business needs and creating the tools needed, or reflecting on what we have learnt so far, our team is enabling FareShare to achieve great things through technology. Person Specification Analysis & Leadership Work within the Information Centre to build ambitious solutions for a diverse and rapidly growing team. Work closely with internal product owners to review business requirements, provide analysis, estimation/scope of effort involved and shape the development of FareShare’s Business Intelligence solutions. Collaborate across all teams to prioritise new BI features and fixes. Translate high-level business and user requirements into functional/technical requirements for design and development. Data & Tools Design and build FareShare’s Data Pipeline. Act as the technical expert for all things PowerBI. Skills & Culture Be passionate about the use of the solutions you create, and bring that out in others across the team. Foster positive change, new ways of working when using data across FareShare. Essential Criteria Degree educated in Computer Science, Statistics, Informatics, Information Systems, another quantitative field or equivalent experience Experience developing a report function using Microsoft BI Stack, or other similar, including report creation in Power BI SQL Implementation of Data Warehouse/Lake (star schema) ETL Tools Building and monitoring data pipelines Desirable Criteria Cloud-based data architecture Experience of the end to end process of establishing a data warehouse