Data Engineer

IHG ANA Hotels Group Japan; North East; On-site; GBP 40,000 - 44,000; Full time

Job description

Salary: SO2 £40,893 - £43,920 per annum

Location: Police Headquarters, Aykley Heads

Hours/Contract: 37 hours per week

Closing Date: Friday 21st March 2025, 5pm

The Role

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.

What Youll Do

• 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 that 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.
• 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.
• Scope and commission third party solutions though activities such as; producing requirements documents, responding to technical tender queries, scoring tenders, installations and maintenance.
• Provide third line support of incidents and problems through systematic investigation and root cause analysis. To determine options for remediation and apply these accordingly.

What Youll Bring

• A relevant degree or equivalent industry recognised qualification.
• At least 3 years professional experience across a variety of software applications.
• At least 3 years previous technical experience in a client server environment preferably using Microsoft technologies.
• To possess a full, current driving licence, or access to a means of mobility support.

If you hold a higher qualification than those required above or minimum 5 years relevant experience, please evidence this on your application and it will be reviewed by our recruitment team.

How To Apply

Click Apply Below

Further information

Any offer of employment will be subject to appropriate vetting checks which will be maintained/updated throughout the period of service.

Applicants must have been a UK resident for at least three years prior to the date of application.

If applicants have not been a resident in the UK for at least three years and can provide a VERIFIABLE certificate from the police of any country where they have taken temporary residence. The certificate must indicate that they have not been convicted of any offence whilst in that country or involved in any investigation by a Law Enforcement Agency.

Any tattoos deemed to be obscene, or advocates sexual, racial, ethnic, or religious discrimination, by written word or design is prohibited and the presence of such a tattoo would preclude an applicant from passing the recruitment process for employment with the Constabulary.

Please note: some documents may not currently be suited for use with assistive technology. If you require information in an alternative format, please contact us.