Data Analyst

Selection of staff is made on a competitive basis, and we are committed to promoting diversity and gender balance

**Job Title**: Data Analyst - SCOPE Business Intelligence

**Type of Contract**: Consultant Level II

**Division**: TECX

**Duty Station**:This position is remote

**Duration**: 11 months

**ORGANIZATIONAL CONTEXT**:
The United Nations World Food Programme (WFP) is the world's largest humanitarian agency, fighting hunger worldwide. WFP Technology Division (TEC, formerly known as IT) is the digital business engine of the World Food Programme, providing the business with multi-pronged and resilient technical capabilities able to respond with the agility required in humanitarian operations, be they man made or in a natural disaster setting. TEC Division continues to increase its activities to meet the constantly growing demand from the organization and implement the initiatives related to information and technology.

Cash Based Transfers is a pillar is WFP’s assistance to vulnerable populations. Data generated by WFP’s operations is key to supporting activities and stretching donations to meet growing demands. Currently, a main technology platform uses SAP HANA for business intelligence. A Data Analyst is required to support requests, troubleshoot issues, review business logic, validate transformations and work with our vendor to manage the escalation backlogs and close request tickets.

Combining expert knowledge of SAP HANA, data integration and Tableau, and functional knowledge of Cash Based Transfers, the incumbent will report to the SCOPE Business Intelligence Service Manager. The main goals of this role are to generate and communicate data-driven analyses and insights in support of decision-making processes.

**ACCOUNTABILITIES/RESPONSIBILITIES**:
**Source System**:

- Understand the data schema of the source system (SCOPE) and the replica database.
- Work with the database administrators to troubleshoot potential issues between the replica database and SAP HANA instances.
- Recommend remedial actions and follow-up to ensure activities are completed.

**SAP HANA Instances**:

- Review and develop a thorough understanding of the SAP HANA instances for SCOPE and the underlying data models.
- Understand the WFP terminology associated with Cash Based Transfers and ensure standard terminology is used in SAP HANA instances.
- Support a standard process for receiving end-user requests and incidents, triaging, initial root cause analysis, escalation to LTA vendors and SCOPE team and closure.
- Receive requests and incidents and triage appropriately. Where possible, resolve requests and incidents (otherwise escalate)
- Together with SCOPE BI Manager, analyse and troubleshoot incidents.
- For Change Requests, escalate requests to LTA vendor and SCOPE BI Manager for estimations.
- Review LTA vendor estimates, business logic and analysis to optimize quality and proper approach to resolving incidents and implementing change requests.
- Where required, implement fixes and changes as required.
- Support business validation process, as required.
- Support and provide expert advice for business continuity planning and SCOPE BI roadmap discussions/plans.
- Ensure alignment on key figures so that analyst teams are using the right data for their reporting requirements.

**Data Integration**:

- Troubleshoot integration issues between SAP HANA and DOTS, API Gateway, Tableau and SCOPE systems.
- Ensure the endpoints for each system is monitored and available.
- Provide recommendations to system teams.

**DELIVERABLES**:

- Provide expert advice on the data model and business logic used in SCOPE SAP Hana instances to support end-user requests and incidents.
- Provide 1st level support and triaging for new SCOPE BI requests/incidents and make informed decisions to escalate ticket to other teams. Follow-up to ensure closure of tickets.
- Review and provide recommendations for optimizing data models in SCOPE SAP HANA instances. Look for re-factoring opportunities to increase the business value of the HANA instances.
- Provide data analysis and validation for change requests and fixes to ensure key figures are properly managed and shared.
- Troubleshoot integration issues with system and business focal points
- Mentor and coach junior data analysts not familiar with the underlying data models and logic to assist in the maturing of their capabilities related to the Cash Based Assistance data domain.
- Develop and implement various analysis, reporting and quality control capabilities
- Assist in the development of business continuity plan and SCOPE HANA product roadmap

**QUALIFICATIONS & EXPERIENCE REQUIRED**:
**Education**:
Advanced university degree (Master’s degree or equivalent) in computer science, data science, analytics, statistics, information management, public administration, management or a related field. A first-level university degree in combination with qualifying experience may be accepted in lieu