Consultancy – Data Warehouse Consultant (Oracle EBS Finance & Budget)

Consultancy – Data Warehouse Consultant (Oracle EBS Finance & Budget) – (TAL-MTIT20250918-001)

Organization

: MTIT-AIPS Management Section

Primary Location

: Austria-Vienna-Vienna-IAEA Headquarters

Job Posting

: 2025-09-22, 1:33:36 PM

Closing Date

: 2025-10-06, 9:59:00 PM

Duration in Months: 12

Contract Type: Special Service Agreement – SSA

Full Competitive Recruitment: No

Organizational Setting

The Department of Management (MT) provides a ‘platform of services’ that serves as a foundation for the successful delivery of the IAEA’s scientific and technical programmes. Its mission statement is as follows: “MT is a partner and a business enabler that champions change and efficiency, leveraging a common purpose”. Thus, among other support activities, it assists a scientific manager in recruiting the right expert, helps a technical officer coordinate the purchase of radiation equipment, and ensures that all Board documents are translated and distributed on a timely basis to Member States.

The Division of Information Technology provides support to the IAEA in the field of information and communication technology (ICT), including information systems for technical programmes and management. It is responsible for planning, developing and implementing an ICT strategy, for setting and enforcing common ICT standards throughout the Secretariat and for managing central ICT services. The IAEA’s ICT infrastructure comprises state of the art hardware and software platforms in a partially decentralized environment. The Division has implemented an IT service management model based on ITIL (IT Infrastructure Library) and Prince2 (Projects in a Controlled Environment) best practices.

The IAEA’s Enterprise Resource Planning (ERP) system, known as the Agency-wide Information System for Programme Support (AIPS), was implemented in a multi-phased phased approach beginning in 2011 and completing in 2017. AIPS provides a single, fully-integrated solution that standardizes and improves efficiency of business processes by leveraging the Oracle ERP suite of products. AIPS encompasses 8 business domains: finance, procurement, programme and project management, planning and budgeting, human resources and payroll, contacts, travel and events management. The AIPS Management Section (AMS) within the Division of Information Technology manages the operations, maintenance, improvements, and sup

port for the AIPS system in collaboration with business process owners. The AMS Section consists of approximately 20 staff members and is led by a Section Head, who reports to the Director of Information Technology/CIO.

Main Purpose

Under the supervision of the AMS Technical Lead and the guidance of the Project Executive, the Data Warehouse Consultant will be responsible for the end-to-end delivery of the Finance and Budget Data Warehouse integrated with Oracle E-Business Suite (EBS). This includes leading the design, development, testing, and deployment of the data warehouse solution to ensure reliable, actionable financial data is available for internal and external reporting.

The Data Warehouse Consultant will work closely with IT and Finance teams to streamline business processes, propose data-driven solutions, and ensure compliance with organizational standards and reporting requirements. The role also includes training, documentation, and coordination with business owners (MTBF) to align technical solutions with strategic financial goals.

Functions / Key Results Expected

• Conduct impact analysis for Finance and Budget data requirements
• Design and document conceptual, logical, and physical data models for the Data Warehouse.
• Develop ETL processes to extract, transform, and load data from Oracle EBS and other sources.
• Remediate and optimize existing reports to align with updated data structures.
• Perform system, integration, and user acceptance testing (UAT).
• Create Business Intelligence (BI) dashboards.
• 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.
• Collaborate with Finance stakeholders to ensure data accuracy and usability for internal and external reporting.
• Support process improvement initiatives by proposing automated and scalable data solutions.

Qualifications and Experience

• Bachelor’s Degree – University degree in information technology, management, computer sciences or related fields
• Minimum 5 years of experience in Data Warehousing, Business Intelligence, or related fields.
• Proven experience with Oracle E-Business Suite (EBS) R12.2, particularly in Finance and Budget modules (e.g., AP, AR, GL, PO, Projects, Budgeting).
• Strong understanding of Oracle EBS 12.2 data structures and integration points.
• Hands-on experience with ETL tools (e.g., Oracle Data Integrator, Informatica, or equivalent).
• Proficiency in SQL, PL/SQL, and performance tuning.
• 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.
• Excellent analytical, problem-solving, and communication skills.
• Ability to work collaboratively with cross-functional teams and business stakeholders.

Remuneration

The remuneration for this consultancy is a daily fee of up to a maximum of € 380, based on qualifications and experience. In case duty travel is required within the assignment, a daily subsistence allowance (DSA) and travel costs are provided. Health coverage and pension fund are the responsibility of the incumbent.

Read Full Description