Business Intelligence Specialist

Project Overview

Medair’s Global Support Office (GSO) provides operational guidance for country programmes, along with both technical and compassionate support for our relief workers. Within our headquarters and affiliate offices, we are also responsible for promoting the work of Medair to the world, to raise and manage the funds needed to run our life-saving and sustaining programmes, and to recruit international and HQ staff.  

Global ITS provides Medair with centralised governance, strategy, direction, innovation and support in the use of the information technologies that amplify the people to people strategy. Global ITS provides a centralised approach to ensure cost efficiency and integration, including country programs in the strategic design of systems, and delivers services locally where practical to ensure that the day-to-day needs of our GSO and country program colleagues are met.   

The BI function will support Medair’s Global Support Office (GSO) and country programs to guarantee that the collected data is available and can be analysed in order to reduce paper work and manual effort, while increasing response time, and improving delivery speed. 
 

Key Activity Areas

Technical BI Development  

Understand, design and implement visually appealing reports and dashboards (Qlik, Unit 4, Power BI).  

Design publish comprehensive and understandable business performance indicator dashboards for end users.  

Create tools to analyze and find trends from various data coming from Medair’s systems and field locations.  

Create effective queries for improved performance and outcomes.  

Ensure that end-users will only have access to their own data.  

Contribute to data-driven decision-making.   

Data Engineering  

Design relevant data-models in order to report from multiple systems and data sources.  

Ensure coherence in data models and information flow between different systems.  

Create scripts or batches to consolidate diverse data sources in a coherent manner.  

Create and maintain optimal data pipeline architecture.   

Assemble large, complex data sets that meet functional / non-functional business requirements.  

Build the infrastructure required for optimal extraction, transformation, and loading (ETL) of data from a wide variety of data sources using Boomi technology.   

Collaborate with the Snr Data Engineer to build the data structure on Snowflake Warehouse for reporting.  

Maintain data architecture for Business Intelligence so it can scale with evolution of server architecture.  
 

Report Design and Support 

Coordinate with requestors for the detailed and correct report requirements.  

Coordinate with the Snr Data Engineer to ensure that the required data for reporting is available.   

Optimise the data flow and collection for cross functional teams.  

Work with end users to ensure ease of use, intuitiveness and understanding of reports / dashboard created.  

Collaborate in the implementation of new modules / applications by:  

Providing guidance  

Advising end-users and collaborate vendors  

Provide end-users with second level support for reports.  

Responsible for ensuring the maintenance of the reporting servers.  
 

Innovation/changes 

As an ‘agent for change’ find new and better ways to provide Medair users with the reports and tools they need to drive decision making. 
 

Team Spiritual Life  

Reflect the values of Medair with team members, local staff, beneficiaries, and external contacts. 

Work, live, and pray together in our Christian faith-based team settings. Fully contribute to the rich spiritual life of your team, including team devotions, prayers, and words of encouragement. 

Encouraged to join and contribute to Medair’s international prayer network. 

This job description covers the main tasks that are anticipated. Other tasks may be assigned as necessary. 
 

• All new deploying international staff to Medair’s country programmes (and other roles which require field travel) should be fully vaccinated with a WHO-approved COVID vaccine, supported with a COVID vaccination certificate as evidence.