Assistant Finance Manager: Data, Reporting and Systems
Description
Are you ready to turn financial data into meaningful insight?
This is an excellent opportunity to develop your career as an Assistant Finance Manager within a corporate setting at the heart of the Scottish Government, with a specific focus on making the most of corporate data, reporting and systems to enable financial insights and decision making across the organisation.
As an assistant finance manager within the small Corporate Reporting team, you’ll use your analytical, technical and data capabilities to produce a range of reports and applications, supporting Corporate Finance processes and managing outputs for consumption by the wider organisation.
Reporting to a Senior Finance Manager, this is a key role which requires a combination of financial skills alongside detailed technical knowledge of data handling tools and processes, business intelligence, and familiarity with the Oracle finance suite and underpinning data/metadata structures.
You will work with a degree of independence to manage both data refresh of existing tools as well as enhancements and new developments, requiring highly effective analytical capabilities and strong organisation and prioritisation skills. You’ll also need to be able to communicate in a non-technical manner with a wide range of stakeholders across the Scottish Government to enable them to adopt best practice, and use financial reporting outputs effectively, managing feedback and enhancement pipelines to support ongoing improvement.
You’ll be joining an innovative, forward-looking division with a vision to apply global best practice, and a commitment to support all staff to grow their professional knowledge, skills, and experience.
This is a technical role within the finance profession. While it does not require you to hold a professional accountancy qualification, the successful candidate may be part qualified or be willing to work towards qualification. Full support for this will be provided as appropriate.
- Maintain and develop repeatable processes for Enterprise Resource Management (EPM) financial reporting outputs, including managing the timetable for data refresh and associated data dependencies where those outputs are generated external to the EPM system.
- Ensuring alignment of Corporate Finance dashboards and reports with SG policies and best practice on hosting and sharing Power BI dashboards and related resources.
- Build and maintain the Power BI security model and manage ad-hoc access requests and queries, ensuring data is secure and that only the relevant data is shared with the appropriate audiences.
- Manage associated guidance and training materials, and support communications with stakeholders/Q&A sessions and other engagement.
- Support continuous improvement by developing improvement recommendations, including managing and triaging stakeholder feedback, and liaising with Corporate Finance colleagues on prioritisation.
- Develop effective reporting solutions using Power BI and native Oracle reporting functionalities based on a strong understanding of EPM data, Scottish Government Chart of Accounts and related data structures, leveraging relevant emerging technologies including Automations or AI.
- Use reporting tools and data interrogation to identify data issues, in particular quality assurance of EPM outputs for dashboards and reports, and recommend solutions or controls to address these, in conjunction with wider Finance and Oracle system management colleagues as appropriate.
- Support continuous improvement of Corporate Finance off system processes and reporting, including process, formulaic or VBA macro based developments or improvements to existing and future Excel or other MS Office dependent activities.
- Support testing of new EPM releases by verifying accuracy and consistency of current and future reporting outputs and liaise with project team to support relevant defect resolution and re-testing.
- Budgeting, Forecasting and Costing - Working
- Working with Data in Systems - Practitioner
- Working with Data in Finance - Practitioner
- Experience working with Power BI in a corporate finance context, owning the end-to-end lifecycle from requirements gathering through build, testing, publication and iteration, and maintaining a business-as-usual data refresh pipeline and security model.
- Experience producing outputs in the form of reports and data visualisations so that financial data can be used effectively to support evidence based decision making, leveraging your knowledge of Scottish Government corporate finance data and metadata structures.
- Advanced Excel/VBA experience, such as building and maintaining applications to support/automate the management and processing of data.
- Making Effective Decisions (Level 3)
- Changing and Improving (Level 3)
- Communicating and Influencing (Level 3)
Recruitment Principles
As a government organisation, we adhere to the Civil Service Commission Recruitment Principles and we investigate any complaints received in relation to recruitment cases.
Skilled Worker Sponsorship not being offered
Skilled Worker sponsorship is not available for this role. As a result, we are unable to appoint candidates who require Skilled Worker sponsorship now or in the future. Applicants must have an existing and ongoing right to work in the UK.