We are looking for a data or software engineer to design, build, integrate data from various resources, and manage database. You make sure that the database is easily accessible and the data flow works smoothly. For that you need to be able to write complex queries and also run some ETL (Extract, Transform and Load) on top of big datasets that can be used for reporting or analysis by others you are working with.
Based in Prague, male or female, full time
To serve the Lutheran World Federation (LWF) worldwide
The Lutheran World Federation (LWF) is a global communion of churches in the Lutheran tradition comprising 143 member churches in 79 countries all over the world. The department for World Service is the internationally recognized humanitarian and development arm of the Lutheran World Federation, assisting people in need irrespective of their ethnicity, religion or gender.
LWF World Service partners include Lutheran Churches and their related agencies, the European Commission (ECHO), the US Government (BPRM) and UNHCR among others, with whom LWF World Service is a key implementing partner. For more information about LWF World Service, please check: https://www.lutheranworld.org/content/world-service
LWF World Service implements programs globally, working with both local and international partners, helping communities achieve their full potential and advocate for their universal rights. It works in over 20 countries across the globe, implementing and monitoring more than 200 projects. These projects are hosted in so called Country Programs that have all decentralized and highly autonomous administrative structures. LWF has started a new initiative to digitalize data and adjust processes, including the move towards a new more centralized data management set up. In Uganda, we have started a pilot to develop and test the data management strategy that will be then rolled out later on.
The Country Programs have their own teams in place, but need global support in the new initiative.
LWF World Service is reinforcing its Quality Assurance and Accountability (QAA) team with a new position based in Prague. The position holder will be part of an international team working in many countries – supporting the field as well as headquarters.
If you are interested to join a highly motivated team and create a meaningful impact in humanitarian and development work, using your technical knowledge and talent, this could be a great opportunity to you.
Basic purpose
We are looking for a data or software engineer to design, build, integrate data from various resources, and manage database. You make sure that the database is easily accessible and the data flow works smoothly. For that you need to be able to write complex queries and also run some ETL (Extract, Transform and Load) on top of big datasets that can be used for reporting or analysis by others you are working with.
More concretely, you will work on collecting, storing, processing important sets of structured and non-structured data coming either through our project management system called Newdea or raw data from LWF field programs through KoBo tool kit – which is used for primary data collection in the humanitarian work or through Excel. Other sources of information are the finance and Human Resource System that will deliver a certain amount of data.
Starting date: As soon as possible
Location: Prague, with frequents travels to Geneva and field locations
Work time: 100%
Closing date for applications: to be determined with Diakonia
Basic position requirements
Master degree in big data engineering, software engineering, computer science or equivalent, complemented by relevant certifications
Minimum 3 years of professional experience
Required experience with integration tools (ETLs) and SQL;
Highly desirable experience with reporting tools and MS Excel
Successful experience in data management and database administration
Excellent interpersonal skills,
Ability to share and report on technical concepts to non-technical users
English fluent
Additional requirements
Flexibility and ability to work under time constraints
Self-starter, excellent organization skills and proactivity
Able to work within a virtual team in an international environment
Experience with a not-for-profit organisation, an asset
Availability to travel to Geneva and Eastern Africa
Main duties
Develop mechanism to extract, transform, clean, correct, aggregate, reject, approve data collected
Create data quality reports in a regular basis
Integrate and adjust business rules into ETL mechanism
Monitoring performance and advising any necessary infrastructure changes
Support the creation of operational and statistics reports as required
Position environment and dimensions
The position is remotely located in Prague and part of the wider Quality Assurance and Accountability Team managed out of Geneva, Switzerland, working for LWF World Service programs globally. The Diakonia XYZ will employ the successful candidate and second him-her to the LWF as Data Engineer. The reporting line is in Geneva.
Conditions
Duration of the contract: 2 years
Salary corresponding to the level of responsibilities 3000 EUR (tbc)
Only Czech nationals or with valid work permit in Czech Republic