Senior Data Engineer - JRN 20773
 

Location: Base Location as required within the Force area including Home Working

The Role:

Northumbria Police is entering an exciting new era of technology led change in which data and information play a key role and older technology is being retired in favour of newer, more advanced solutions.  This includes the introduction of a new suite of key operational systems to manage Command & Control, Crime, Intelligence, Case and Custody that will replace the Force’s current solution.     

We are looking to recruit a Senior Data Engineer who can not only provide effective updated data solutions but can equally understand the impact of a data failure to the business and support the user through the experience to its resolution.

You will work with end users, Technology Partners and Enterprise Architects alike, to fully understand the challenges faced by the business and appreciate Force data requirements with a view to crafting innovative and effective solutions to meet those challenges.  Alongside existing system support you will enable and deliver a new data platform which requires proven experience of replication/change data capture and delivery of orchestrated solutions from source to data warehouse. 

You will be required to translate business requirements into well designed conceptual, logical and physical model data structures as well as performing the Extract Transform and Load (ETL) process of data integration ensuring a quality product is delivered.

Your solutions should be simple to operate, easy to fix and hard to break given the data and information solutions that you will deliver and support are critical to the Policing service and when they don’t perform as expected, this can be incredibly stressful for the end user. 

You will be able to provide input to the data strategy with a keen interest in future innovation seeking the opportunity to work with and support Business Intelligence and Data Science areas.
 
In return for your dedication and experience, we offer 23 days’ leave, excluding bank holidays, increasing to 28 days for 5 years+ service.  We support our people inside and out of work – offering a very competitive pension scheme, childcare vouchers, and discounts on shopping and eating out thanks to the Blue Light Card. And to take care of your physical and mental well-being, we’ve invested in trained mental health first aiders on-site, an employee advice service and access to gyms in some stations.  

What will I be doing?
• You are responsible for design and implementation of data solutions that meet standards and embedding reusable metadata and maintaining support processes.
You will deliver data solutions that support Extract, Transform and Load (ETL) processes.
You will ensure data integrity and quality through effective testing of your data solutions and through the affective use of policy and procedure, standards, frameworks and tools.

What do I need?
• Proven data analysis and delivery experience in data integration including in a data warehouse environment and in expert in SQL while using ETL technology e.g. SSIS, T-SQL, ODI, PL/SQL
Proven experience of relational and dimensional design and modelling
Proven experience of relational data base technologies for SQL Server or Oracle
Experience of handling multiple data types beyond traditional RDMS, CDC and file types with knowledge and experience of at least some areas of NoSQL, JSON, API, Python, Cloud and data lake data integration
Knowledge of data interoperability and Integration frameworks and best practice 
Knowledge of Qlik Replicate, Compose and Sense is highly desirable
Experience of orchestration, logging, monitoring and alerting solutions
Experience of meta-data management
Experience of data quality management
Experience of master data management
Experience of corporate and regulatory compliance
Knowledge of reference data management
Knowledge of data mining models and statistical techniques
Knowledge of data life-cycle management
Knowledge of Ethical Standards Framework
Experience of using an ITSM tool
Proficient communication skills to bridge the gap between technical and business language to ensure shared understanding and effective solution delivery;
A degree, HND or equivalent qualification, and/or have significant relevant experience.

For further information please see the role profile

Vetting level: Recruitment Vetting (RV) 
Applicants must be a resident of the UK for a minimum period of 3 years to ensure vetting checks can be successfully performed.  A job offer will be dependent upon vetting clearance, medical information and references. 

Northumbria Police are currently undertaking a role and reward project in respect of all police staff posts. For further information please contact the Talent Acquisition Team
 
If you have any queries with regard to the application process please contact the Talent Acquisition Team by email at careers@northumbria.pnn.police.uk
 
All staff including those appointed on fixed term contracts must successfully complete their probationary period before they are eligible to apply for a Northumbria Police vacancy.

Vacancy Contact:
To discuss the position in more detail please contact the People Acquisition team by email at careers@northumbria.pnn.police.uk. 

Northumbria Police fully supports a policy of equal opportunities and we welcome applications from suitably qualified people from all sections of the community, regardless of age, disability, gender reassignment, marriage and civil partnership, pregnancy and maternity, race, religion or belief, sex and sexual orientation. Appointments are based on merit alone

