UKEF is committed to be a more customer-centric organisation, making it easier for customers to deal with us, offering improved response times, quicker decision-making and improved case-processing. To enable this, UKEF is committed to using digital as a primary means for managing relationships with a wider range of stakeholders. Focusing on developing end-to-end services that meet user need and enable business outcomes, this is an exciting new role showing the growth and drive of UKEFs digital ambition. This role requires you to develop and maintain Data Integration solutions, identify opportunities for improving data infrastructure and processes, develop and maintain ETL processes and manage the deployment and release of data pipelines and applications. Main Activities Monitor and troubleshoot data processing systems to ensure uptime and reliability. Develop and maintain data integration solutions for combining data from various sources. Provide quality assurance and code reviews of other developers work. Work with stakeholders to identify opportunities for improving data infrastructure and processes. Implement and maintain data backup and recovery processes to ensure data availability in case of system failures. Develop and maintain documentation and training materials to support data infrastructure and processing pipelines. Responsible for managing data platforms, such as data warehouses, data lakes, and other data storage systems. Responsible for developing and implementing data management processes, including data integration, data migration, and data storage. Responsible for ensuring that data is secure and compliant with relevant regulations, such as GDPR. This may involve implementing data access controls, data encryption, and data masking. Responsible for creating and maintaining ETL (Extract, Transform, Load) processes for structured and unstructured data. Responsible for the technical approach to data integrity and back-out plans for all changes to UKEF systems. Manage the deployment and release of data pipelines and applications. Contribute to the development and execution of the organization's data strategy and roadmap. Responsible for staying up-to-date with industry trends in data management and data engineering, ensuring that the organization is using the latest tools and technologies. Person specification Essential Qualifications 5 GCSE passes (including Maths and English) at Grade 4 (C) or above; or relevant professional experience. (A) Evidence of continuing professional development. ( A) Knowledge Expert knowledge of SQL and T-SQL. (A, I) Knowledge of ETL and ELT tools. (A, I) Expert knowledge of Data warehouse architectures and Data modelling techniques. (A, I) Skills / Ability All skill levels are in relation to Senior Data Engineer - Government Digital and Data Profession Capability Framework (ddat-capability-framework.service.gov.uk) Communicating between the technical and non-technical: You can communicate effectively with technical and non-technical stakeholders. You can support and host discussions within a multidisciplinary team, with potentially difficult dynamics. You can be an advocate for the team externally and can manage differing perspectives. (Skill level: working) (A, I) Data analysis and synthesis: You can undertake data profiling and source system analysis. You can present clear insights to colleagues to support the end use of the data. (Skill level: working) (A, I) Data development process: You can design, build and test data products that are complex or large scale. You can build teams to complete data integration services. (Skill level: practitioner) (A, I) Data innovation: You can understand the impact on the organisation of emerging trends in data tools, analysis techniques and data usage (Skill level: working) (A, I) Data integration design: You can understand the concepts and principles of data modelling. You can produce relevant data models across multiple subject areas. You can reverse-engineer data models from a live system. You can understand industry-recognised data modelling patterns and standards, and when to apply them. You can compare and align different data models. (Skill level: practitioner) (A, I) Data modelling: You can understand the concepts and principles of data modelling and can produce relevant data models. You can work across government and industry, recognising opportunities for the reuse and alignment of data models in different organisations. You can design the method to categorise data models within an organisation. (Skill level: expert) (A, I) Metadata management: You can design an appropriate metadata repository and present changes to existing metadata repositories. You can understand a range of tools for storing and working with metadata. You can provide oversight and advice to more inexperienced members of the team. (Skill level: practitioner) (A, I) Problem resolution: You can respond to problems in databases, data processes, data products and services as they occur. You can initiate actions, monitor services and identify trends to resolve problems. You can determine the appropriate remedy and assist with its implementation, and with preventative measures. (Skill level: working) (A, I) Programming and build: You can use agreed standards and tools to design, code, test, correct and document moderate-to-complex programs and scripts from agreed specifications and subsequent iterations. You can collaborate with others to review specifications where appropriate. (Skill level: practitioner) (A, I) Technical understanding: You can understand the core technical concepts related to the role and apply them with guidance. (Skill level: working) (A, I) Experience Experience in the following disciplines (A, I) : Experience using Azure Cloud Computing, including Azure Managed Instance, Azure Data Lakes, Azure SQL and Microsoft Fabric. SQL Coding in T-SQL. Experience using MSSQL stack. Knowledge and experience of SQL Server Optimisation techniques. Efficient and conformant Database Design skills. Experience in Troubleshooting SQL Servers. Experience using ETL tools (i.e. Informatica IICS). Unit testing. Desirable Qualifications N/A Knowledge Expert knowledge of Azure Cloud Computing. (A, I) Knowledge of Development Patterns relevant to Web and SOA designs. (A, I) Knowledge of Automated Testing and CI/CD techniques. (A, I) Knowledge of Informatica Intelligent Cloud Services (IICS). (A, I) Skills/Ability Testing: You can review requirements and specifications and define test conditions. You can identify issues and risks associated with work. You can analyse and report test activities and results. (Skill level: working) (A, I) Experience Experience using Azure DevOps and Github. (A, I) Behaviours We'll assess you against these behaviours during the selection process: Seeing the Big Picture Making Effective Decisions Leadership Technical skills We'll assess you against these technical skills during the selection process: Can you provide an example from your own experience where data engineering played a crucial role in driving business decisions? What impact did it have? Could you explain a complex ETL process that you designed and implemented? What tools did you use and why? Presentation We only ask for evidence of these technical skills on your application form: Can you provide an example from your own experience where data engineering played a crucial role in driving business decisions? What impact did it have? Could you explain a complex ETL process that you designed and implemented? What tools did you use and why? Benefits Alongside your salary of 58,969, UK Export Finance contributes 17,083 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides. Learning and development tailored to your role An environment with flexible working options A culture encouraging inclusion and diversity A Civil Service pension with an employer contribution of 28.97% Things you need to know Selection process details This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours, Experience and Technical skills. The application must be completed by 23.55 on the day of the closing date for it to be accepted. All applications will be sifted against our essential criteria outlined in the personal specification. Qualifications Statement of suitability - you should fully articulate in 1000 words how you meet the essential criteria outlined in the person specification within the Information Pack. Applicants are encouraged to use the full word count. Technical questions: Can you provide an example from your own experience where data engineering played a crucial role in driving business decisions? What impact did it have? Could you explain a complex ETL process that you designed and implemented? What tools did you use and why? For the initial sift your application will be evaluated against : Experience - Application and Statement of Suitability Technical - addressing the following 2 questions: Can you provide an example from your own experience where data engineering played a crucial role in driving business decisions? What impact did it have? Could you explain a complex ETL process that you designed and implemented? What tools did you use and why? In the event of a large number of applications, there will be a pre-sift on the responses to the technical questions above: If you are successful following the sift stage, you will be invited to an initial interview; this will include the following assessment: Behaviours / Experience - a formal panel interview where you will be interviewed across all three behaviours highlighted in Appendix 1. Technica l - presentation Feedback will only be provided if you attend an interview or assessment. Security Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window). See our vetting charter (opens in a new window). 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) (opens in a new window) 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 Further information on nationality requirements (opens in a new window) Working for the Civil Service The Civil Service Code (opens in a new window) sets out the standards of behaviour expected of civil servants. We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles (opens in a new window). The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria. The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy. Diversity and Inclusion The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see the Civil Service People Plan (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window) .