Business Intelligence (BI) Developer (2 posts)

ICAO•Montreal, QC

16h•CA$7,562 - CA$10,910

About The Position

The International Civil Aviation Organization (ICAO) is seeking two Business Intelligence (BI) Developers to join the Information and Communication Technology (ICT) Section. This role supports the ongoing development, maintenance, and enhancement of analytical and reporting data artifacts, working closely with business and technical resources, stakeholders, and third-party vendors. The position is within the Data Warehousing and Business Intelligence knowledge area, which is part of ICAO’s Enterprise Data Management framework. The incumbent will support enterprise data analysis, BI, and reporting for various ICAO departments, leveraging expertise in database management systems, data warehouses, data lakes, data engineering, data integration, data analysis, Microsoft Power BI, and Oracle report development.

Requirements

A first-level university degree (undergraduate bachelor’s degree or equivalent) in Computer Science, Information Systems or a related field.
A minimum of seven (7) years of professional experience analyzing ERP data and using the Software Development Lifecycle (SDLC – Planning, Requirements Analysis, Design, Development/Implementation/Coding, Testing, Deployment and Maintenance) 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.
Fluent reading, writing and speaking abilities in English.

Nice To Haves

Experience working in an international or multicultural environment, ideally within the UN system or a similar intergovernmental organization.
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.
A working knowledge of any other language of the Organization (Arabic, Chinese, French, Russian, Spanish).

Responsibilities

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.
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.
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.
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.
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.