Senior Data Engineer

Job Description

Agile WorkingThe 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 ofkey operational systems to manage Command & Control, Crime, Intelligence, Case and Custody that will replace the Forces 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 dont perform as expected, this can be incredibly stressfulfor 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.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 practiceKnowledge 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.What can you expect from us in return for your dedication

• Fantastic public pension scheme
• Childcare Vouchers
• Excellent discounts on all things from shopping to eating out thanks to the BlueLight Discount Card
• Huge focus on wellbeing, trained mental health first aiders on site, EAP service
• Access to gyms
• Flexible working (to be agreed)

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 projectin respect of all police staff posts. For further information please contact the Talent Acquisition TeamAll 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.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, pregnancyand maternity, race, religion or belief, sex and sexual orientation. Appointments are based on merit alone

Keyskills :
Business IntelligenceData AnalysisETLFrameworksMetadata Management