Overview
The Full Stack Developer will be responsible for the end-to-end development of data projects, supporting IFRC's operations across multiple sectors. The role involves collaborating with cross-functional teams globally on projects that support internal and external-facing activities.
Tasks Summary
- 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.
- 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.
- 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.
Experience Requirements
- 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.).
- Familiarity with CI/CD pipelines for data workflows (e.g., using Azure DevOps).
- Strong knowledge of Azure Cloud architecture and networking principles.
Qualification Requirements
