Data/BI Engineer

Огляд

Mercy Corps is a leading global organization powered by the belief that a better world is possible. In disasters and hardships in more than 40 countries around the world, Mercy Corps partners to put bold solutions into action—helping people triumph over adversity and build stronger communities from within—now and for the future.

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.

Обов'язки

Data Engineering & Azure Development

• implementing and managing analytical infrastructure on Azure to support the Resilience portfolio data architecture, including centralizing data from multiple sources (e.g., Good Grants, CommCare) for efficient retrieval and analysis
• collaborating with MEL teams and data analysts to extract, transform, and load data from diverse sources using tools like SQL and Python
• supporting data visualization efforts by integrating data into tools like Microsoft PowerBI
• working with other data engineers to implement algorithms for statistical analysis, prediction, and machine learning
• coordinating with the Mercy Corps IT team to integrate Azure solutions with SSO technology, connect third-party data sources, and maintain data access permissions
• designing and creating PowerBI reports based on stakeholder requirements
• managing Azure infrastructure for reporting and analytics
• administering PostgreSQL databases, including managing materialized views, regular views, stored procedures, triggers, and optimizing performance
• maintaining effective collaboration with the IT Team and other stakeholders

Data Security & Best Practices

• ensuring compliance with Mercy Corps’ Responsible Data Policy and best practices in humanitarian data protection
• implementing robust security protocols for sensitive data stored on Azure
• adhering to security procedures and policies defined by country leadership
• working with Mercy Corps teams to adopt and promote best practices in data reporting, analysis, and science

Вимоги

• at least 2 years of relevant experience
• proficiency in SQL, with experience in PostgreSQL as a plus
• understanding of database administration, including managing user access, backup and recovery, and performance tuning
• experience with database development, including creating materialized views, regular views, stored procedures, and triggers
• proficiency in Python, with experience in libraries such as Pandas and NumPy
• experience automating data processes and workflows
• familiarity with Git for version control
• strong analytical, statistical, and quantitative problem-solving skills
• working proficiency in written and spoken English
• experience creating and managing dashboards, preferably in PowerBI will be an advantage
• hands-on experience with Azure Data Factory, Azure Data Lake Storage, Azure SQL, Azure Databricks, and Azure Synapse will be an advantage
• experience deploying automation scripts will be an advantage
• practical knowledge of database, data lake, and data warehouse concepts, with experience in implementing data management systems will be an advantage
• experience in international relief and development programming, particularly in MEL or program management functions, will be an advantage
• familiarity with mobile data collection platforms (ODK, ONA, Kobo, CommCare) will be an advantage
• experience working with geospatial data will be an advantage

Умови

• full-time employment in Kyiv
• the opportunity to work in a dynamic and mission-driven organization
• professional growth in a globally recognized environment