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.
Location: Mississauga, ON
Working Environment: Hybrid, 2 days/week on-site
Key Responsibilities:
- 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 jobs
Design, 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.
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.
Express Scripts Canada is a Cigna company
Express Scripts Canada is a subsidiary of Express Scripts, a Cigna company. Cigna Corporation (NYSE: CI) is a global health service company dedicated to improving the health, wellbeing and peace of mind of those we serve. Cigna offers an integrated suite of health services through Cigna, Express Scripts, and our affiliates including medical, dental, behavioural health, pharmacy, vision, supplemental benefits, and other related products.
About Express Scripts Canada
Express Scripts Canada is a leading health benefits manager and has been recognized as one of the most innovative. Our clients include Canada's leading insurers, third party administrators and governments. We work with these clients to develop industry-leading solutions to deliver superior healthcare in a cost-controlled environment. We provide Active Pharmacy™ services to more than 7 million Canadian patients and adjudicate more than 100 million pharmacy, dental, and extended health claims annually. Through our proprietary consumer intelligence, clinical expertise, and patients-first approach, we promote better health decisions for plan members, while managing and reducing drug benefit costs for plan sponsors.
It will be a condition of employment that the successful candidate obtains an Enhanced Reliability Clearance from the Federal Government. The candidate will be required to provide supporting documentation to receive clearance if required.
We offer a competitive salary and benefits package, along with a positive work environment built on solid corporate values, integrity, mutual respect, collaboration, passion, service and alignment.
We are an equal opportunity employer that promotes a diverse, inclusive and accessible workplace. By embracing diversity, we build a more effective organization that empowers our employees to be the best that they can be.
We are committed to creating a working environment that is barrier-free and we are prepared to provide accommodation for people with disabilities.
If you require accommodation in completing the online application process, please email: [email protected] Do not email [email protected] for an update on your application or to provide your resume as you will not receive a response.
