BUSINESS INTELLIGENCE AND INFORMATION MANAGEMENT TECHNICIAN (BASED IN BARCELONA)

GENERAL CONTEXT

Médecins Sans Frontières is an international independent medical-humanitarian organization, which offers assistance to populations in distress, to victims of natural or man-made disasters and to victims of armed conflict, without discrimination and irrespective of race, religion, creed or political affiliation.

MSF is a civil society initiative that brings together individuals committed to the assistance of other human beings in crisis. As such MSF is by choice an association. Each individual working with MSF does it out of conviction and is ready to uphold the values and principles of MSF. The MSF movement is built around six operational directorates. MSF OCBA is one of those directorates.

The operations are implemented by field teams and the mission coordination teams; together with the organizational units based in Barcelona and decentralized in Nairobi, Dakar and Amman. The field operations are guided and supported by 5 Operational Cells, the Emergency Unit and other departments supporting operations, including the Project & IT Department.

DESCRIPTION OF THE POSITION

MSF-OCBA is continuously adapting processes and tools to improve efficiency and quality of data and information management. In the framework of the MSF-OCBA Strategic Plan, in general, and aligned with the objectives of the Projects and IT department, in particular, BI and Information Management Technician will participate in consolidating the Information Management and Business Intelligence team as a key partner for our internal customers by:

• Modernizing and streamlining its platforms and processes in order to harmonize them with the latest working paradigms and technologies. The P&IT department is heavily investing in the creation of state-of-the-art collaborative environments to support the organization´s goals regarding information sharing and cooperation, always propped up by the right set of applications and platforms.
• Ensuring the integrity of the Organization and its stakeholders’ information. Not only the information has to be consistent, available and accurate, but also it has to be secure.
• Providing all the stakeholders within the Organization with easy to access and reliable tools using the latest technologies resulting in scalable and high-performing platforms.

This job opening is a challenging and exciting opportunity to help the Projects and IT department stir MSF-OCBA towards a more data-driven culture, using the above-mentioned objectives as guidelines. Being part of this process will give the incumbent a chance to support the technology transformation within an international organization in the humanitarian sector.

GENERAL OBJECTIVE

Participate in the transformation of MSF-OCBA into a genuinely data-driven organization by applying the latest Information management and Business Intelligence technologies, tools and techniques to the existing portfolio of IT applications and services. Additionally, provide a hands-on support to the daily operations and maintenance tasks of a set of database platforms.

PLACEMENT WITHIN THE ORGANISATION

The BI and Information Management Technician will work within the PMO team, part of the Projects & IT department. S/he will report to the Head of PMO & IT Governance.

S/he will work closely with the members of the P&IT team and especially the Information Management Manager and the Business Intelligence Manager.

The BI and Information Management Technician will work closely with different internal clients, e.g. Medical, Finance, Operational and HR departments, at the headquarters and with field missions and decentralized offices. Occasionally, s/he will also cooperate with third-party service providers supporting the department´s infrastructure and operations on a day-to-day basis.

MAIN RESPONSIBILITIES AND TASKS

With the support and guidance of the Information Management Manager and the Business Intelligence Manager, the incumbent is expected to:

• Provide first level service for our internal users and stakeholders by providing appropriate and timely support.
• Train internal users and stakeholders for proper adoption and usage of BI, Analytics & IM services and tools.
• Treat user and organization information following internal confidentiality and security policies, i.e. manage permissions, program and execute regular database backups, integrate General Data Protection Regulations, etc.
• Propose feasible solutions to setbacks and unforeseen issues based on own experience and independent research of technologies related to Information and Business Intelligence platforms.
• Act with professionalism and represent MSF values under any circumstances.

Related to Business Intelligence:

• Develop and maintain periodic and ad-hoc reports, dashboards and datasets, ensuring consistency with customer requirements and the policies of the Organization.
• Guarantee that the reports, dashboards and scorecards are presented to the final customer using relevant and accurate data. Additionally, guarantee that they run smoothly and are delivered using the appropriate communication channels.
• Daily monitor, maintenance and fix issue of ETL and ELT systems developed in Business Intelligence and Analytics projects.
• Respond to the internal customers’ queries and use Reporting technologies and tools to translate raw data into sound reports and meaningful information understanding customers necessities.
• Support the implementation of a new end to end BI projects (ETL/ELT, data modeling, data warehousing and reporting) based on Microsoft technologies (on Microsoft cloud).
• Write SQL queries in data warehouse to analyse data before to arrive to reporting system.

Related to Information Management:

• Carry out the maintenance tasks in the different repositories, portals and digital workspaces of the organization (based on SharePoint, Teams and OneDrive) to ensure proper operation.
• Carry out the first level support to final users’ incidences, requests and improvements. And maintain the related knowledge base.
• Create the final users training contents and coordinate with the P&IT Learning Referent to carry out adoption and training programs for final users on new solutions and procedures related to the information management process and technologies.
• Implement and maintain OCBA’s document management and information standards, together with their owners, to guarantee their integration, use and adequate internal and intersectional interconnection.
• Participate in the validation tests of the solutions and information management procedures.
• Promote that the transversalities with other departments and processes are adequately treated to find the most efficient solutions.

SELECTION CRITERIA

• Languages: Fluent in Spanish and English. French highly desirable.
• 1-2 years of experience working with Microsoft 365 ecosystem, e.g., SharePoint Online, Teams, PowerApps, etc.
• 1-2 years of experience querying with SQL language.
• 1-2 year of experience in data warehousing and data modeling.
• 1-2 years of experience working with some reporting tool (Microsoft PowerBI would be desirable but other like Tableau, QlikView would be ok).

Desirable:

• University Degree, preferably related to engineering (Computer Sciences, Telecommunications, Industrial Engineering, Computer Technician, or similar), library or archival science.
• 1-2 years of experience maintaining ETL and ELT systems (preferably Azure Data Factory).
• 1-2 years of experience working with Documents Management or Digital Archives. e.g. SharePoint, Alfresco… an advantage.
• Experience applying mathematical and statistical models to carry out historical data analysis and provide data-driven trends when possible.
• Experience developing database solutions at a business level using Microsoft technologies, i.e. SQL Server and Azure SQL database.
• Experience working in a project/environment that used any agile framework.

COMPETENCIES

• Commitment to MSF’s Principles
• Cross-cultural Awareness
• Behavioural Flexibility
• Stress Management
• Analytical Thinking
• Results and Quality Orientation
• Service Orientation
• Planning and Organising
• Teamwork and Cooperation

CONDITIONS

• Position based in Barcelona MSF-OCBA headquarters.
• Full-time.
• Contract duration: permanent contract – minimum commitment of 3 years.
• Annually gross salary: HQ 3A (divided in 12 monthly payments) + secondary benefits based on MSF-OCBA Reward Policy. Subjected to local conditions.
• Starting date: immediately.