Data Engineer

Hays Recruitment are currently working with a local public sector organisation to recruit for a Data Engineer.
All candidates should make sure to read the following job description and information carefully before applying.
Job Summary
A data engineer develops and constructs data products and services and integrates them into systems and business processes. In this role, you will be expected to use your knowledge of technology, user needs and business goals to frame problems and set priorities, while working within the parameters of the Departments Service Level Agreements, the Service Catalogue and ITIL. This is a full-time role working 37 hours per week, Monday to Friday. The flexible working hours’ scheme applies to this post.
Pay Scale: £39,036 - £41,928 per annum
Location: Durham and remote working
Responsible to: GIS and Data Team Leader
Main Duties
Implement data flows to connect operational systems, data for analytics and business intelligence (BI) systems.
Document any changes to data architecture.
Document source-to-target mappings.
Re-engineer manual data flows to enable scaling and repeatable use.
Support the build of data streaming systems.
Write ETL / ELT scripts and code to make sure the process performs optimally.
Develop data models to support self-service business intelligence reporting that can be re-used to enforce data standards and quality.
Build accessible data for analysis.
Recognise opportunities to re-use existing data flows.
Lead the build of data streaming systems.
Lead work on database management
Define and implement database architectures that meet business requirements for data availability within budgetary constraints.
Support Geographical Information System (GIS) and the visualisation of data to aid organisational and operational needs.
Provide third line support of incidents and problems through systematic investigation and root cause analysis. To determine options for remediation and apply these accordingly.
Responsibilities and Skills
Communication skills (data). You know about the need to translate technical concepts into non-technical language and understand what communication is required for internal and external stakeholders.
Data analysis and synthesis. You know how to undertake data profiling and source system analysis and can present clear insights to colleagues to support the end use of the data.
Data development process. You can design, build and test data products based on feeds from multiple systems using a range of different storage technologies and/or access methods. You know how to create repeatable and reusable products.
Data innovation. You know about opportunities for innovation with new tools and the use of data.
Data integration design. You can deliver data solutions in accordance with agreed organisational standards that ensure services are resilient, scalable and future-proof.
Data modelling. You understand the concepts and principles of data modelling and can produce, maintain, and update relevant data models for specific business needs. You know how to reverse-engineer data models from a live system.
Metadata management. You can work with metadata repositories to complete complex tasks such as data and systems integration impact analysis. You know how to maintain a repository to ensure information remains accurate and up to date.
Problem resolution (data). You know about the types of problems in databases, data processes, data products and services.
Programming and build (data engineering). You can design, code, test, correct and document simple programs or scripts under the direction of others.
Technical understanding (data engineering). You understand core technical concepts related to the role and can apply them with guidance.
Testing. You can execute test scripts. You understand the role of testing and how it works.
To support and maintain the Force Geographical Information System (GIS) through a full spectrum of GIS activities.
To undertake Continuing Professional Development (CPD) activities such as instructor-led-training, e-learning and workshops in order to keep abreast of new technologies so that they can be implemented within force.
Person Specification
The successful application should possess the following:
A relevant degree or equivalent industry recognised qualification
At least 3 years of professional experience across a variety of software applications
At least 3 years previous technical experience in a client server environment preferably using Microsoft technologies, and experience of using Visual Studio and source control software
Enhanced literacy skills, e.g. composing original letters, statements or writing minutes.
Enhanced computer/keyboard skills, e.g. the ability to input/retrieve information from spreadsheets/database systems, where accuracy is important, but speed is not a key demand.
Advanced numerical skills, e.g. the use of complex statistical and/or algebraic formulae, forecasting, use of alternative number systems
Able to work under pressure to meet specific deadlines whilst ensuring attention to detail.
Able to work on one's own initiative as well as part of a team.