Position Function:

This position is responsible for the development and support of ETL’s used for loading Oracle Business Intelligence Data Warehouses. The candidate will be required to implement ETL’s between Oracle EBS, cloud bases data sources, third party environments and the Oracle BI Data Warehouses.

Primary responsibilities: Include designing, implementing, and supporting all areas of data loading process as well as troubleshooting, monitoring, and coordinating the release of ETL processes.

Essential Duties and Responsibilities:

• Overall technical owner for OBIEE and any supplemental BI Solutions.
• Development of new data models.
• Create Datawarehouse data marts and subject areas in OBIEE for Business Intelligence, Reporting and Analytics.
• Gain an understanding from business users of requirements for reporting Metrics, KPIs and standard analytics.
• Transform these requirements into Business Intelligence solutions available to end users.
• This position is responsible for maintaining a very high level of technical expertise on industry standards concerning business intelligence applications and processes.
• Document and deliver technical specifications

Skills/Experience Requirements:

• 3+ years’ years of experience designing, developing, and supporting complex data warehousing, data marts and ETL environments in a senior position.
• Proven experience in performing conceptual, logical, and physical data modelling in a highly complex environment.
• 3+ years using: Oracle E-Business Suite (12.x or higher)
• Oracle BI Applications (OBIA) exposure to versions 11.1.1.10 +
• Exposure to Microsoft SSIS 2022
• Strong proven expertise in PL/SQL and Data Modelling
• Exposure to Oracle Analytics Server is beneficial
• Experience developing, designing and maintaining Cloud data extracts
• Excellent communication and documentation skills.

Must have expertise in the following:

• Oracle OBIEE
• OAS
• OAC
• Oracle EBS environment (also known as EBIZ or E-Business)
• Advanced Analytics or Visualization
• SQL Development
• ODI Basic experience