The United Nations Global Service Centre (UNGSC) provides critical Supply Chain, Geospatial, Information and Telecommunications Technologies services and Training to all Secretariat Entities, Peacekeeping and Special Political Missions, Agencies, Funds and Programmes of the UN system worldwide. The Senior Database Architect & Power Apps Developer Consultant will work under the direct supervision of the Team Leader, Supply Network Management Team. The consultant shall be responsible for the following duties:
Responsibilities:
1. Database Architecture & Design:
* Architect scalable and optimized relational and non-relational data models within Microsoft Dataverse or Azure SQL.
* Design normalized and de-normalized database structures, ensuring efficient data storage, retrieval, and performance.
* Implement advanced data governance, security models, and role-based access controls within Dataverse or Azure SQL.
* Develop strategies for data migration, integration, and synchronization across disparate data sources using Azure Data Factory or Power Automate.
1. Power Apps Development:
* Design and develop complex, custom Power Apps solutions leveraging advanced features such as custom connectors, canvas apps, model-driven apps, and AI Builder.
* Integrate Power Apps with external data sources, APIs, and services using Dataverse, REST APIs, or custom connectors.
* Implement advanced business logic, workflows, and automation using Power Automate and Power Apps Component Framework (PCF).
* Ensure the performance, scalability, and reliability of Power Apps solutions through best practices in app design and user interface/experience (UI/UX).
2. Reporting & Visualization:
* Create sophisticated Power BI reports and dashboards, utilizing DAX (Data Analysis Expressions) and M (Power Query Formula Language), Power Query, and custom visualizations to deliver actionable insights.
* Implement data mashups from multiple sources, applying data transformation, cleansing, and modeling techniques within Power BI.
* Embed Power BI reports within Power Apps or other platforms for enhanced reporting and decision-making.
3. Collaboration & Support:
* Collaborate with cross-functional teams including IT, data scientists, and business analysts to align solutions with organizational goals.
* Provide ongoing technical support, troubleshooting, and performance tuning for Dataverse and Power Apps implementations.
* Document technical designs, procedures, and processes to facilitate knowledge transfer and system maintenance.
Vacantes: 1
Salario: N/A
#J-18808-Ljbffr