Organizational Context

Background to the position

In virtually all countries, people increasingly rely on and expect a diverse range of digital services (e.g., through their mobile devices) to interact with local governments, companies, and community organizations and services. This disruption is already happening to humanitarian assistance. Yet, the Digital Divide remains a persistent and significant challenge at both national and local levels. The need for a successful and large-scale digital transformation is urgent. Furthermore, digitally Transforming the IFRC and its 191 members is a complex process which requires collaborative action and support across the membership. Therefore, IFRC recently developed a Digital Transformation Strategy which was approved by the IFRC Governing Board in May 2021.

The Digital Transformation Department (DTD) has full leadership responsibility for the implementation of the digital transformation strategy and the positive impact it will have on the 191 National Society members of the IFRC. The DTD provides strategic leadership and guides the IFRC Secretariat as well as the members network to adapt and innovate humanitarian services, drawing on digital services, data-enabled decision-making, and other opportunities for digital transformation in support of the IFRC’s Strategy 2030. In addition, the DTD is responsible for the development and implementation of business transformation, information technology and digitalization services throughout the IFRC Secretariat, thereby supporting the same transformation in 191 NSs, setting the vision, and drawing stakeholders together on this digital journey.

The incumbent engineers the organisation’s data and accountable to the organisation’s Data manager that reports to the DT Director. Given the strategic choice by the organisation to deliver more value from the organisation’s data, the Data Engineer position is tactically of high relevance. The other units reporting to the DT Director include the Enterprise Architecture, Strategy & Planning unit, the Digital development and management unit and the Service unit.

Job Purpose

The position holder is responsible for designing, developing, and managing data solutions on the Data Platform. Is responsible for building robust and scalable data pipelines, managing data storage and processing systems, and ensuring data quality and integrity.

Job Duties and Responsibilities

Data Pipeline Development:

•  Design, develop, and maintain data pipelines to efficiently extract, transform, and load (ETL) data from various sources into target data systems.
•  Using technologies such as Azure Data Factory, Azure Databricks, or SQL Server Integration Services (SSIS) to handle data ingestion, transformation, and integration tasks.

Data Storage and Management:

•  Implement and manage data storage solutions using Microsoft technologies like Azure SQL Database, Azure Data Lake Storage, or SQL Server.
•  Ensure data integrity, security, and compliance with data governance policies.

Data Modeling and Architecture

•  Design and implement data models to support efficient data storage and retrieval.
•  Develop database schemas, define relationships, and optimize performance based on the specific requirements of the data solution.

Data Quality and Governance:

•  Implement data quality checks and processes to ensure data accuracy, consistency, and completeness.
•  Collaborate with data stewards and business stakeholders to define and enforce data governance policies.

Big Data and Analytics:

•  Work with big data technologies such as Azure HDInsight, Azure Databricks, or Apache Spark to process and analyze large volumes of data.
•  Develop scalable and performant data solutions for analytics, reporting, and machine learning purposes.

Data Security and Compliance:

•  Implement security measures to protect sensitive data and ensure compliance with relevant regulations and standards.
•  Define and enforce access controls, data encryption, and data retention policies.

Performance Tuning and Optimization:

•  Optimize data solutions for performance and scalability.
•  Identify and resolve performance bottlenecks, optimize SQL queries, and fine-tune data processing workflows.

Collaboration and Documentation:

•  Work collaboratively with cross-functional teams, including data scientists, data analysts, and business stakeholders.
•  Document data engineering processes, system architecture, and data flow diagrams for knowledge sharing and future reference.

Collaboration and Stakeholder Management:

•  Collaborate with business stakeholders, data analysts, data architect, data scientists across the organisation to understand their data needs and align data architecture with organizational goals.

Job Duties and Responsibilities (continued)

Guide Cross-functional Teams on Data Engineering:

•  Facilitate communication between technical and non-technical stakeholders to ensure effective data-driven decision-making.

