OAS and OBIEE Developer

Job Description

<p><b>OAS and OBIEE Developer</b></p><p><br></p><p><b>FTE- Full-Time/ Permanent </b></p><p><b>Hybrid: 2 days a week on site a week</b></p><p><b>Mississauga</b></p><p><br></p><p> On behalf of our Healthcare client, Procom is searching for an OAS and OBIEE Developer for a permanent role. This position is a hybrid position with 2 days onsite at our client's Mississauga office. </p><p> </p><p> <b>OAS and OBIEE Developer - Job Description:</b></p><p> The OAS and OBIEE Developer will be 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 create interactive dashboards, reports, and data visualizations, while optimizing processes and expanding OLAP data structures.</p><p> </p><p> <b>OAS and OBIEE Developer - Responsibilities:</b></p><p> • Develop and maintain dashboards, reports, and visualizations using OBIEE and OAS.</p><p> • Design and build RPD layers (Physical, Business Model, and Presentation).</p><p> • Perform data modeling, performance tuning, and metadata management.</p><p> • Design, implement, troubleshoot, and optimize ETL jobs and related mappings.</p><p> • Integrate OAS/OAC with various data sources including Oracle databases and APIs.</p><p> • Ensure continuous support and maintenance for OBIEE, ODI, and Oracle DBs through fixes, patches, and upgrades.</p><p> • Implement security features such as Row-Level and Object-Level Security.</p><p> • Develop pixel-perfect reports using BI Publisher.</p><p> • Collaborate with business users to gather requirements and deliver analytics solutions.</p><p> </p><p> <b>OAS and OBIEE Developer - Mandatory Skills:</b></p><p> • 7+ years of experience in Oracle Analytics Server (OAS) and OBIEE.</p><p> • Strong proficiency in Oracle SQL and PL/SQL.</p><p> • Expertise in RPD development and metadata modeling.</p><p> • Experience with BI Publisher and other Oracle reporting tools.</p><p> • Familiarity with integrating data from multiple sources including APIs.</p><p> • Knowledge of performance tuning and database optimization.</p><p> • Excellent communication and stakeholder management skills.</p><p> </p><p> <b>OAS and OBIEE Developer - Nice-to-Have Skills:</b></p><p> • Experience with Power BI, Tableau, or other BI tools.</p><p> • Understanding of ETL processes and tools like Talend or SSIS.</p><p> • Experience in health care services.</p><p> </p><p> <b>OAS and OBIEE Developer - Assignment Length:</b></p><p> This is a permanent position.</p><p> </p><p> <b>OAS and OBIEE Developer - Assignment Location:</b></p><p> Mississauga, Ontario, Canada. Hybrid role with a minimum of 2 days in the office per week.</p>