HAYATA DESTEK DERNEĞİ / SUPPORT TO LIFE
www.hayatadestek.org / www.supporttolife.org
Data and Information Management Consultancy
Ref: 2019DIMC
As STL we are trying to make the best use of our humanitarian data to make more information. We are looking for a Data and Information Management Consultant to support our Information Management Team under MEAL Unit, to improve our database structure and to work with STL Information Management Officer to create PowerBI dashboards to better report and track the progress of STL projects. Working closely with MEAL Manager, MEAL Expert and IM Officer, this position will be located in the STL HQ in Istanbul and will report to the MEAL Manager.
The Data and Information Management Consultant contract will have two pillars: improving the beneficiary database design and continuously develop the database, and setting up a stable reporting system.
| Position: | Data and Information Management Consultant |
| Program: | PDQ |
| Manager: | MEAL Manager |
| Duration of Contract: | 2 December 2019 – 30 June 2020. (7 months) |
| Based: | Istanbul |
| Job Description: | Optimisation and modification of STL’s beneficiary database on CommCare to conform to the complexity of STL’s refugee protection and livelihood monitoring and evaluation, and serve to STL’s reporting needs on PowerBI. |
| Responsibilities |
The Data and IM Consultant will:
- Advise the IM Officer on how to structure and improve the beneficiary and the activities database to make best use of it
- Setting Power BI gateway to get the live data from STL database
- Improve and develop the Power BI reporting system and dashboards for STL Program Development and Quality Department
- Train the IM Officer on how to set up the reporting system to add the required reports when needed
The Consultant will provide:
- Monthly reports and presentations to MEAL Manager on 25th of each month.
- A final consultancy report and presentation to MEAL Manager on 24th June 2020.
| Qualifications |
The Data and Information Management Consultant is expected to have proficient knowledge and proven experience of CommCare database development, together with excellent analysis, data visualization and reporting skills to create a Power BI reporting front end.
CommCare Database design and data management skills, including
- Application Design:
- User management (both mobile and web)
- Group management
- Case sharing management (Organization structure and hierarchy)
- Web applications management
- Roles and permissions management
- Application creation
- Form design
- Case types and case properties management
- How to use User Properties effectively
- How to use hidden values effectively
- Knowledge of how to implement logic using the form builder tools
- Proficient experience in XPath syntax
- Look up tables management (create, add, and filter)
- Data Management:
- Know how to Export Data (both from Form and Case)
- Created daily saved report (and manage them)
- Create Excel dashboard integration (and manage them)
- Create the Connection between CommCare and the reporting system
- Proficient knowledge on reassigning cases, managing history, cleaning data, archiving and unarchiving the forms
- Bulk import, export
- Manage the forms
- Use the available API to modify previously entered forms
- Reporting from CommCare:
- Creating reports with the CommCare report builder
- Save reports and schedule periodic reports
- Monitor worker activities (via different factors)
- Manage the deployments of application, and both updating and synchronization process
Power BI experience of designing and creating reporting dashboards, including but not limited to:
- Connecting different types of data sources,
- Creating stable connection between CommCare and Power Bi (i.e. through SQL Server)
- Excellent knowledge of managing relationships between report tables
- Excellent knowledge of using of the available functions available in Power Bi, i.e. transformations, creating measures, calculated columns, appending and merging tables.
- Proficient query skills, can use the advance query editor effectively
- Highly skilled at using and training on Power Query & DAX languages to query data sources.
- Clean, load & analyze the data sources.
- Building reports with rich data visualizations
- Creating meaningful dashboards including regular information from reports to be viewed when requested.
Excellent business analysis and stakeholder management skills
At least 3 years substantive information management experience preferably in humanitarian response and refugee protection settings
Knowledge on donor reporting systems in humanitarian sector
Fluency in written and spoken English
It is highly recommended that the Applicant submits the details of relevant experiences in the tender file.
| Conditions |
· The duration of evaluation can be more than one month. The validity of the offer must be two months minimum.
· The quotations will be given in net TL terms per day.
· The proposal must be sent with CV.
· The applicant must issue invoices or self-employment receipts on his/her or his/her firm’s name.
· Travel, accommodation and etc. costs must be included in the proposal.
· Proposals with CV should be sent to [email protected] indicating the Reference number of this advertisement, by 29th November 2019. Submissions submitted after this specified period will not be evaluated.
- To help us track our procurement effort, please indicate in your email where you saw this tender posting.