Vacancy Type
Police Staff
Rank/Grade
Grade I
Area Command/Department
ICT Department
Location
Forcewide
Hours
Full Time
Salary Range
£37,134 to £40,662
 
Location: Base Location as required within the Force area including Home Working

The Role:

Northumbria Police is entering an exciting new era of technology led change in which data and information play a key role and older technology is being retired in favour of newer, more advanced solutions.  This includes the introduction of a new suite of key operational systems to manage Command & Control, Crime, Intelligence, Case and Custody that will replace the Force’s current solution.     

We are looking to recruit a Senior Data Engineer who can not only provide effective updated data solutions but can equally understand the impact of a data failure to the business and support the user through the experience to its resolution.

You will work with end users, Technology Partners and Enterprise Architects alike, to fully understand the challenges faced by the business and appreciate Force data requirements with a view to crafting innovative and effective solutions to meet those challenges.  Alongside existing system support you will enable and deliver a new data platform which requires proven experience of replication/change data capture and delivery of orchestrated solutions from source to data warehouse. 

You will be required to translate business requirements into well designed conceptual, logical and physical model data structures as well as performing the Extract Transform and Load (ETL) process of data integration ensuring a quality product is delivered.

Your solutions should be simple to operate, easy to fix and hard to break given the data and information solutions that you will deliver and support are critical to the Policing service and when they don’t perform as expected, this can be incredibly stressful for the end user. 

You will be able to provide input to the data strategy with a keen interest in future innovation seeking the opportunity to work with and support Business Intelligence and Data Science areas.
 
In return for your dedication and experience, we offer 23 days’ leave, excluding bank holidays, increasing to 28 days for 5 years+ service.  We support our people inside and out of work – offering a very competitive pension scheme, childcare vouchers, and discounts on shopping and eating out thanks to the Blue Light Card. And to take care of your physical and mental well-being, we’ve invested in trained mental health first aiders on-site, an employee advice service and access to gyms in some stations.  

What will I be doing?
• You are responsible for design and implementation of data solutions that meet standards and embedding reusable metadata and maintaining support processes.
You will deliver data solutions that support Extract, Transform and Load (ETL) processes.
You will ensure data integrity and quality through effective testing of your data solutions and through the affective use of policy and procedure, standards, frameworks and tools.

What do I need?
• Proven data analysis and delivery experience in data integration including in a data warehouse environment and in expert in SQL while using ETL technology e.g. SSIS, T-SQL, ODI, PL/SQL
Proven experience of relational and dimensional design and modelling
Proven experience of relational data base technologies for SQL Server or Oracle
Experience of handling multiple data types beyond traditional RDMS, CDC and file types with knowledge and experience of at least some areas of NoSQL, JSON, API, Python, Cloud and data lake data integration
Knowledge of data interoperability and Integration frameworks and best practice 
Knowledge of Qlik Replicate, Compose and Sense is highly desirable
Experience of orchestration, logging, monitoring and alerting solutions
Experience of meta-data management
Experience of data quality management
Experience of master data management
Experience of corporate and regulatory compliance
Knowledge of reference data management
Knowledge of data mining models and statistical techniques
Knowledge of data life-cycle management
Knowledge of Ethical Standards Framework
Experience of using an ITSM tool
Proficient communication skills to bridge the gap between technical and business language to ensure shared understanding and effective solution delivery;
A degree, HND or equivalent qualification, and/or have significant relevant experience.

For further information please see the role profile

Vetting level: Recruitment Vetting (RV) 
Applicants must be a resident of the UK for a minimum period of 3 years to ensure vetting checks can be successfully performed.  A job offer will be dependent upon vetting clearance, medical information and references. 

Northumbria Police are currently undertaking a role and reward project in respect of all police staff posts. For further information please contact the Talent Acquisition Team
 
If you have any queries with regard to the application process please contact the Talent Acquisition Team by email at careers@northumbria.pnn.police.uk
 
All staff including those appointed on fixed term contracts must successfully complete their probationary period before they are eligible to apply for a Northumbria Police vacancy.

Vacancy Contact:
To discuss the position in more detail please contact the People Acquisition team by email at careers@northumbria.pnn.police.uk. 

Northumbria Police fully supports a policy of equal opportunities and we welcome applications from suitably qualified people from all sections of the community, regardless of age, disability, gender reassignment, marriage and civil partnership, pregnancy and maternity, race, religion or belief, sex and sexual orientation. Appointments are based on merit alone