OAS and OBIEE Developer Express Scripts Canada
OAS and OBIEE Developer Express Scripts Canada
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
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 Canadas 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: Do not email for an update on your application or to provide your resume as you will not receive a response.
Employment Type
Full-Time
