Будь ласка, надсилайте свої резюме: Data/BI Engineer | Mercy Corps Ukraine (ultipro.com)
About Mercy Corps:
Mercy Corps is a leading global organization powered by the belief that a better world is possible. In disaster, in hardship, in more than 40 countries around the world, we partner to put bold solutions into action — helping people triumph over adversity and build stronger communities from within. Now, and for the future.
General Position Summary:
The Data Engineer will be on the team supporting Microsoft Azure development within the data analysis and automation team. He/She will be responsible for building and iterating Azure data pipelines and databases, providing input into iterations on current Azure architecture design, and supporting response data analysts, Monitoring, Evaluation, and Learning (MEL) team, and other data engineers in using the Azure data systems for program decision-making.
In addition to these responsibilities, the Data Engineer will be tasked with automating processes across various systems, independently gathering all necessary requirements for automation, and ensuring the implementation aligns with organizational goals. The Data Engineer will also be responsible for creating and maintaining dashboards using Power BI, allowing key stakeholders to visualize and interact with program data effectively.
He/She will work collaboratively with Mercy Corps' MEL and IT teams, as well as consortium partners, to coordinate architectural choices and data standards, translate policies (e.g. data protection policy) into pipeline structures, and train parties within Mercy Corps on how to understand and access the Azure systems.
Essential Responsibilities
Safeguarding Responsibilities
- Actively learns about safeguarding and integrates it into their work, including safeguarding risks and mitigations related to their area of work.
- Practices the values of Mercy Corps including respecting the dignity and well-being of participants and fellow team members.
- Encourages openness and communication in their team; encourages team members to submit reports if they have any concerns using reporting mechanisms e.g., Integrity Hotline and other options.

Main Responsibilities
1. Data Engineering & Azure Development
- Implement and manage analytical infrastructure on Azure in support of the programs under Resilience portfolio data architecture, centralizing program data from multiple sources (e.g. Good Grants, Commcare) and organizing it for efficient retrieval and analysis.
- Work with the MEL team and data analysts within Resilience programs to extract, transform, and load data from a wide variety of data sources using tools like SQL, Python; Support efforts to surface data to external tools, including Microsoft PowerBI.
- Collaborate with other data engineers to implement algorithms for statistical analysis, prediction, and machine learning.
- Coordinate with the Mercy Corps IT team as needed, especially to integrate Azure solutions with Mercy Corps SSO technology, integrate with third party data sources, and maintain data access permissions across the data lifecycle.
- Design and implement PowerBI reports based on stakeholder requirements.
- Implement and manage Azure infrastructure in support of reporting and analytics.
- Administer PostgreSQL databases, including creating and maintaining materialized views, regular views, stored procedures, triggers, and optimizing database performance.
- Coordinate with the Mercy Corps IT Team and others as needed.

2. Data Security & Best Practices
- Implement data protection measures within Azure in compliance with Mercy Corps' Responsible Data Policy and with humanitarian data protection best practice.
- Implement and maintain robust security protocols for sensitive and confidential data on Azure.
- Ensure compliance with security procedures and policies as determined by country leadership wherever implementations are conducted
- Collaborate with the other Mercy Corps teams to recognize and help adopt best practices in reporting, analysis, and data science.

Accountability to Participants and Stakeholders
Mercy Corps team members are expected to support all efforts toward accountability, specifically to our program participants, community partners, other stakeholders, and to international standards guiding international relief and development work. We are committed to actively engaging communities as equal partners in the design, monitoring and evaluation of our field projects.
Minimum Qualification & Transferable Skills
Any skills you have gained through education, volunteer, work, or life experience that are relevant for the position will be considered. Be sure to fully explain transferable skills and success factors and how they apply to this position in your cover letter.
Required
- 2 years of relevant experience.
- Proficient in SQL. Experience with a PostgreSQL is a plus.
- Understanding of Database Administration (e.g., managing user access, backup and recovery, and performance tuning).
- Experience with Database Development, including creating and maintaining materialized views, regular views, stored procedures, and triggers.
- Proficient in Python with experience in data analysis libraries such as Pandas and NumPy.
- Experience in automating data processes and workflows.
- Familiarity with using Git for version control.
- Ability to apply analytical, computer, statistical and quantitative problem-solving skills.
- Working proficiency in written and English required. Preferred
- Experience in dashboard creation and management, preferably in PowerBI.
- Specific experience with Azure Data Factory, Azure Data Lake Storage, Azure SQL, Azure Databricks, and Azure Synapse is strongly preferred.
- Experience with deploying automation scripts.
- Experience with database, data lake, and data warehouse concepts and practical experience in implementing data management systems is strongly preferred.
- Experience in international relief and development programming; especially in MEL or program management functions is an asset.
- Familarity with mobile data collection platforms and tools (ODK, ONA, Kobo, CommCare) would be an asset, but not required.
- Experience working with geospatial data is preferred.

Success Factors
The successful candidate will have strong practical experience in building data infrastructure in Azure, or will have comparable experience in other cloud environments and a willingness/capacity to learn how to translate that experience into Azure. He/She will have a personal commitment to data quality and security, and an understanding of or interest in learning about humanitarian data protection requirements. He/She will be able to work collaboratively with internal teams of varying technical capacities and with peers in partner organizations, and will be a supportive resource for colleagues collecting, storing, and analyzing data. He/She will be an independent problem solver while also ensuring that country/program needs drive the work conducted.
He/She will further act in an ethical manner at all times regarding the privacy and security of program participant data, communicate ethical concerns up the chain of responsibility, and ensure the concerns are resolved appropriately.
Living Conditions / Environmental Conditions
This position can be based in Kyiv, Dnipro or Lviv Ukraine, but location is subject to reassessment given the dynamic context. Accommodations are being defined and access to services — medical, electricity, water, etc is in place but may change depending on the situation. There are no travel requirements at this time, though travel may be required for program support purposes in future due to the rapidly changing nature of the Ukraine conflict. During the field trips living conditions will be adjusted to the field conditions. Safeguarding & Ethics
Mercy Corps is committed to ensuring that all individuals we come into contact with through our work, whether team members, community members, program participants or others, are treated with respect and dignity. We are committed to the core principles regarding prevention of sexual exploitation and abuse laid out by the UN Secretary General and IASC and have signed on to the Interagency Misconduct Disclosure Scheme. By applying for this role an applicant confirms that they have not previously violated an employer’s sexual misconduct, sexual exploitation and abuse, child safeguarding or trafficking policy. We will not tolerate child abuse, sexual exploitation, abuse, or harassment by or of our team members. As part of our commitment to a safe and inclusive work environment, team members are expected to conduct themselves in a professional manner, respect local laws and customs, and to adhere to Mercy Corps Code of Ethics Policies and values at all times. Team members are required to complete mandatory Code of Conduct eLearning courses upon hire and on an annual basis.
As an applicant, if you witness or experience any form of sexual misconduct during the recruitment process, please report this to Mercy Corps Integrity Hotline ([см. контактную информацию ниже]).
Тільки попередньо відібрані кандидати будуть запрошені на співбесіду.
Ласкаво запрошуємо осіб з інвалідністю та ветеранів відгукнутись на цю посаду.
Mercy Corpsстворило робоче місце для працевлаштування осіб з інвалідністю та ветеранів, та належні умови праці для цієї вакансії, але це не обмежує коло осіб, які можуть подаватись на цю вакансію.

Контактна інформація →