The role:
Base Location as required within the Force area
including Home Working
Fixed Term Contract –
immediate start until End June 2022
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.
To support this, the ICT department would like to recruit a capable, experienced and motivated Data Scientist to support the back record conversion of the data that is to be migrated out of the existing Force operational system into these new technologies.
You will provide advice and direction on the data validation strategy as well as processing data through a test harness to support data quality validation. You will perform root cause analysis into SQL and XML data formatting issues and support the creation of data tables and affiliated quality testing.
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 will define and create low level data structures.
You will work with End Users, Analysts and Developers to fully understand the challenges faced by the data migration process for the Back Record Conversion project and support the data validation and load process through SQL queries and scripts to validate the ETL process.
You will ensure data integrity and quality through effective testing of your data models and through the effective use of policy and procedure, standards, frameworks and tools.
What do I need?
• Strong data analysis experience
• Experience of meta-data management
• Experience of data quality management
• Experience of data modelling, source to target mapping and preparing SQL using mapping documents
• Experience of corporate and regulatory compliance
• Experience of SQL queries and scripting as well as XML data formatting
• Experience of relational data base technologies; e.g. SQL Server
• Experience of relational and multi-dimensional data model design
• Experience of data mining models and statistical techniques
• Knowledge of reference data management
• Knowledge of data life-cycle management
• 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.
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.
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 Stephen Peart, Programme Manager by email at Stephen.Peart.4558@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