Assistant Finance Manager: Data, Reporting and Systems

Scottish Government OGD Recruitment; City of Edinburgh; On-site; GBP 42,000 - 56,000; Full time

Job summary

Scottish Government OGD Recruitment is seeking an Assistant Finance Manager to turn financial data into actionable insight within a corporate context. You will focus on data, reporting, and systems to enable informed decision making across the organisation.

As part of the Corporate Reporting team you will produce reports and applications, leveraging Power BI and Oracle tools while maintaining clear communication with diverse stakeholders.

Qualifications

• Experience in corporate reporting and BI.
• Strong data handling and Excel/VBA skills.
• Familiarity with Oracle finance suite is preferred.
• Ability to explain technical concepts to non-technical stakeholders.
• Part-qualified or working towards a professional qualification with support provided.

Responsibilities

• Maintain and develop repeatable processes for EPM financial reporting, including data refresh timelines.
• Align Corporate Finance dashboards/reports with SG policies and Power BI hosting standards.
• Build and maintain Power BI security models and manage access requests.
• Support communications with stakeholders through Q&A sessions and training materials.
• Suggest improvements by triaging stakeholder feedback and coordinating with Corporate Finance.

Skills

Data analysis

Stakeholder communication

Report writing

Attention to detail

Tools

Power BI

Oracle

Excel

VBA

Job 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.

Responsibilities

• 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.