Data Warehouse Consultant

Job Posting Organization:
The International Atomic Energy Agency (IAEA) is an international organization that seeks to promote the peaceful use of nuclear energy and to inhibit its use for any military purpose, including nuclear weapons. Established in 1957, the IAEA has a mission to accelerate and enlarge the contribution of atomic energy to peace, health, and prosperity throughout the world. The organization operates in over 170 countries and has a workforce of approximately 2,500 employees. The IAEA's Department of Management (MT) plays a crucial role in supporting the agency's scientific and technical programs by providing essential services and ensuring efficient operations.

Job Overview:
The Data Warehouse Consultant position is integral to the IAEA's Division of Information Technology, specifically within the AIPS Management Section. The consultant will be responsible for the comprehensive delivery of the Finance and Budget Data Warehouse, which is integrated with the Oracle E-Business Suite (EBS). This role involves leading the design, development, testing, and deployment of the data warehouse solution to ensure that reliable and actionable financial data is available for both internal and external reporting. The consultant will collaborate closely with IT and Finance teams to streamline business processes and propose data-driven solutions that align with organizational standards and reporting requirements. Additionally, the role includes training and documentation responsibilities, as well as coordination with business owners to ensure that technical solutions meet strategic financial goals.

Duties and Responsibilities:
The Data Warehouse Consultant will conduct impact analyses for Finance and Budget data requirements, design and document conceptual, logical, and physical data models for the Data Warehouse, and develop ETL processes to extract, transform, and load data from Oracle EBS and other sources. The consultant will also remediate and optimize existing reports to align with updated data structures, perform system, integration, and user acceptance testing (UAT), and create Business Intelligence (BI) dashboards. Furthermore, the consultant will create metadata subject areas to support ad-hoc reporting and BI artifacts, deliver training sessions, and prepare technical documentation for end users and support teams. Collaboration with Finance stakeholders is essential to ensure data accuracy and usability for reporting, and the consultant will support process improvement initiatives by proposing automated and scalable data solutions.

Required Qualifications:
Candidates must possess a Bachelor's Degree in information technology, management, computer sciences, or related fields. A minimum of 5 years of experience in Data Warehousing, Business Intelligence, or related fields is required. Proven experience with Oracle E-Business Suite (EBS) R12.2, particularly in Finance and Budget modules such as Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), Purchase Orders (PO), Projects, and Budgeting is essential. A strong understanding of Oracle EBS 12.2 data structures and integration points is necessary, along with hands-on experience with ETL tools such as Oracle Data Integrator or Informatica. Proficiency in SQL, PL/SQL, and performance tuning is required, as well as experience designing and developing dashboards and reports using Power BI and/or Oracle Analytics Cloud (OAC). Familiarity with data governance, metadata management, and data quality practices is also important, along with excellent analytical, problem-solving, and communication skills. The ability to work collaboratively with cross-functional teams and business stakeholders is crucial.

Educational Background:
The educational background required for this position includes a Bachelor's Degree in information technology, management, computer sciences, or related fields. This foundational education is critical for understanding the technical aspects of data warehousing and business intelligence, as well as the specific requirements of the IAEA's financial and budgetary processes.

Experience:
The position requires a minimum of 5 years of relevant experience in Data Warehousing, Business Intelligence, or related fields. This experience should include proven work with Oracle E-Business Suite (EBS) R12.2, particularly in the Finance and Budget modules. Candidates should have a strong background in data modeling, ETL processes, and business intelligence reporting, demonstrating their ability to manage complex data environments and deliver actionable insights.

Languages:
While the job description does not specify mandatory languages, proficiency in English is likely essential given the international nature of the IAEA and its operations. Additional languages may be beneficial but are not explicitly required.

Additional Notes:
The consultancy offers a daily fee of up to a maximum of € 380, which is determined based on the candidate's qualifications and experience. If duty travel is required as part of the assignment, a daily subsistence allowance (DSA) and travel costs will be provided. It is important to note that health coverage and pension fund responsibilities fall on the incumbent, indicating that this position may not include traditional employee benefits.