UKEF is committed to using digital as a primary means for managing relationships with a wider range of stakeholders. Focusing on developing services to meet user need and enable business outcomes, this is an exciting role showing the growth and drive of UKEFs digital ambition. Our developers work in agile teams, to deliver prioritised work packages from the research stage through to deployment as live services. Youll be delivering and integrating software to form complete services as well as building and maintaining the service components to ensure they meet our needs. You will work closely with our research and design teams providing technical expertise. We will expect you to be proactive in identifying innovative ways of working as well as process optimisation opportunities and contributing to the implementation of proposed solutions. Main Activities Be the Centre of Excellence, providing support to colleagues for Power BI reporting across UKEF. Create visualizations and reports for requested projects as well as BAU (business as usual). Capture detailed end-user requirements translating into technical specifications and assessing for priority. Actively contribute to the full life-cycle delivery of reports, dashboards, and data feeds. Closely collaborate with team members and stakeholders on design to ensure reporting achieve desired results and are fit for purpose. Develop a testing regime for all products, optimising each report ensuring performance is maintained to the highest level. Develop and update technical documentation, whilst collaborating with business teams to integrate legacy systems and processes. Person specification Essential Qualifications 5 GCSE passes (including Maths and English) at Grade 4 (C) or above; or equivalent or relevant demonstrable experience. [A] Knowledge Intermediate experience of delivering Power BI developments using DAX and multiple, complex data sources. (A, I, P) Understanding of gateway usage. (A, I, P) A good level of knowledge of Power BI workspace and App structures within an organisation. (A, I, P) Skills/Ability Provision of analytical solutions including highly effective dashboard solutions linked to real business needs. (A, I) Stakeholder engagement and management and the ability to establish and maintain strong working relationship. (A, I) Developing / supporting / training colleagues. (A, I) Handling variable data quality issues. (A, I, P) Problem solving and critical thinking. (I) Requirement gathering, analysis and definition. (I) Working in a specialist analytical/reporting role. (A, I) Strong communication skills, both written and verbal. (I) Experience Experience of delivering Power BI dashboard/ reporting. (A, I, P) Experience with DAX. (A, I, P) Experience of gathering requirements for complex solutions to enhance BI/MI Capabilities. (A, I) Desirable Qualifications Significant experience of data analytics and the production of business reports using data visualisation tools, preferably Microsoft Certified. (A, I) Knowledge Advanced experience of delivering Power BI developments using DAX and MDX, and multiple, complex data sources. (A, I) Understanding the purpose and structure of data warehouses and systems. (A, I) Skills/Ability Analysis and reporting of Financial Services data. (A, I) Finance reporting within UK Government or Financial Services organisation. (A) Experience Experience with MDX. (A, I) Experience writing SQL queries. (A, I) Experience working with large and complex data sets. (A, I) Experience gained in financial services or government organisation. (A, I) SQL experience. (A, I) Previous experience working as part of or with a Business Insight function. (A, I) Experience of dealing with Senior Managers. (A, I) Behaviours We'll assess you against these behaviours during the selection process: Changing and Improving Managing a Quality Service Delivering at Pace Technical skills We'll assess you against these technical skills during the selection process: Presentation Technical questions Benefits Alongside your salary of 46,085, UK Export Finance contributes 13,350 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. Statement of suitability - you should fully articulate in 500 words how you meet the essential criteria outlined in the person specification within the Information Pack. Technical question For the initial sift your application will be evaluated against: Experience - Application and Statement of Suitability Technical question - From your experience, what technical skills have you applied to business intelligence reporting generally and Power BI specifically? In the event of a large number of applications an initial sift will be undertaken against the following essential criteria: Experience with DAX 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. Technical: Presentation Technical questions 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) .