Job summary
The Digital, Data and Technology (DDAT) directorate has recently been established in UKEF, drawing together the expertise in digital currently within the organisation to provide representation of digital services, user centred design, analytics and technology at the highest levels. The areas with the directorate work closely with all areas of the business such as the Business Group, Operations and Strategy and Policy.
Job description
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 install and configure DBMS, manage database schemas and objects, implement security policies, monitor performance and tuning parameters, manage user access and permissions and perform general maintenance tasks.
Person specification
Essential
Qualifications
1. Graduate level education or relevant professional experience. (A)
2. Evidence of continuing professional development. (A)
Knowledge
3. Good knowledge of Azure Cloud Computing. (A, I)
4. Good knowledge of Data architectures including Data warehouses and relational databases and Data modelling techniques. (A, I)
5. Knowledge of database Backup/Recovery techniques, including database clustering techniques on varied database technologies. (A, I)
6. Knowledge of management of dimensional models, SQL scripting. (A, I)
Skills/Ability
7. Communicating between the technical and non-technical:You can communicate effectively with technical and non-technical stakeholders.
(Skill level: working) (A, I)
8. Data integration design:You can understand the concepts and principles of data can produce relevant data models across multiple subject can reverse-engineer data models from a live can understand industry-recognised data modelling patterns and standards, and when to apply can compare and align different data models.
(Skill level: practitioner) (A, I)
9. Metadata management:You can design an appropriate metadata repository and present changes to existing metadata can understand a range of tools for storing and working with metadata.
(Skill level: practitioner) (A, I)
10. Problem resolution:You can respond to problems in databases, data processes, data products and services as they can initiate actions, monitor services and identify trends to resolve can determine the appropriate remedy and assist with its implementation, and with preventative measures.
(Skill level: working) (A, I)
�
All skill levels are In relation to
Experience
11. Experience in the following disciplines:
12. Experience using Azure Cloud Computing, including Azure Managed Instance, Azure Data Lakes, and Azure SQL.
13. Experience using MSSQL stack.
14. Efficient and conformant Database Design skills.
15. Knowledge and experience of SQL Server Optimisation techniques.
16. Experience in Troubleshooting SQL Servers.
17. In-depth experience in developing and running a data warehouse, tasks including tracking data changes, migration, archiving and monitoring data systems.
18. Experience using Agile methodologies, including Scrum or Kanban. (A, I)
Desirable
Qualifications
19. Relevant Microsoft Data related qualification. (A)
Knowledge
20. Familiarity with tools like Jira and Kanban boards. (A)
Experience
21. Experience of working in the financial services sector. (A)
22. Experience with Automation and DevOps. (A, I)
Qualifications
� Graduate level education or relevant professional experience.
� Evidence of continuing professional development.
Behaviours
We'll assess you against these behaviours during the selection process:
23. Managing a Quality Service
24. Delivering at Pace
25. Working Together
Technical skills
We'll assess you against these technical skills during the selection process:
26. Technical Questions in relation to the role
Benefits
Alongside your salary of �43,890, UK Export Finance contributes �12,714 towards you being a member of the Civil Service Defined Benefit Pension scheme.
27. Learning and development tailored to your role
28. An environment with flexible working options
29. A culture encouraging inclusion and diversity
30. A with an employer contribution of