Full Stack Developer

Organizational Context

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.

Given the strategic choice by the organisation to deliver more value from the organization’s data, the incumbent is the organisation’s lead in data platform architecture and accountable to the organisation’s Data manager that reports to the DT Director.

The other units reporting to the DT Director include the Enterprise Architecture, Strategy & Planning unit, the Digital development and management unit and the Service Delivery & Support unit.

Job Purpose

The Full Stack Developer will be primarily responsible for the end-to-end development of data projects, from clarifying requirements with business requestors, to schema preparation, data modelling, data engineering, report development in PowerBI and facilitation of User Testing pipelines, to support IFRC’s operations in multiple sectors (e.g. Finance, Logistics, Human Resources mobilization, Project management and others).

The position holder will operate on IFRC’s Data Platform, based on Microsoft Fabric and Synapse using Data Vault and Dimensional modeling techniques for consumption in Power BI.

The role will collaborate with multiple cross-functional teams at a global level, on a variety of projects that support the internal and external-facing activities of the Red Cross and Red Crescent movement.

Job Duties and Responsibilities

Data analytics and reporting:

• Analyze and understand business process and data models, business logics, modelling logics, and ways to identify missing data.
• Liaise with business contact or business analysts to understand the specifications of requirements.
• Identify data requirements and data elements and ingest them in the data platform if missing.
• Design and implement dashboards and reports in Power BI that provide actionable information.
• Follow through on UAT identified issues and their resolution.
• Publish data and reports to production.

Microsoft Fabric/Azure Synapse:

• Develop database schemas, define relationships, and optimize performance based on the specific requirements of the data solution
• Develop data products using SQL and PySpark.
• Implement data quality checks and processes to ensure data accuracy, consistency, and completeness.
• Implement security measures to protect sensitive data and ensure compliance with relevant regulations and standards.
• Optimize solutions for performance and scalability.
• Identify and resolve performance bottlenecks, optimize SQL queries, and fine-tune data processing workflows.
• Document data engineering processes, system architecture, and data flow diagrams for knowledge sharing and future reference.

Job Duties and Responsibilities (continued)

General:

• Work collaboratively with cross-functional teams, including architects, data scientists, data analysts, and business stakeholders.
• Act as a mentor and guidance for colleagues to encourage the adoption of self-service analytics.
• Provide technical guidance and training to team members on data management best practices and Microsoft data technologies
• Support the unit manager with regular progress reports on results against objectives and responsibilities.
• Work in close consultation and develop partnerships with colleagues with data roles across the secretariat in Geneva and in the regions.

Education

Requied bachelor's or Master's degree in Computer Science, Information Systems, or a related field

Experience

Required:

- 5+ years of progressively responsible experience in data engineering with a focus on data modelling and 3+ years in data engineering (Microsoft Fabric or Azure Synapse) and report development (Power BI). Proven track record as a Data Engineer or similar role, and in Power BI development, including Paginated or SSRS reports

- Core Expertise in the Microsoft Data Stack, in particular proficiency with Fabric, Azure Data Factory, Azure Synapse Analytics

- Experience in Data Lake and Data Lakehouse implementation (e.g., Microsoft Fabric, Azure Synapse, Databricks, Snowflake, Microsoft SQL Server, Apache Spark/Hadoop, or other similar big data or SQL databases)

- Experience in Data Vault and dimensional data modeling techniques

- Knowledge of Finance/Accounting logic in ERP, ideally with D365 F&O. Understanding humanitarian accounting logic is a benefit (appeals, pledges, projects, etc...)

- Strong knowledge of Azure Cloud architecture and networking principles

- Familiarity with CI/CD pipelines for data workflows (e.g., using Azure DevOps).

Preferred:

- Proficiency in programming languages such as Python, SQL, or Java

- Proficiency in the Apache Spark framework

- Experience in data governance, architecture, and handling large datasets and data pipelines

- Proficiency in cloud platforms and technologies, such as AWS, Azure, or Google Cloud

- Experience with big data technologies, such as Hadoop, Spark, and distributed storage systems

- Familiarity with data governance, data security, and data privacy regulations (e.g., GDPR, CCPA)

- Experience within the RC/RC Movement and/ or international humanitarian or development organisations

Knowledge, Skills and Languages

Required:

- Strong strategic and conceptual thinking; setting meaningful, long-term vision and strategy, consider long-term potential, propose challenging strategic goals

- 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

- Ability to drive results, and create culture that fosters proactive action, actively prioritize, set high standards

- Developing others: Push autonomy and empowerment, view people development as imperative, create culture of accountability

- Data modelling, statistics

- Focused on quality and standards, results, and accountability

- Proven teamwork and trust-building skills, including development of effective and efficient networks and partnerships within and outside of the organisationills

- Proactive approach to finding creative and constructive solutions to difficult issues

Preferred:

- Knowledge on applying artificial intelligence techniques, such as NLP and machine learning

- Strong presentation, written and oral communication skills

- Able to network effectively and influence and inspire others including peers, the membership and other stakeholders

Competencies, Values and Comments

- Fluent spoken and written English required

- Good command of another IFRC official language (French, Spanish or Arabic)