Business Analyst and Reporting
1. DUTIES / SCOPE OF WORK
The Business Analyst (BA) shall provide end-to-end business analysis, portfolio management support, budgeting assistance, forecasting, and reporting services to enable data-driven decision-making within the Directorate of CIS Support Units (DCSU).
The role is delivery-based and outcome-oriented, requiring the production of structured analytical outputs, dashboards, reports, and governance documentation.
A. Portfolio Management Duties
The Contractor shall:
- Maintain and operate a centralized portfolio register of all active initiatives, including financial, schedule, risk, and dependency data.
- Ensure data completeness, accuracy, and monthly reconciliation with financial systems.
- Develop and maintain an executive portfolio dashboard providing KPIs such as:
- Budget utilization
- Schedule variance
- Risk exposure
- Prioritization indicators
- Prepare portfolio governance review packs for senior leadership, including:
- Portfolio status summaries
- Risk and dependency analysis
- Financial position and forecasts
- Prioritization recommendations
- Support portfolio governance boards through structured reporting inputs.
B. Annual Budgeting Duties
The Contractor shall:
- Develop and maintain budget planning frameworks, templates, and timelines aligned with financial governance requirements.
- Support consolidation of annual departmental budgets, ensuring:
- Full submission compliance
- Consistency with strategic objectives
- Variance reconciliation and assumption documentation
- Produce budget analysis reports, including:
- Multi-year trend analysis (minimum 3 years)
- Cost driver analysis
- Scenario modelling (best / base / worst case)
- Strategic recommendations
C. Forecasting & Financial Reporting Duties
The Contractor shall:
- Maintain a rolling forecast model, updated monthly, integrating actuals and assumptions.
- Perform monthly variance analysis, including:
- Identification of deviations (cost, scope, timing, volume)
- Root cause analysis
- Corrective action recommendations
- Ensure production of audit-ready financial documentation, including:
- Methodologies
- Business rules
- Change logs
- Assumption tracking
D. Reporting, Analysis & Business Intelligence Duties
The Contractor shall:
- Gather, document, and validate business requirements for reporting and analysis.
- Translate business needs into dashboards, reports, and analytical outputs.
- Develop and maintain performance reporting tools, including visualization dashboards.
- Identify key performance indicators (KPIs) and improve data visibility and usability.
- Perform data validation and reconciliation across multiple systems.
- Support continuous improvement of reporting structures and analytical processes.
E. Stakeholder Engagement & Governance Duties
The Contractor shall:
- Conduct and support stakeholder workshops to capture and refine requirements.
- Maintain requirements traceability matrices.
- Document workshop outputs, decisions, and action logs.
- Support implementation of a data governance framework, including:
- Data ownership and stewardship model
- Data quality standards and validation rules
- Ensure compliance with defined data quality thresholds (≥95%).
2. DELIVERABLE RESPONSIBILITIES
The Contractor shall be responsible for producing the following categories of deliverables:
- Portfolio Register & Dashboards
- Portfolio Governance Reports
- Budget Planning Frameworks
- Consolidated Budget Submissions
- Budget Analysis Reports
- Rolling Forecast Models
- Variance Analysis Reports
- Audit-Ready Documentation Repositories
- Requirements Documentation & Traceability Matrices
- Data Governance Frameworks
All deliverables shall be accurate, version-controlled, and audit-compliant.
3. KEY REQUIREMENTS
3.1 Education & Experience
- Higher secondary education plus:
- Higher vocational training with 3 years relevant experience, OR
- Secondary education with advanced vocational training and 5 years relevant experience
3.2 Certifications
- Mandatory:
- Project Management certification (PRINCE2 or PMP or equivalent)
3.3 Technical Skills
The Contractor shall demonstrate proficiency in:
- Project Portfolio Management tools (e.g., ServiceNow, EBA)
- Financial systems (e.g., SAP, Oracle)
- Data visualization tools (Power BI, Tableau)
- Collaboration platforms (SharePoint, Skype, Polycom)
- Advanced Excel and reporting tools (Excel, Smartsheet, or equivalent)
3.4 Language Requirements
- English proficiency: Level 3333 (Listening, Speaking, Reading, Writing)
3.5 Professional Competencies
- Strong analytical and business analysis skills
- Ability to translate business needs into structured reporting outputs
- Strong written and verbal communication skills
- Ability to work under pressure and meet strict deadlines
- Ability to work effectively in multinational team environments
- Strong attention to detail and data accuracy
- Ability to manage multiple priorities simultaneously
4. PERFORMANCE EXPECTATIONS
The Contractor shall ensure:
- ≥95% deliverable timeliness compliance
- ≥98% portfolio data completeness
- Forecast accuracy within ±5% tolerance
- ≥95% data quality compliance
- Full audit traceability of all reporting outputs
- High stakeholder satisfaction (≥85%)