Data Engineer

  • Job type

  • Location

  • Working Pattern

  • Specialism

    Data & Advanced Analytics
  • Industry

    Government & Public Services
  • Pay

    Up to £41,000 DoE

ICT Data Engineer - GIS and Data Team

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.

Command: DDAT and People Command
Pay Scale: £39,036 - £41,928 per annum
Location: Police Headquarters 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.

What you need to do now

If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.

If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion on your career.

Apply for this job

Talk to Lindsay Bell, the specialist consultant managing this position

Located in Newcastle, 1st Floor, Kelburn House, 7 - 19 Mosley StreetTelephone 07940590995
Click here to access our Privacy Policy, which provides detailed information on how we use and protect your personal information, and your rights in relation to this.