bi analyst London, England
Job description
Details
Reference number
Salary
Job grade
Contract type
Business area
Type of role
Working pattern
Number of jobs available
Contents
Location
About the job
Benefits
Things you need to know
Apply and further information
Location
About the job
Job summary
#DESNZ
The responsibilities for the Department for Energy Security & Net Zero for 2023 are as follows:
- Delivering security of energy supply
- Ensuring properly functioning energy markets
- Encouraging greater energy efficiency
- Seizing the opportunities of net zero to lead the world in new green industries
For 2023, our priorities are:
- Ensure security of energy supply this winter, next winter and in the longer-term – bringing down energy bills and reducing inflation.
- Ensure the UK is on track to meet its legally binding Net Zero commitments and support economic growth by significantly speeding up delivery of network infrastructure and domestic energy production.
- Improve the energy efficiency of UK homes, businesses and public sector buildings to meet the 15% demand reduction ambition.
- Deliver current schemes to support energy consumers with their bills and develop options for long-term reform to improve how the electricity market works for families and businesses.
- Seize the economic benefits of Net Zero, including the jobs and growth created through investment in new green industries.
- Pass the Energy Bill to support the emerging CCUS and hydrogen sectors; to update the governance of the energy system; and to reduce the time taken to consent offshore wind.
Our Inclusive Environment
We are building an inclusive culture to make the Department a brilliant place to work where our people feel valued, have a voice and can be their authentic selves.
We value difference and diversity, not only because we believe it is the right thing to do, but because it will help us be more innovative and make better decisions.
We offer first-class flexible working benefits, excellent employee well-being support and a great pension. We are fortunate to have a range of excellent staff networks and are proud to be a Disability Confident Leader employer. We will support talented people from all backgrounds to build a career and thrive.
We actively welcome applications from anyone who shares our commitment to inclusion. We will fully support candidates with a disability or long-term condition who require adjustments in our recruitment process.
Job description
The role and our team
You will be part of the Finance Systems team. We use Digital methods to serve Finance customers, making this a great role to gain exposure at the interface of two Corporate Services functions. Our applications are used by two Departments; Department for Science, Innovation & Technology and Department for Energy Security & Net Zero to create a single source of the truth for Finance data. This data is used to inform decision making across the Departments and used to report the performance of the Departments to the Treasury, Parliament, and the public.
The Finance Systems team is split into two sub-teams, you will sit in the technical team. The technical team is responsible for architecting, building, and supporting applications which feed into two data sources, an SQL database, and an IBM multi-dimensional database. You will work closely with the Business Partnering Teams.
This is an exciting new role in the context of our expanding shared service that, following the BEIS machinery of government announcement by the Prime Minister in February, supports a growing number of Departments.
As the Business Intelligence Business Partner, you will lead on supporting our Shared Service users to get the most out of their Finance data. This will be supporting the Government Finance Function’s objectives on ‘leading practice’, ‘insight’, and ‘planning, risk and performance’.
You will design, build and maintain data visualisations and dashboards that meet our users’ needs. You will work with all of our Finance data, and having understood its purpose and structure, develop new models and maintain and enhance the existing ones in support of the reporting needs of all of our stakeholders. You will work with our developers to structure our data optimally for our users and tools, and you’ll be a champion of data-based insight and data visualisation.
You will be working in a small team of software developers, who work with our finance business analyst and a stakeholder support team. This new role will give you a degree of autonomy in getting the most of our Finance function’s data.
Person specification
Key responsibilities
Build, maintain and enhance Finance data models, reports and dashboards, according to user needs
Provide training and support to data champions and users across the Finance function on the use of our reporting and automation tools as well as our data models, reports and dashboards
Document data catalogues and data flows, and write guidance on operationally important data models, reports and dashboards
Perform and support data quality improvement and data stewarding
Support data and reporting governance
Identify and deliver on efficiency and/or risk reduction opportunities
Skills and experience
You can demonstrate, from your experience, the ability to:
- Build productive and sustainable partnerships with business, digital, and other central support teams
Build the capability of other teams to use data and visualisation tools
Create effective data visualisations
Understand data structures and their purpose
Articulate the purpose and value of data governance to business stakeholders
Understand how tools such as Power BI and other data platforms can be used to deliver business benefit
You have knowledge of the Finance function and common types of Finance data
You have a willingness to learn and develop your data and reporting skillset, as well as maintain your Finance knowledge
You should not be put off applying if you do not meet all of these criteria. Should you be selected for interview, we will be happy to discuss what support you might need to close any gaps and/or any other skills you might have which you think could be helpful in role.
- Visualisations and data. You love building simple and effective data visualisations that answer users’ questions and provide insight. You are data literate. You are comfortable using Excel, can build models and you understand the value of well-designed tables and metadata. You know what a database schema is and can relate a schema to what matters for users.
- Finance reporting. You have worked in a Finance environment, ideally in central government as an accountant. You are familiar with double entry and common Finance data sets, including how Finance data relates to the major components of a typical Finance function. You know the practical types of reporting that are common to Finance.
- Finance systems. You have worked with a large finance system, preferably in a role that requires some knowledge of the conceptual structure of the system and finance data.
- User focus. You can collaborate with user researchers and represent users internally. You can explain the difference between user needs and the desires of the user. You can champion user research to focus on all users. You can offer recommendations on the best tools and methods to be used.
- The big picture. You are comfortable thinking about strategy, particularly long-term trends in Finance data and systems. You have familiarity with the Government Finance Function’s strategy and objectives and the overarching government strategies and roadmaps for Digital and Data.
Technical skills
To be assessed:
Data modelling and visualisation - There will be a test on the technical skill - Data modelling and visualisation
https://www.gov.uk/guidance/data-architect
Behaviours
We'll assess you against these behaviours during the selection process:
- Changing and Improving
- Delivering at Pace
- Making Effective Decisions
- Working Together
Technical skills
We'll assess you against these technical skills during the selection process:
- Data modelling and visualisation
Benefits
The Department for Energy Security and Net Zero offers a competitive mix of benefits including:
- A culture of flexible working, such as job sharing, homeworking and compressed hours.
- Automatic enrolment into the Civil Service Pension Scheme, with an average employer contribution of 27%.
- A minimum of 25 days of paid annual leave, increasing by 1 day per year up to a maximum of 30.
- An extensive range of learning & professional development opportunities, which all staff are actively encouraged to pursue.
- Access to a range of retail, travel and lifestyle employee discounts.
- A hybrid office/home based working model where staff will spend a norm of 40-60% of their time in the office (minimum of 40%) over a month with flex dependent on balancing business and individual need.
Things you need to know
Selection process details
As part of the application process you will be asked to complete a CV and personal statement.
Further details around what this will entail are listed on the application form.
Please use your personal statement (in no more than 750 words) to describe how you feel this job is a fit for your skills, and what you feel you could bring to the role.
Applications will be sifted on CV and personal statement.
In the event of a large number of applicants, applications will be sifted on the personal statement.
Candidates who pass the initial sift may be progressed to a full sift, or progressed straight to assessment/interview.
The interview will consist of behaviour, technical and strength-based questions.
Sift and interview dates
Expected Timeline subject to change
Sift dates: w/c 14/08/2023
Interview dates: from 29/08/2023
Interview Location: MS Teams.
Candidates are asked to note the above timetable, exercising flexibility through the recruitment and selection process.
Further Information
Reasonable Adjustment
We are proud to be a disability confident leader and we welcome applications from disabled candidates and candidates with long-term conditions.
We fully support adjustments throughout our recruitment process and we encourage candidates to discuss their adjustment needs by emailing the job contact which can be found under the contact point for applicants section.
We do not have an exhaustive list of adjustments that we support but just some examples include additional time to complete your application form, behaviour questions up to 72 hours prior to interview and having extra time at interview.
If you are experiencing accessibility problems with any attachments on this advert, please contact the email address in the 'Contact point for applicants' section.
If successful and transferring from another Government Department a criminal record check may be carried out.
New entrants are expected to join on the minimum of the pay band.
A location based reserve list of successful candidates will be kept for 12 months. Should another role become available within that period you may be offered this position.
Please note terms and conditions are attached. Please take time to read the document to determine how these may affect you.
Any move to the Department for Energy, Security and Net Zero 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 https://www.childcarechoices.gov.uk
DESNZ does not normally offer full home working (i.e. working at home); but we do offer a variety of flexible working options (including occasionally working from home).
DESNZ cannot offer Visa sponsorship to candidates through this campaign. DESNZ holds a Visa sponsorship licence but this can only be used for certain roles and this campaign does not qualify.
In order to process applications without delay, we will be sending a Criminal Record Check to Disclosure and Barring Service /Disclosure Scotland on your behalf.
However, we recognise in exceptional circumstances some candidates will want to send their completed forms direct. If you will be doing this, please advise Government Recruitment Service of your intention by emailing [email protected] stating the job reference number in the subject heading.
For further information on the Disclosure Scotland confidential checking service telephone: the Disclosure Scotland Helpline on 0870 609 6006 and ask to speak to the operations manager in confidence, or email [email protected]
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.
A candidate is not eligible to apply for a role within the Civil Service if the application is made within a 5 year period following a dismissal for carrying out internal fraud against government.
Feedback
Feedback will only be provided if you attend an interview or assessment.
Security
Nationality requirements
This job is broadly open to the following groups:
- UK nationals
- nationals of Commonwealth countries who have the right to work in the UK
- nationals of the Republic of Ireland
- nationals from the EU, EEA or Switzerland with settled or pre-settled status or who apply for either status by the deadline of the European Union Settlement Scheme (EUSS) (opens in a new window)
- relevant EU, EEA, Swiss or Turkish nationals working in the Civil Service
- relevant EU, EEA, Swiss or Turkish nationals who have built up the right to work in the Civil Service
- certain family members of the relevant EU, EEA, Swiss or Turkish nationals
Working for the Civil Service
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).
Apply and further information
