Overview
Responsible for the end-to-end development of data projects, including schema preparation, data modelling, data engineering, report development, and user testing facilitation to support IFRC operations.
Key Responsibilities
- 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.
Required Experience
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.
Qualifications
Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
