Oracle BI Developer

Oracle BI Developer

Remote

06+ months contract

• 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.
• 15+ 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.
• 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.