Reports to: IT Manager

Location: Cairo, Egypt

Main purpose of position

The Software and BI Specialist is responsible for full stack development and support of enterprise applications, including middleware and APIs, and database administration, Extract, Transform, and Load (ETL), reporting, and BI operations. While this role is focused on software and applications, it is a requirement that this role understands and contributes where possible to the infrastructure and operations of IT.

This role may involve supervising one staff member and may necessitate national and/or international travel around an equivalent of 10% FTE annually.

About ICARDA

The International Center for Agricultural Research in the Dry Areas (ICARDA) is a treaty-based international non-profit research organization supported by CGIAR.

ICARDA’s mission is to reduce poverty, enhance food, water, and nutritional security, as well as environmental health in the face of global challenges including climate change. We do this through innovative science, strategic partnerships, linking research to development and capacity development that take into account gender equality and the role of youth in transforming the dry areas. ICARDA works in partnership with governments, universities, civil society, national agricultural research organization, other CGIAR Research Centers, and the private sector. With its temporary Headquarters in Beirut, Lebanon, ICARDA operates in regional and country offices across Africa, Asia, and the Middle

East. For more information: www.icarda.org

All CGIAR Centers are currently engaged into a reform process (“One CGIAR’”) that will help ICARDA and CGIAR achieve better impact through more strategically integrated research, unified governance, an integrated structure, and new research modalities across participating Research Centers. This transformation is supported by CGIAR donors who have committed to increased funding as a result of these reforms.

Main responsibilities

Software Development

• Responsible for software analysis, development and deployment of lifecycle using agile and DevOps methodologies and techniques.

• Develop full stack tools that support enterprise applications (e.g., middleware and APIs).

• Handle software testing and source control.

• Administer, manage, and query databases including DML, DDL, and SQL.

• Apply ETL concepts and develop Dashboards using BI tools.

Enterprise Applications

• Support the Enterprise Resource Planning (ERP), Enterprise Document Management System EDMS, and other enterprise systems.

• Respond to business requirements (Finance, HR, Procurement, Project Management, etc.) by developing reports and alerts using SQL scripts and routines and ERP configurations.

• Ensure that external/internal regulations and policies governing data management are met, including regulations concerning security, audit, and privacy.

• Work with the ICT team in supporting users by identifying, troubleshooting, and resolving hardware, software, and network related problems encountered by users.

• Provide feedback, oversight, and support for ICARDA research projects that have a digital component.

• Provide first and second level applications support to all users.

• Coordinate, collaborate, and support the OneCGIAR Digital and Data team.

• Assist in documenting business processes, procedures, standards, and guidelines.

• Liaise with vendors for 3rd level support.

Resilience and Security Administration

• Implement and support cyber security guidelines.

Monitoring and Problem Management

• Provide support to level 1 support operations.

• Provide support to help desk platform administration.

Asset Management

• Contribute to license management.

• Contribute to the procurement, receipt, delivery, disposal, and maintenance of IT inventory.

Additional Tasks

• Performs any additional related tasks requested by the supervisors.

Requirements

Education, qualifications, and experience

• Bachelor’s degree in computing, Informatics, or equivalent.

• More than 5 years preferably in .Net framework with API, SAML, and O365 integration, including at least 2 years in SQL query development and fine tuning, PowerBI or similar BI Tools, source control (e.g., GIT), Apache, IIS, DNS, and CDN tools.

• More than 2 years in remotely supporting international end users of all organizational levels, mainly within MS Windows environment.

• Experience in Enterprise Resource Planning (ERP), Enterprise Document Management (EDM) DevOps is a plus.

• Proven knowledge of cybersecurity concepts including software hardening and countermeasures against common web attacks.

• Proficiency in spoken and written English is a must.

• Understanding of financials, procurement, HR, and project management.

• Experience with data warehouse development and related ETL concepts.

• Experience with big data, blockchain, and other emerging technologies.

• Good understanding of agile project lifecycle and related topics.

• Certifications in any .Net, MSSQL, PowerBI, or similar Areas.

• Attention to details and ability to handle sensitive information properly.

• Excellent interpersonal skills with ability to interact culturally, linguistically, and diplomatically with diverse internal and external individuals.

Benefits

Terms of appointment, salary, and benefits

This is a nationally recruited position for which ICARDA offers an attractive compensation package including a competitive salary, medical insurance, 30 days of annual leave, five months’ maternity leave, 15 days’ paternity leave. The successful candidate will be offered an initial contract of 3 years, renewable subject to continued need for the position and satisfactory performance. The first year will be probationary period.

Please be informed that this is a re-advertisement, and applicants who have applied previously are kindly requested not to reapply.

ICARDA is committed to increasing women representation in its workforce and strongly encourages applications from women.

Applications will be acknowledged, but we apologize in advance as due to the large number of applications only shortlisted candidates will be contacted.