SecOps Data Engineer

The Home Office works to build a safe, fair and prosperous UK. We achieve this through our work on counter-terrorism, policing, crime, drugs policy, immigration and passports.

Home Office Digital, Data and Technology designs, builds and develops services for the rest of the department and for government. Every year our systems support up to 3 million visa applications, checks on 100 million border crossings, up to 8 million passport applications and deliver 140 million police checks on people, vehicles and property.

SecOps Data Engineers deliver on the data analytics vision for the organisation driven by the requirement to analyse, detect & respond to security threats against the organisation. You will focus on the design and implementation of numerous data flows to connect operational systems, data for analytics and BI systems., As a SecOps Data Engineer, you will identify and deliver new data sources and develop Extract, Transform, Load (ETL) processes. You will also collaborate with the Data Acquisition, Analytics and Infrastructure teams to deliver the data strategy through the design and implementation of technology systems.

You will support Home Office Cyber Security (HOCS) in analysing problems and data analysis issues, looking for underlying causes and assisting in developing solutions. You will also be responsible for delivering data solutions in accordance with agreed organisational standards that ensure services are resilient, scalable and future-proof.

You will work closely with Cyber Security Operations Centre (CSOC) Operations & the wider HOCS department, who will set the scope of your data engineering work through their pro-active research & understanding, in addition to retrospective implementations from known risks, incidents, intelligence originating from commercial, cross-government & international sources., * Assisting in the development of new data models and ETL processes, working collaboratively in the CSOC to build data streaming systems

• Designing, building and testing data products based on feeds from multiple systems using a range of different storage technologies and/or access methods
• Applying the concepts and principles of data modelling to produce, maintain and update relevant data models for specific business needs, including reverse engineering data models from a live system
• Assisting in designing, writing, iterating and optimising code from prototype to production-ready
• Undertaking data profiling and source system analysis and presenting clear insights to colleagues to support the end use of the data
• Assisting in the successful delivery of completed data loads for CSOC Engineering, Cyber Detection & Response, Threat Operations & Service Management functions, putting in place remedies and troubleshooting when required and assisting in the development of new data load programmes

Working pattern:

Due to the business requirements of this role, it is only available on a full-time basis. However, job-share and compressed hours are available

Travel:

Occasional travel to other home office sites may be required. All expenses will be reimbursed in accordance with home office policy., Strategy and Architecture

• Strategy and Planning
• Innovation (INOV) – Level 2
• Advice and Guidance
• Methods and Tools (METL) – Level 2

Development and Implementation

• Data and Analytics
• Data Management (DATM) – Level 2
• Data Modelling and Design (DTAN) – Level 3
• Database Design (DBDS) – Level 2
• Data Engineering (DENG) – Level 3

Desirable Skills

Ideally, you will also have the following skills or some experience in:

• Working with Big Data tools and data stores utilising SQL, KQL, SPL, Python.
• Using modern / open source programming languages and tools including to deliver data development / engineering products, If a person with disabilities is at a substantial disadvantage compared to a non-disabled person, we have a duty to make reasonable changes to our processes., * UK nationals
• nationals of the Republic of Ireland
• nationals of Commonwealth countries who have the right to work in the UK
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS)
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS)
• individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020
• Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service

Do you have experience in Splunk?, * Experience in IT programming.

• Experience using tools such as industry standard ETL tools, network databases and scheduling and orchestration tools using languages such as SPL, KQL & Python within technologies delivered from Splunk, AWS & Azure.
• Ability to communicate effectively with a wide range of stakeholders translating technical concepts into non-technical language
• Experience in managing the development and delivery of technical products
• Understanding Cloud Data technologies, solutions and future Cloud Data Strategies such as AWS or Azure.
• Ability to applying data development / engineering techniques – both in theory and practice or demonstrate a strong aptitude to learn

The essential skills listed above are reflective of the Home Office Government Digital and Data Profession Career Framework (based on the industry standard SFIA framework- Use the levels of responsibility to understand what would be expected for each technical skill listed). Please see below for the relevant skills for your role, * Changing and Improving

• Communicating and Influencing
• Making Effective Decisions

We only ask for evidence of these behaviours on your application form:

• Changing and Improving

Technical skills

We’ll assess you against these technical skills during the selection process:

• Innovation (INOV) – Level 2
• Methods and Tools (METL) – Level 2
• Data Management (DATM) – Level 2
• Data Modelling and Design (DTAN) – Level 3
• Database Design (DBDS) – Level 2
• Data Engineering (DENG) – Level 3, This vacancy is using Success Profiles , and will assess your Behaviours, Experience and Technical skills., All Civil Servants are expected to comply with the Civil Service Code, and its core values of integrity, honesty, objectivity and impartiality.

Additional Security Checks

As well as successfully obtaining UK Security Vetting clearance, candidates will be subject to a range of additional checks. The range of checks carried out will depend on whether you are a current Home Office employee, existing civil servant or an external new entrant as well as the role requirements. The level of Criminal Record Check required for this role is [Basic]. Further details are included in the Notes to Candidates., You should currently hold, or be willing to obtain, Non-Police Personnel Vetting (NPPV) Level-3 vetting (including financial checks). This is essential for the role. For further information visit About the Police National Vetting Service , Warwickshire Police., Successful candidates must undergo a criminal record check. Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check .

£39,500 New entrants to the Civil Service will start their role on the salary band minimum £39,500 for National Roles.

Recruitment and Retention Allowance (RRA): Up to £4000 is available for candidates who demonstrate exceptional skills and experience evidenced at interview stage. GBP, * A Civil Service pension with an employer contribution of 28.97%.

• In-year reward scheme for one-off or sustained exceptional personal or team achievements.
• 25 days annual leave on appointment, rising with service to 30 days.
• Eight days of public holidays, plus one additional privilege day.
• Where business needs allow, some roles may be suitable for a combination of office and home-based working. This is a non-contractual arrangement where all employees will be expected to spend a minimum of 60% of their working time in an office.