Job Description

Oracle BI Apps Developer / Architect EBS Service Modules

Location: Remote

Employment Type: Contract

Job Summary:

We are looking for an experienced Oracle BI Applications Developer / Architect with deep expertise in building native logical models for Oracle E-Business Suite Service Modules. The ideal candidate will be responsible for designing logical data models using Navicat Modeler, and transforming them into scalable semantic models for reporting and analytics purposes.

Key Responsibilities:

• Design and develop native logical data models for Oracle EBS Service Modules (e.g., Field Service, Depot Repair, Service Contracts, etc.).

• Use Navicat Data Modeler to build and manage logical models, ensuring they align with business and data requirements.

• Convert logical models into semantic models that support advanced reporting and analytics.

• Collaborate with business analysts, data engineers, and functional teams to capture data requirements and translate them into high-performance BI solutions.

• Integrate semantic models into BI tools such as OBIEE, Power BI, or Microsoft Fabric, as needed.

• Ensure model consistency, reusability, and adherence to enterprise data standards.

• Perform data profiling and source system analysis to identify key business metrics and KPIs.

• Optimize data models for performance and scalability.

Required Skills and Experience:

• 10+ years of experience in Oracle BI Applications (OBIA) development and architecture.

• Deep understanding of Oracle E-Business Suite, especially Service Modules (Field Service, Service Contracts, etc.).

• Strong experience in logical data modeling, dimensional modeling, and relational modeling.

• Hands-on experience with Navicat Modeler (or similar data modeling tools like ER/Studio or ERwin).

• Proven ability to transform logical models into semantic layer models used in BI platforms.

• Strong SQL skills and familiarity with PL/SQL for data extraction and manipulation.

• Knowledge of ETL concepts and ability to work with data integration teams.

• Good understanding of metadata management and data governance practices.

• Strong communication and documentation skills.

Preferred Qualifications:

• Experience with BI tools such as OBIEE, Power BI, or Oracle Analytics Cloud (OAC).

• Familiarity with Microsoft Fabric or modern data lake architectures.

• Exposure to Agile methodologies and DevOps for BI environments.

• Oracle or BI-related certifications are a plus.

Job Tags

Similar Jobs