Management Reporting and BI Specialist (GMG/SEG 2)

Key Responsibilities

Develop comprehensive “Metric Specifications” for the balanced set of Performance Indicators that FID’s Report Consumers wish to see as specified in Service Level Agreements. 

• Works with report consumers to specify and document exactly how each performance measure is to be developed and visualised; 
• Works with the Database Administrator and accesses the data dictionaries for the FID’s operational ICT applications to specify the precise location of the data elements needed to generate the Performance Measure and documents in the Metric Specification Form; 
• Updates the database of metric specification and makes the same available to report consumers via the FID’s intranet; 
• Develops and maintains a Glossary of Terms that describes each performance measure, basis for calculation etc., ensuring that there is shared understanding by report consumers of what each performance measure represents; 

Work with the data experts in the ICT Branch to develop, design and maintain the FID’s operation data stores. 

• Works with the FID’s Database Administrator to develop a series of Operational Data Stores that Extracts and Transforms and Loads data from all available data sources, based on the specifications developed for each performance indicator; 
• Performs any transformations that may be required on the data in the ODS, as specified in the Metric Specification Form; 
• Collaborates with the DBA to automate the processes, and troubleshoots any issues that occur with the production system; 
• Works with Cost Analyst to extract spending of assets under management from FINMAN for recording against the FID EAM application; 
• Works with ICT to consolidate Transaction date from FINMAN and accrual and uploads the budgets to the consolidated actuals system or vice versa; 
• Recommends and provides support and management of the FAD Accounting and Business databases, as well as related software applications, such as the following: 
• The Government’s Financial Management Accounting System 
  • Ensures that the Accounting System performs optimally at all times; 
  •  Establishes access for authorized users when required; 
  • Provides training and technical assistance to authorized users and gives them the requisite manuals, user guides and code sheets to enable them to carry out their functions;
  • Implements, monitor and control security and back-up procedures; 
  • Maintains the Chart of Accounts and effects the procedures for opening and closing of each period; 
  • Ensures that software is adapted to meet any changing needs of the MOFPS and Budget Funded Entities; 
  • Implements the appropriate processes when repairing and/or replacing defective hardware; 
  • Verifies and approves invoices which are for payment of goods and services and are related to maintenance of FINMAN hardware and or software; 
  • Supports the processes of upgrading and developing the FINMAN system by requesting enhancements, modifications and or evaluations for bugs; 
  • Assists in testing new or modified programmes and functions;
• The Bank Reconciliation System 
  • Provides access to authorized users of the system which will enable them to perform their assigned tasks; 
  • Provides the appropriate training and technical assistance to authorized users;
  • Provides the appropriate manuals, user guides and code sheets to authorized users which will assist them in carrying out their functions; 
  • Implements, monitors, controls and administers all security and back-up procedures;
  • Implements the processes of repairing and or replacing any defective hardware as required; 
  • Verifies and approves all invoices for payment of goods and services, which are related to maintaining BRS hardware and or software; 
  • Supports the processes of upgrading and developing the BRS system by requesting enhancements, modifications and or evaluations for bugs; 
  • Assists in testing new or modified programmes and functions. 
• The Budget Information System 
  • Gives access to authorized users of the system which will enable them to perform their assigned tasks; 
  • Provides the appropriate training and technical assistance to authorized users;
  • Provides the appropriate manuals, user guides and code sheets to authorized users in order to assist them in carrying out their functions; 
  • Implements, monitor and control all security and back-up procedures; 
  • Implements the processes of repairing and or replacing any defective hardware as required;
  • Verifies and approve invoices which are for payment of goods and services and are related to the Budget Information System hardware and or software maintenance. 
• The Payroll System 
  • Gives access to authorized users of the system, enable them to perform their assigned tasks;
  • Provides the appropriate training and technical assistance to authorized users;
  • Implements, monitors and controls all security and back-up procedures;
  • Provides the appropriate manuals, user guides and code sheets to authorized users, to ensure that they are provided the tools to carry out their functions effectively;
  • Implements the processes of repairing and or replacing any defective hardware as required;
  • Verifies and approves all invoices for payment of goods and services and are related to system hardware and or software maintenance. 

Visualise the KPI content and publish Corporate, Directorate, Branch and Section Scorecards and Dashboards to schedules agreed with Report Consumers 

• Publishes FIDs Corporate, Branch and Section performance Scorecard and Dashboards as required by report consumers; 
• Generates BTW Budget reports supporting a multi-dimensional, Fact-Based Corporate performance review process at the FID; 
• Manages users and access rights to the reporting toolsets, with the assistance of the FID ICT Branch; 
• Designs and delivers training/coaching modules aimed at strengthening institutional proficiency in the use of BI tools; 
• Completes own performance self-assessment. 

Required Knowledge, Skills and Competencies

• Flexibility & Adaptability 
• Problem Solving & Critical Thinking 
• Stewardship Responsibility & Accountability 
• Communication 
• Teamwork 
• Emotional Intelligence 
• Relationship Building & Networking 
• Innovative Thinking 
• Results-Oriented 
• Facilitation skills and facilitated planning; 
• Corporate Performance Management principles; 
• Knowledge of OLAP and data cube technology e.g. the data analysis capabilities of MS SQL Server, Analysis services; 
• Knowledge of at least one data management/Business Intelligence application (Cognos, Business Objects, Power BI, Qlik View) would be an asset; 
• Competent in Microsoft Word, Excel and PowerPoint.

Minimum Required Qualification and Experience

• Undergraduate degree Computer Science, Information Systems, Statistics, Management, Business Administration; 
• Four (4) years progressive experience in a business analysis, business planning or reporting role; 
• Two to three (2-3) years’ experience working with database queries, writing stored procedures; 
• Experience in facilitating participative planning workshops; 
• Experience in using enterprise data to generate Performance Indicators, Dashboards and Scorecards ; 
• Sound business background. 

Special Conditions Associated with the Job

• Pressured working conditions with numerous critical deadlines.

Please note that only shortlisted applicants will be contacted.