Contribute to the building of an effective, high-quality, fit-for-purpose Digital Transformation Department.

•  Managing consultants or specific suppliers attracted to deliver on above responsibilities.
•  Collaborate effectively with Secretariat’s Divisions’ and DTD colleagues to ensure the effective delivery of objectives pertaining to the IFRC DT strategy, Agenda for Renewal and Strategy2030.
•  Partner with Enterprise architecture, Service management, IFRC’s Data protection Office and CISO on data foundations (security, technology) to deliver self-service data analysis and culture of data sharing.
•  Consult and advise stakeholders, including regional and divisional leaders; share expertise and knowledge freely as and where required. Provide training, documentation etc.
•  Be a pro-active advisor and dynamic member of the DT department senior team, supporting strategic content areas and/or organizational change.

IFRC (quality) standards and operating procedures:

•  Ensure availability and development of standard operating procedures and/or guidelines and required documentation is delivered and where relevant available into the Service Management Tool.

Education

Required:

•  Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.

Experience

Required

•  A minimum of three years of progressively responsible postgraduate experience in data management with a focus on Microsoft Dynamics / F&O Suite data model.
•  Proven track record as a Data Engineer or similar role.
•  Experience in Data Lake and Data Lakehouse implementation (e.g., Microsoft
•  data lake, MSQL Server, MySQL).
•  Experience in Data Vault implementation.
•  Experience in data governance, architecture and handling large datasets and data pipelines.
•  Familiarity with data security, and data privacy regulations (e.g., GDPR, CCPA).

Preferred

•  Experience within the RC RC Movement and/ or international humanitarian or development organisations.
•  Experience in data products development, business value case development, data product deployment.

Knowledge, Skills and Languages

Required:

•  Excellent problem-solving and analytical skills.
•  Ability to drive results, and create culture that fosters proactive action and accountability, actively prioritize, set high standards.
•  Strong knowledge of data modeling techniques, including conceptual, logical, and physical data modeling.
•  Proficiency in database design, data warehousing, and data integration concepts.
•  Understanding of data analytics and business intelligence concepts and tools.
•  Knowledge in Data Mesh, Microsoft Azure Synapse and Azure Data Factory
•  Effective collaboration and influencing skills
•  Strong presentation, written and oral communication skills.
•  Excellent interpersonal skills.
•  Proven teamwork and trust-building skills, including development of effective and efficient networks and partnerships within and outside of the organisation
•  Proactive approach to finding creative and constructive solutions to difficult issues.
•  Proven training, knowledge transfer and supervisory skills as part of the people’s management.
•  Fosters a climate of trust and confidence, makes decisions transparently and manages in structured and predictable way and follows through on agreed commitments and actions.
•  Fluently spoken and written English.

Preferred:

•  Strong leadership abilities.
•  Ability to develop strategy, and proven skills in translating strategy in roadmaps, workstreams, setting ambitious and meaningful targets.
•  Knowledge on applying artificial intelligence techniques, such as machine learning.
•  Able to network effectively and influence and inspire others within the organisation, and externally peers, membership and other stakeholders.
•  Propensity for embracing change and ambiguity: anticipate emerging conditions and demands, embrace widespread organisational change, navigate complex dynamics, view uncertainty and disruption as an opportunity.
•  Developing others: Push autonomy and empowerment, view people development as imperative, create culture of accountability.
•  Good command of another IFRC official language (French, Spanish or Arabic).

Competencies, Values and Comments

Values: Respect for diversity; Integrity; Professionalism; Accountability Core competencies: Communication; Collaboration and teamwork; Judgement and decision making; National society and customer relations; Creativity and innovation; Building trust Functional competencies: Strategic orientation, Building alliances, Leadership, Empowering others

Comments: This is a national staff position open to Hungarian nationals and others who are legally eligible to work in Hungary. Candidates must be able to provide proof of their eligibility to work in Hungary.