Lead Data Engineer, End User Compute & Collaboration

Information Technology Working pattern Full-time, Compressed hours Number of jobs available 1 Contents

• Location
• About the job
• Benefits
• Things you need to know
• Apply and further information

Location Croydon, Liverpool, Manchester, Sheffield, Southport About the job Job summary

Home Office Digital 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.

The Digital Workplace (DW) team develops and delivers a range of Microsoft 365 solutions, including Teams, SharePoint, OneDrive, Power Platform, and Office applications, supporting collaboration and productivity across the organisation.

We are establishing a new data capability to drive the adoption of data-driven insights across the organisation?s product and service landscape.

Working on end-to-end solutions within our Azure architecture, you will use languages including Python, SQL, PowerShell, and Spark, alongside orchestration and analytics platforms such as Azure Data Factory and Microsoft Fabric, to lead the design, development, and ongoing operation of robust, scalable data pipelines. You will set engineering standards and patterns, shape the technical direction of the DW data function, and work closely with senior data colleagues and stakeholders to deliver DW?s data vision.

You?ll get to work with some of the largest and most varied datasets around, and benefit from a wealth of continuous professional development resources and career opportunities. You?ll play a key role in delivering joined-up, intelligent services that unlock the value from data and deliver better outcomes for the UK.

Where business needs allow, some roles may be suitable for a combination of office and home-based working. Where this is the case, employees will be expected to spend a minimum of 60% of their working time in the office . Applicants can raise any queries to the email address at the bottom of the advert.

Watch this short video to hear from members of Home Office Digital talking about the projects they work on and their experience of working here: Working for Home Office Digital., Lead Data Engineers deliver the data engineering vision for the organisation as set by the Principal Data Engineer. As a Lead Data Engineer, you will focus on designing and implementing numerous complex data flows to connect operational systems, data for analytics and BI systems.

You will identify and deliver new data sources and develop ETL processes, collaborate with the Data Acquisition, Analytics and Infrastructure teams to deliver the data strategy through the design and implementation of technology systems.

You will lead the data management and data engineering services and analytical projects, working collaboratively with other teams to acquire and ingest new data sources. You will also work with the Principal Data Engineer, Data Architects, Database Administrators, Technical Architects, Solution Architects and Data Analytics team to set the enterprise data strategy and standards and agree implementation and governance. Person specification

Main Responsibilities

Your main day to day responsibilities will be:

• Managing data sources in a way to improve data quality and conform them for analysis.
• Developing new data models and ETL processes, working collaboratively with the analytics team and mapping data to an appropriate matching data model.
• Exercising key stakeholder management skills in order to manage expectations, listen and interpret business needs, communicate progress and facilitate difficult conversations, while building a 'service culture' around data.
• Managing the performance of suppliers and the data team to improve capability, as well as creating the roadmap which balances immediate user needs with long-term investment.
• Developing processes to balance data availability, capacity and data archiving, while continually improving processes and efficiency in the acquisition and ingestion of data.
• Line managing staff, including coaching and professional development.

Working Pattern

Due to the business requirements of this role, it is only available on a full-time basis. However, compressed hours are available., The allowance values are set by the Home Office, subject to remaining in a qualifying role. This allowance is non-contractual, subject to an annual review and could be withdrawn at any time.

For both new entrants and existing civil servants, the total compensation offer is a combination of base salary and, if applicable, a capability-based allowance. The pay ranges for this role are National: £62,109 - £68,320 and London: £66,229 - £72,852. New entrants to the Civil Service will start on the pay range minimum. For existing civil servants, our policies on level transfer and promotion will apply.

Working at the Home Office

Every day, Home Office civil servants do brilliant work to develop and deliver policies and services that affect the lives of people across the country and beyond. To do this effectively and fairly, the Home Office is committed to representing modern Britain in all its diversity, and creating a welcoming, inclusive workplace where all our people can bring their whole selves to work and perform at their best.

We are flexible, skilled, professional and diverse. We work to recruit and retain disabled staff and area Disability Confident Leader. We are proud to be one of the most ethnically diverse departments in the civil service. We are a Social Mobility Foundation top 75 employer.

New entrants are expected to join on the minimum of the pay band.

Applicants who are successful at interview will be, as part of pre-employment screening, subject to a check on the Internal Fraud Database (IFD). This check will provide information about employees who have been dismissed for fraud or dishonesty offences. This check also applies to employees who resign or otherwise leave before being dismissed for fraud or dishonesty had their employment continued. Any applicant's details held on the IFD will be refused employment.

