2022-10-25

Information Management Analyst – Somali Cash Consortium – Mogadishu, Somalia

Mogadishu, Somalia
Posted on October 25, 2022

Concern Worldwide

Information Management Analyst – Somali Cash Consortium – Mogadishu, Somalia

Vacancy Announcement

Somali Cash Consortium – Information Management Analyst – Mogadishu Office

Job Title: Information Management Analyst – Somali Cash Consortium

Duration: One year with the possibility of extension

Grade: 6A

Reports to: Finance and Systems Director – Somali Cash Consortium

Responsible for: No direct reports

Exact job location: Mogadishu based, with semi-regular trips to partner offices across Somalia and Somaliland and Nairobi

Liaises with:· MEAL Manager

· Country, Regional and HQ ICT teams

· Outsourced database provider

Project explanation:

Concern Worldwide leads the Somali Cash Consortium. Consortium members include Concern Worldwide, Danish Refugee Council, Norwegian Refugee Council, ACTED, COOPI, Save the Children International and IMPACT Initiatives.

Since January 2018 the Somali Cash Consortium has supported over 1.5Mln vulnerable Somali individuals with unconditional mobile money transfers.

The Somali Cash Consortium is funded by Directorate-General for European Civil Protection and Humanitarian Aid Operations (ECHO), Directorate-General for International Partnerships (INTPA), Royal Danish Embassy (RDE) and Swedish Embassy along with other institutional donors.

Job Purpose:

The Information Management Analyst will manage the Consortium’s data and data systems. Managing data will involve requesting, receiving, cleaning, consolidating and visualizing data. Managing data systems will involve maintaining existing data systems and developing new systems and processes. The Consortium’s data systems primarily sit on Microsoft including Excel, Power BI, SharePoint PowerApps and the Common Data Service. Open Data Kit (ODK) runs on ONA. Red Rose and Teams also form an integral part of the system.

The role is part of the multi-disciplinary Consortium Management Unit (CMU).

Main Duties & Responsibilities:

Data protection

· Ensure Consortium team and partners collect, process, store and delete data in line with all relevant data protection legislation, including the EU’s General Data Protection Regulations (GDPR).

Red Rose Application support and maintenance

· Manage user access and user training

· Support beneficiary registration, verification and payment processes

· Troubleshooting and liaising with Red Rose support team as needed

· Archive data at end of the project

Dashboards

· Identify the need for new dashboards and work with intended users to design them

· Create Power BI dashboards (standard and paginated/pixel-perfect reports), following Consortium style guides

· Upload dashboards to Consortium’s Team’s portal and update access lists and controls as required

Data review and consolidation

· Receive Excel summary reports, review contents and revise with partner teams. Consolidate cleaned information manually, and visualize on existing using Power BI dashboards.

· Receive computer created reports, review and consolidate automatically using Power Query (in Excel, Power BI, Power Automate)

Data analysis

· Provide stakeholders regular and adhoc analysis as requested to help them understand programme process. For example the number of registrations completed in a community against target, efficiency and effectiveness of message broadcast mechanisms.

Data integration – Common Data Service

· The Consortium has built its management information into Microsoft’s Teams (CDS). The data inputs include:

o Red Rose application data

o Excel documents in SharePoint libraries

o ODK data accessible through ONA.io’s webAPI

o Data in CDS

o SharePoint list data and metadata

· Data from multiple sources will have to be combined for regular and adhoc reports – both from within and outside of CDS

Microsoft PowerApps

· The Consortium is leading the use of model-driven Microsoft PowerApps to clean registration data – this is being supported by an external provider

· The Information Management Analyst will take the lead on maintaining the App, with technical support provided by the external provider.

Support M&E tool design and data analysis

· The Information Management Analyst will support the MEAL manager with data analysis and design/improvements of M&E tools for the consortium.

· Support with beneficiary and survey data cleaning and sharing with the MEAL Manager for further analysis

· Support with conducting surveys and verification checks

· Support the MEAL Manager to conduct duplication checks and approval of payment lists

PDF form storage on SharePoint lists

· Support programme teams who store PDF forms attached to SharePoint lists

· Create new and maintain existing SharePoint lists, for example updating parameters, adding columns (including calculated columns and lookup fields) and updating access controls

