Result of Service

To design, deploy, and sustain advanced database solutions using Microsoft Dataverse, and to build enterpriselevel Power Apps that address complex business needs.

Work Location

In person

Expected duration

04 Nov 2430 Jun 25

Duties and Responsibilities

The United Nations Global Service Centre (UNGSprovides 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: Database Architecture & Design • Architect scalable and optimized relational and nonrelational data models within Microsoft Dataverse or Azure SQL. • Design normalized and denormalized database structures, ensuring efficient data storage, retrieval, and performance. • Implement advanced data governance, security models, and rolebased 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. Power Apps Development • Design and develop complex, custom Power Apps solutions leveraging advanced features such as custom connectors, canvas apps, modeldriven 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 (PC. • Ensure the performance, scalability, and reliability of Power Apps solutions through best practices in app design and user interface/experience (UI/U. Reporting & Visualization • Create sophisticated Power BI reports and dashboards, utilizing DAX (Data Analysis Expressionand M (Power Query Formula Languag, 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 decisionmaking. Collaboration & Support • Collaborate with crossfunctional 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.

Qualifications/special skills

Advanced university degree (Master’s degree or equivalenin computer science or a related field is required. A firstlevel university degree in combination with two additional years of qualifying experience may be accepted in lieu of the advanced university degree. A minimum of one (01) years of experience in Microsoft Dataverse, including advanced data modeling, schema design, entity relationships, and metadata management is required. Experience in developing complex Power Apps using both canvas and modeldriven approaches, with a focus on reusability and modular design is required. Experience in integrating Power Apps with various data sources, including Azure SQL Database, SharePoint, Dynamics 365, and custom APIs is required. Experience in Power BI, including DAX, Power Query, and visual development for interactive and dynamic reporting is required. Experience with the Power Platform ecosystem, including Power Automate, and Power Virtual Agents is required. Experience with DevOps practices for application lifecycle management (ALwithin Power Apps, including version control, CI/CD pipelines using Azure DevOps or GitHub is desirable. Experience with cloud infrastructure, particularly Azure services (e.g., Azure Functions, Azure Logic Apps, Azure Service Buis desirable. Experience with scripting languages such as JavaScript, TypeScript, or C# for extending Power Apps capabilities using PCF is desirable. Certification in Microsoft Certified: Power Platform Solution Architect is desirable. Certification in Azure Data Engineer Associate is desirable.

Languages

English and French are the working languages of the United Nations Secretariat. For the post advertised, fluency in English is required.

Additional Information

Not available.

No Fee

THE UNITED NATIONS DOES NOT CHARGE A FEE AT ANY STAGE OF THE RECRUITMENT PROCESS (APPLICATION, INTERVIEW MEETING, PROCESSING, OR TRAININ. THE UNITED NATIONS DOES NOT CONCERN ITSELF WITH INFORMATION ON APPLICANTS’ BANK ACCOUNTS.