The OAS and OBIEE Developer is responsible for designing, developing, and maintaining business intelligence solutions using Oracle Analytics Server (OAS) and Oracle Business Intelligence Enterprise Edition (OBIEE). This role involves working closely with business stakeholders to translate requirements into interactive dashboards, reports, data visualizations, creating and adjusting ETL jobs in ODI, optimizing processes, OLAP data structures expansion and changes.

REQUIRED SKILLS & EXPERIENCE:

• 7+ years of experience in Oracle Analytics Server (OAS) and OBIEE.
• Strong proficiency in Oracle SQL and PL/SQL.
• Expertise in RPD development and metadata modeling.
• Experience with BI Publisher and other Oracle reporting tools.
• Familiarity with integrating data from multiple sources including APIs.
• Knowledge of performance tuning and database optimization.
• Experience in health care services is a plus.

PREFERRED QUALIFICATIONS:

• Experience with Power BI, Tableau, or other BI tools.
• Understanding of ETL processes and tools like Talend or SSIS.
• Excellent communication and stakeholder management skills.

• Develop and maintain dashboards, reports, and visualizations using OBIEE and OAS.
• Design and build RPD layers (Physical, Business Model, and Presentation).
• Perform data modeling, performance tuning, and metadata management.
• ODI: Perform detailed data analysis for online analytical processing (OLAP) and associated ETL jobsDesign, implement, troubleshoot, and optimize ETL jobs and related mappings.
• Integrate OAS/OAC with various data sources including Oracle databases and APIs.
• Ensure continuous support and maintenance for OBIEE, ODI, and Oracle DBs through fixes, patches, and upgrades, according to business schedules and requirements
• Implement security features such as Row-Level and Object-Level Security.
• Develop pixel-perfect reports using BI Publisher.
• Collaborate with business users to gather requirements and deliver analytics solutions.
• Optimize SQL and PL/SQL queries for performance.
• Support data blending and preparation activities.