The Business Intelligence (BI) Developer will support the development, maintenance and enhancement of analytical and reporting data artefacts, working closely with business and technical resources, stakeholders, and third-party vendors. The incumbent will analyze ICAO's legacy Unit4 (Agresso) ERP and new Oracle Fusion (Quantum) ERP data, develop reports using Microsoft Azure Synapse Analytics, Microsoft Power BI and Oracle reporting tools, and ensure high overall quality by developing to the requirements and specifications provided by the various business areas of ICAO.
Requirements
- 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.
- 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.
- Ensure high overall quality by developing to the requirements and specifications provided by the various business areas of ICAO.
- 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.
- 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.).
- Performs other related duties, as assigned.