For further information please see the attached notes for candidates which must be read before making an application.

Existing Civil Servants should note that some of the Home Office terms and conditions of employment have changed. It is the candidate?s responsibility to ensure they are aware of the Terms and Conditions they will adopt should they be successful in application and should refer to the notes for candidates for further details.

Transfer Terms: Voluntary.

You will need to meet the nationality requirements for this role and obtain the necessary security clearance to take it up.

Any move to the Home Office from another employer will mean you can no longer access childcare vouchers. This includes moves between government departments. You may however be eligible for other government schemes, including Tax Free Childcare. Determine your eligibility at https://www.childcarechoices.gov.uk.

Reasonable Adjustments

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.

If you need a change to be made so that you can make your application, you should:

• Contact Government Recruitment Service via as soon as possible before the closing date to discuss your needs.
• Complete the ?Assistance Required? section in the ?Additional Requirements? page of your application form to tell us what changes or help you might need further on in the recruitment process. For instance, you may need wheelchair access at interview, or if you are deaf, a language service professional.

If you are experiencing accessibility problems with any attachments on this advert, please contact the email address in the ?Contact point for applicants? section.

Feedback Feedback will only be provided if you attend an interview or assessment. Security 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 .

See our vetting charter . People working with government assets must complete baseline personnel security standard (opens in new window) checks. Nationality requirements

This job is broadly open to the following groups:

• 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

As a Lead Data Engineer in Enterprise Services, you?ll have a demonstrable passion for Data , with the following skills or some experience in:

• Effectively leading and managing teams, helping them deliver technical products and projects in data analysis, solution design and end user reporting.
• Advising on best practice IT programming and automation techniques and tools such as GIThub, GITLab or other source control software, Python, Java.
• Leading the use of Cloud Data technologies, solutions and future Cloud Data Strategies with experience using tools such as Azure Automation, Azure Data Factory, Azure DevOps, ServiceNow, AWS Lambda, AWS Glue, Redshift, Athena, EC2, IAM, MS Fabric Notebooks and APIs such as REST, GraphQL.
• Working with stakeholders to gather requirements and deliver findings.
• Presenting complex ideas and recommendations in a clear concise way to technical and non-technical audiences, and senior customers.
• Using tools such as industry standard ETL tools, network databases and scheduling and orchestration tools such as Azure Automation, Azure Data Factory, Azure DevOps, AWS. Also, Step Functions, MS Fabric Task Flows, MSSQL, OneLake, AWS S3, AWS Redshift.

SFIA capability framework

Skills for the Information Age (SFIA) version 8 is the technical framework that sets the standard capability and development of all levels in the Home Office. This is a link to the capability framework: All skills A - Z English (sfia-online.org).

We use set SFIA technical skills to form our interview questions and we will assess you against these technical skills during the selection process.

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 SFIA Levels of responsibility to understand what would be expected for each technical skills listed below.

Strategy and Architecture

• Strategy and Planning

• Innovation (INOV) ? Level 3

• Advice and Guidance

• Methods and Tools (METL) ? Level 4

Development and Implementation

• Data and Analytics

• Data Management (DATM) ? Level 4
• Data Modelling and Design (DTAN) ? Level 4
• Database Design (DBDS) ? Level 3
• Data Engineering (DENG) ? Level 4

Behaviours

We'll assess you against these behaviours during the selection process:

• Communicating and Influencing

Technical skills

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

• Innovation (INOV) ? Level 3
• Methods and Tools (METL) ? Level 4
• Data Management (DATM) ? Level 4
• Data Modelling and Design (DTAN) ? Level 4
• Database Design (DBDS) ? Level 3
• Data Engineering (DENG) ? Level 4, For meaningful security checks to be carried out, individuals need to have lived in the UK for a sufficient period of time. Learn more on our website. Security Checks - Home Office Careers.

Please note that this role requires Security Check (SC) clearance, which would normally need 5 years? UK residency in the past 5 years.

However, in exceptional circumstances security clearance applications for candidates who have been present in the UK for at least 3 of the last 5 years may be considered. Failure to meet this residency requirement will result in your security clearance application being rejected., We are unable to sponsor any individuals via Skilled Worker Sponsorship / Tier 2 (General) work visas as we do not hold a UK Visa & Immigration (UKVI) Skilled Worker License.

Benefits Alongside your salary of £62,109, Home Office contributes £17,992 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.

Why work for us...

Find out more information at: Benefits - Home Office Careers, but some of the primary ones are:

• A Civil Service Pension with employer contribution rates of at least 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.
• 8 days of public holidays, plus 1 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.