Overview
Develop and maintain enterprise data analysis, Business Intelligence (BI), and reporting solutions for ICAO's functional departments. Analyze ERP data and develop reports using various BI tools.
Key Responsibilities
- Develop and maintain enterprise data analysis, BI, and reporting for ICAO’s functional departments.
- Analyze legacy Unit4 (Agresso) ERP and new Oracle Fusion (Quantum) ERP data and develop reports using Microsoft Azure Synapse Analytics, Microsoft Power BI, or Oracle reporting tools.
- Gather, analyze, and document client reporting requirements to determine feasibility of BI and reporting solutions.
- Use ICAO’s Azure DevOps for Agile/SCRUM development, documenting and managing client reporting requirements and configuring CI/CD pipelines.
- Develop, test, implement, and optimize SQL and T-SQL queries, Stored Procedures, Indexes, Functions, and data models.
- Develop reports using Microsoft Azure Synapse and Microsoft Power BI.
- Develop reports using Oracle Fusion reporting tools such as OTBI or BIP.
- Assess data quality of Oracle Fusion ERP datasets using dimensions such as Completeness and Accuracy.
- Provide system-level support or administration of ICAO’s data infrastructure or platforms.
- Conduct regular security reviews and adhere to security best practices.
Required Experience
- A minimum of seven (7) years of professional experience analyzing ERP data and using the Software Development Lifecycle (SDLC) or similar Agile/SCRUM development methodologies or frameworks to develop reporting and BI solutions.
- A minimum of five (5) years of professional experience using the Microsoft SQL Server RDBMS, SSMS, developing and optimizing SQL, T-SQL, Indexes, Stored Procedures, Functions etc.
- A minimum of two (2) years of professional experience using Microsoft Azure Synapse Workspace and Pipelines for data integration, Microsoft Power BI (web service, Desktop, Paginated reports etc.), dimensional modelling and Azure DevOps for managing client requirements, work tasks, CI/CD pipelines etc.
- Experience working in an international or multicultural environment, ideally within the UN system or a similar intergovernmental organization (desirable).
- Experience working with the Oracle Fusion ERP and Oracle data analysis and reporting tools such as Business Intelligence Publisher (BIP), Business Intelligence Cloud Connector (BICC), or similar (desirable).
Qualifications
A first-level university degree (undergraduate bachelor’s degree or equivalent) in Computer Science, Information Systems or a related field.
