Power BI Developer
Details
Reference number
403078
Salary
£43,890 - £57,685
The salary range is £43,890 to £51,571 (National) or £46,085 to £57,685 (London).
A Civil Service Pension with an employer contribution of 28.97%
GBP
Job grade
Senior Executive Officer
Contract type
Fixed term Loan
Length of employment
12 Months
Business area
UKEF - Digital, Data and Technology
Type of role
Architecture and Data
Working pattern
Flexible working, Full-time
Number of jobs available
1
Contents
Location
About the job
Benefits
Things you need to know
Apply and further information
Location
Westminster, London or Leeds
About the job
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.
About the Role
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.
You’ll 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.
Job description
Main Activites
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.
This list is not exhaustive, and you may be required to carry out additional duties according to business needs.
Person specification
UK Export Finance is looking for motivated individuals with a desire to learn about the business. Successful candidates will be provided not only with functional training to enable them to do well in their role, but also with personal development to help them to achieve their career ambitions. Please note that the person specification below outlines at which stage(s) you will be assessed on how you meet the criteria for the role(s) including:-
A = assessed at application stage I = assessed at interview stage P = assessed at presentation stage
Essential
Qualifications
Degree educated or equivalent demonstrable experience (A, I)
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
Demonstrable and applied experience of delivering Power BI dashboard/ reporting. (A, I, P)
Experience with DAX. (A, I, P)
Experience with dynamic M (A, I, P)
Experience with Paginated Reporting (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.
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:
From your experience, what technical skills have you applied to business Intelligence reporting generally and Power BI specifically?
Technical Presentation
Technical Questions
We only ask for evidence of these technical skills on your application form:
From your experience, what technical skills have you applied to business Intelligence reporting generally and Power BI specifically?
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. 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 , and will assess your Behaviours, Experience and Technical skills.
We are assessing candidates using Success Profiles (see Appendix 1) and across the whole process we will assess your Experience, Technical, and Behaviours as highlighted below.
The application must be completed by 23.55 on the day of the closing date for it to be accepted.
Use of Artificial Intelligence (AI)
At UKEF we value authenticity. You should not use AI to present and/or plagiarise the ideas and experiences of others. Therefore, you must ensure that any evidence submitted as part of your application or used during an interview is both truthful and factually accurate. Applications may be rejected at any stage of the selection process if plagiarism is detected. Appendix 2 provides guidelines on what we feel is / is not acceptable use of AI.
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 highlighted.
Technical - you will be assessed across your technical expertise and acumen, in relation to the essential criteria
Presentation
Technical Questions
Details of interview panel members will be e-mailed to all successful candidates who are invited for interview. 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
Further information on nationality requirements
Working for the Civil Service
The Civil Service Code 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 .
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 and the Civil Service Diversity and Inclusion Strategy .
Apply and further information
This vacancy is part of the Great Place to Work for Veterans initiative.
Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.
Contact point for applicants
Job contact :
Name : UKEF Recruitment
Email : Recruitment2@ukexportfinance.gov.uk
Recruitment team
Email : Recruitment2@ukexportfinance.gov.uk
Further information
Should you have a complaint or wish to raise any concerns regarding the recruitment process, please e-mail your complaint to the Head of Pay and Resourcing (UKEF) at Recruitment2@ukexportfinance.gov.uk and include “Complaint” in the subject heading. Should you remain dissatisfied following UKEF’s investigation then you can refer your complaint to the Commission - http://civilservicecommission.independent.gov.uk/making-complaint.
Details
Reference number
403078
Salary
£43,890 - £57,685
The salary range is £43,890 to £51,571 (National) or £46,085 to £57,685 (London).
A Civil Service Pension with an employer contribution of 28.97%
GBP
Job grade
Senior Executive Officer
Contract type
Fixed term Loan
Length of employment
12 Months
Business area
UKEF - Digital, Data and Technology
Type of role
Architecture and Data
Working pattern
Flexible working, Full-time
Number of jobs available
1
Contents
Location
About the job
Benefits
Things you need to know
Apply and further information
Location
Westminster, London or Leeds
About the job
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.
About the Role
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.
You’ll 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.
Job description
Main Activites
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.
This list is not exhaustive, and you may be required to carry out additional duties according to business needs.
Person specification
UK Export Finance is looking for motivated individuals with a desire to learn about the business. Successful candidates will be provided not only with functional training to enable them to do well in their role, but also with personal development to help them to achieve their career ambitions. Please note that the person specification below outlines at which stage(s) you will be assessed on how you meet the criteria for the role(s) including:-
A = assessed at application stage I = assessed at interview stage P = assessed at presentation stage
Essential
Qualifications
Degree educated or equivalent demonstrable experience (A, I)
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
Demonstrable and applied experience of delivering Power BI dashboard/ reporting. (A, I, P)
Experience with DAX. (A, I, P)
Experience with dynamic M (A, I, P)
Experience with Paginated Reporting (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.
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:
From your experience, what technical skills have you applied to business Intelligence reporting generally and Power BI specifically?
Technical Presentation
Technical Questions
We only ask for evidence of these technical skills on your application form:
From your experience, what technical skills have you applied to business Intelligence reporting generally and Power BI specifically?
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. 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 , and will assess your Behaviours, Experience and Technical skills.
We are assessing candidates using Success Profiles (see Appendix 1) and across the whole process we will assess your Experience, Technical, and Behaviours as highlighted below.
The application must be completed by 23.55 on the day of the closing date for it to be accepted.
Use of Artificial Intelligence (AI)
At UKEF we value authenticity. You should not use AI to present and/or plagiarise the ideas and experiences of others. Therefore, you must ensure that any evidence submitted as part of your application or used during an interview is both truthful and factually accurate. Applications may be rejected at any stage of the selection process if plagiarism is detected. Appendix 2 provides guidelines on what we feel is / is not acceptable use of AI.
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 highlighted.
Technical - you will be assessed across your technical expertise and acumen, in relation to the essential criteria
Presentation
Technical Questions
Details of interview panel members will be e-mailed to all successful candidates who are invited for interview. 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
Further information on nationality requirements
Working for the Civil Service
The Civil Service Code 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 .
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 and the Civil Service Diversity and Inclusion Strategy .
Apply and further information
This vacancy is part of the Great Place to Work for Veterans initiative.
Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.
Contact point for applicants
Job contact :
Name : UKEF Recruitment
Email : Recruitment2@ukexportfinance.gov.uk
Recruitment team
Email : Recruitment2@ukexportfinance.gov.uk
Further information
Should you have a complaint or wish to raise any concerns regarding the recruitment process, please e-mail your complaint to the Head of Pay and Resourcing (UKEF) at Recruitment2@ukexportfinance.gov.uk and include “Complaint” in the subject heading. Should you remain dissatisfied following UKEF’s investigation then you can refer your complaint to the Commission - http://civilservicecommission.independent.gov.uk/making-complaint.
