Information Management Consultant at Concern Worldwide

Deliverables

Data review and consolidation

• Provide IM services to the CWG which will include managing the IM tools, data collection, cleaning, collation, analysis and dissemination processes relevant to the needs of CVA
• Organize and manage the data input and initial analysis and presentation of data for CVA
• Establish, collect information for and maintain the Who does What Where and When (4W) database and derivative products, such as maps and dashboards
• Compile all the cash data from REACH and OCHA, and submit clean data to HDX for visualization

Data analysis

• Provide stakeholders regular and adhoc analysis as requested to help them understand CVA response in country

Engagements

• Work closely with REACH to ensure the submitted MPCA and Safety nets cash data is clean and accurate
• Work closely with the OCHA IMO to ensure the submitted sectoral cash data is clean and accurate
• Liaise with OCHA HDX to ensure the monthly mapping of CVA is up to date
• Respond to the working group membership’s needs for information on an ongoing basis
• Liaise with OCHA and IM Focal Points in other clusters/sectors – share information as appropriate and identify and gather information from other sectors which can inform CVA

Representation

• Represent the CWG in any IM fora

Dashboards and Websites

• Identify the need for new dashboards and work with intended users to design them
• Ensure that the CWG website is kept up to date
• Any other tasks that may be required (within reason) to achieve the objective of this assignment.
• This position shall be reporting to Somali Cash Consortium Programme Coordinator/Somalia Cash Working Group Co-chair; based either in Mogadishu or Nairobi based, with regular trips to Somalia and/or Nairobi.

The position shall also liaise with

• SCWG Partners
• WFP and OCHA as part of the CWG leadership
• Outsourced database provider

Duration

• 4 months with the possibility of extension

Desired Qualifications

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

• Building and maintaining model-driven PowerApps
• Client-side SIP/VOIP system setup and maintenance

Experience Required

• At least 5 years’ experience in managing an organisation’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.