Position: Data Engineer
Category: Data Engineer
English level: fluent
Years of experience: 6


Data Ingestion: Pulling data from various platforms and databases 

Data Cleaning and Triangulation: Data validation and reconciliation to ensure accuracy. 

Data analysis and visualization: creating interactive dashboards for internal and external stakeholders 

Designing database queries: Prepare advanced SQL scripts to extract Cardano blockchain data for various purpose
Pull data from various online and offline data sources into staging database and setup automatic incremental refreshing scheme. 
Design data cleaning protocol and apply in data cleaning packages.

Design and implement ETL (Extract Transform and Load) packages for data cleaning, flagging, and transforming on recommended tools including SQL Server Integration Services (SSIS) or Pentaho Data Integration (PDI).  
Analyze project data and design complex queries to extract data per project reporting demand. 

Design reports and dashboards to support management decision making and adaptive learnings. 

Lead data reconciliation meetings with project stakeholders to ensure all data is on expected level of quality and quantity.  
Design and implement innovative ICT4D solutions including web application  

Support capacity building efforts in utilization of ICT4D tools and reports.