· Provide adhoc visualizations based on SharePoint list data to enable programme teams to understand progress against targets

Skills and Qualifications

Required

· Degree in Computer Science / ICT / Information Management or similar

Desired

· Microsoft Office certifications, from Microsoft or authorized third-party trainer in: Excel; Power BI; SharePoint (cloud); Power Apps; Power Automate; Common Data Service

Skills

Required

· Advanced Excel, including Pivot tables and Power Query

· Power BI; data loading, visualization and publishing

· Managing SharePoint document libraries

· Knowledge of Microsoft’s Common Data Service

· SharePoint administration

· Data system architecture design

· System documentation and guidance note drafting

· Web development using HTML

Desired

· Experience building and maintaining model-driven PowerApps

· Red Rose or similar beneficiary maintenance applications

· Use and knowledge of M&E tools including those for GIS Mapping and surveys

Experience

Required

· At least 5 years’ experience in managing an organization’s data and data systems

· Experience of rolling out multi-location ICT services

· At least 5 years’ experience in using Microsoft data ecosystem, and tools including Excel, Power BI, SharePoint online, Power Apps, Power Automate (Flow) and Common Data Service

· Experience of working in complex, insecure environment

· Flexibility including willingness on occasions carry out additional duties and tasks as required, to adapt to a changing operational environment.

· Fluent spoken and written English and Somali

· Ability and willingness to communicate confidently and flexibly, choosing the most effective means, including emails, phone, Skype and in-person.

Other

· Adhere to the standards of conduct outlined in Code of Conduct (CoC) with Associated Policies; the Programme Participant Protection Policy (P4), the Child Safeguarding Policy and the Anti-Trafficking Policy.

· Support and promote the standards outlined in the Concern Code of Conduct and related policies to the team, partner and stakeholders and be committed to providing a safe working environment.

· Actively participate in Concern accountability initiatives (communication strategy, participation and CRM for example) ensuring that they are integrated into the project

· Undertake other related duties as may reasonably be assigned by the Finance and Systems Director.

Accountability

In line with Concern’s commitments under the Core Humanitarian Standard (CHS):

· actively promote meaningful community participation and consultation at all stages of the project cycle (planning, implementation, M&E);

· work with relevant colleagues to ensure that the Complaints and Response Mechanism (CRM) is functional and accessible, that feedback and complaints are welcomed and addressed;

· Work with relevant colleagues to ensure that information about CRM, safeguarding and expected staff behaviour is disseminated among programme participants and communities.

Concern’s Code of Conduct (CCoC) and its associated policies

Adhere to the standards of conduct outlined in the (1) Programme Participant Protection Policy; (2) Child Safeguarding Policy; and (3) Anti-Trafficking in Persons Policy.

Concern Code of Conduct and its Associated Policies

Safeguarding Policy and the Anti-Trafficking in Persons Policy. These have been developed to ensure the maximum protection of programme participants from exploitation, and to clarify the responsibilities of Concern staff, consultants, visitors to the programme and partner organisation, and the standards of behaviour expected of them. In this context, staff have a responsibility to the organisation to strive for, and maintain, the highest standards in the day-to-day conduct in their workplace in accordance with Concern’s core values and mission. Any candidate offered a job with Concern Worldwide will be expected to sign the Concern Staff Code of Conduct and Associated Policies as an appendix to their contract of employment. By signing the Concern Code of Conduct, candidates acknowledge that they have understood the content of both the Concern Code of Conduct and the Associated Policies and agree to conduct themselves in accordance with the provisions of these policies. Additionally, Concern is committed to the safeguarding and protection of vulnerable adults and children in our work. We will do everything possible to ensure that only those who are suitable to work or volunteer with vulnerable adults and children are recruited by us for such roles. Subsequently, working or volunteering with Concern is subject to a range of vetting checks, including criminal background checking.

How to apply

Interested candidates, who meet the above requirements, should submit their applications (cover letter and updated CVs) by email to som.vacancies@concern.net with the subject line “Programme Manager- Somali Cash Consortium Management Unit” by Tuesday 8th November 2022.

ONLY shortlisted candidates will be contacted for the written test and interview.

Female candidates are strongly encouraged to apply.

………………………………………………………………………………………