Business Intelligence (BI) Developer (2 posts)

Support the ADB/IMS/ICT/DM/BI Team, achieving results such as:

• Develop and maintain enterprise data analysis, Business Intelligence (BI) and reporting for ICAO’s functional departments such as Finance, Human Resources, Procurement, Capacity Development, Regional Offices, etc.
• Analyze ICAO’s legacy Unit4 (Agresso) ERP and new Oracle Fusion (Quantum) ERP data based on institutional knowledge, and develop reports using Microsoft Azure Synapse Analytics, Microsoft Power BI and, or Oracle reporting tools such as Oracle Business Intelligence Publisher (BIP), Oracle Transactional Business Intelligence (OTBI) or others.

Conduct systems/business analysis, achieving results such as:

• Gather, analyze and document client reporting requirements or specifications to determine the feasibility of developing, deploying and maintaining Business Intelligence (BI) and reporting solutions.
• Use ICAO’s Azure DevOps for Agile/SCRUM development, documenting and managing client reporting requirements (Epics, Features, Product Backlog Items (PBI) or User Stories, Tasks, Bugs, Wiki etc.), configuring and managing Continuous Integration and Continuous Deployment (CI/CD) pipelines for the automated publishing of Power BI artefacts.
   

Use the Software Development Lifecycle (SDLC – Planning, Requirements Analysis, Design, Development/Implementation/Coding, Testing, Deployment and Maintenance) or similar Agile/SCRUM development methodologies/frameworks, achieving results such as: 

• Develop, test, implement and optimize SQL and T-SQL queries, Stored Procedures, Indexes, Functions, data models, Facts and Dimensions tables etc. that downstream Microsoft Power BI reports and Business Intelligence (BI) solutions will use as per the requirements and specifications provided by the various business areas of ICAO.
• Develop reports using Microsoft Azure Synapse (Data Warehouse or Dedicated SQL Pool, Azure Data Lake Storage (ADLS2), Serverless SQL Pools and, or ETL Pipelines) and Microsoft Power BI (Service, Desktop, Workspaces, Paginated reports, Dashboards, Apps etc.) per the requirements and specifications provided by the various business areas of ICAO.
• Develop reports using Oracle Fusion reporting tools such as Oracle Transactional Business Intelligence (OTBI), Oracle Analytics Publisher or Business Intelligence Publisher (BIP) per the requirements and specifications provided by the various business areas of ICAO.
• Ensure high overall quality by developing to the requirements and specifications provided by the various business areas of ICAO.
   

Conduct data quality activities, achieving results such as: 

• Assess the high-level data quality of Oracle Fusion (Quantum) ERP datasets provided to ICAO’s data warehouse using data quality dimensions such as Completeness (e.g. Number of rows for specific table(s); non-null rows or columns) and Uniqueness (non-duplicate rows as required).
• Examine and compare data in the Oracle Fusion (Quantum) ERP UI, OTBI or BIP reporting tools with the Oracle Fusion (Quantum) ERP data provided to ICAO’s data warehouse for the Accuracy dimension of data quality.
• Share the beta versions of developed reports with the various ICAO business or Subject Matter Experts (SME) to confirm the Accuracy dimension of data quality from the business or specific domain perspective.
• Explore and monitor the ETL schedules and run status in UNDP’s Incorta cloud environments.

System administration, and security, achieving results such as: 

• Provide as necessary system-level support or administration of ICAO’s data infrastructure or platforms (Azure Synapse Workspace and Pipelines, Microsoft Power BI Service and Workspaces).
• Conduct regular security reviews and adhere to security best practices or measures in supporting platforms (Azure Synapse, Microsoft Power BI Service) and reporting artefacts (T-SQL queries, Stored Procedures, Functions, Microsoft Power BI reports etc.).