OBIEE Developer - Express Scripts Canada

Express Scripts Pharmacy Benefit Services; Mississauga; On-site; CAD 90,000 - 120,000; Full time

Job summary

A prominent healthcare services provider in Mississauga is seeking an OBIEE Developer. This full-time role involves designing analytics solutions, maintaining reports, and optimizing data processes. Candidates should have extensive experience with OBIEE, Oracle databases, and ETL development. A Bachelor's in Computer Science is required, alongside strong analytical skills and problem-solving abilities.

Benefits

Competitive salary

Comprehensive benefits package

Positive work environment

Qualifications

• 5+ years of experience with enterprise level BI applications.
• 3+ years designing ETL jobs using ODI.
• 3+ years experience supporting Oracle databases with PL/SQL.

Responsibilities

• Design analytics solutions for enterprise-level clients.
• Develop and maintain OBIEE reports and dashboards.
• Optimize ETL processes and database performance.

Skills

OBIEE

ETL processes

Oracle PL/SQL

SQL

Data analysis

Troubleshooting

Linux basics

Education

Bachelor's degree in Computer Science or related field

Tools

OBIEE

ODI

Oracle DB

Job description

OBIEE Developer - Express Scripts Canada

Join to apply for the OBIEE Developer - Express Scripts Canada role at Express Scripts Pharmacy Benefit Services

OBIEE Developer - Express Scripts Canada

2 days ago Be among the first 25 applicants

Join to apply for the OBIEE Developer - Express Scripts Canada role at Express Scripts Pharmacy Benefit Services

BI & ETL Engineer

BI & ETL Engineer

Summary : This is a permanent position, integral part of the IT team and plays a critical role in the DBA team. The BI & ETL Engineer is responsible for designing and creating BI interfaces and ETL processes to OLAP data warehouse, provide level-2 technical support for database programming, perform data analysis, develop forecasting models and developing reports using OBIEE ODI and Oracle DB. This position will also be responsible for patching, upgrading OBIEE, ODI, Oracle DB, creating and adjusting custom reports in OBIEE, creating and adjusting ETL jobs in ODI, optimizing processes, OLAP data structures expansion and changes.

Responsibilities

• OBIEE : Participate in the design of analytics solutions supporting at an Enterprise level;
• planning reporting projects to include but not limited to requirements analysis, project scoping, data analysis, and business logic transformation;
• changing and optimizing repository layers, models, and subject areas
• Collaborate with BI System Analyst to create required reports using reporting tools like OBIEE, BI Publisher; profile data necessary to meet reporting requirements
• Design, develop, and support visualization tools including but not limited to dashboards, scorecards, operational and scheduled reports, ad-hoc queries, and decision support
• Analyze and optimize queries, review OLAP data structures for tuning overall design
• Implement, document, and perform OBIEE administration processes and policies
• ODI : Perform detailed data analysis for online analytical processing (OLAP) and associated ETL jobs
• Design, implement, troubleshoot, and optimize ETL jobs and related mappings
• Provide data cleansing input to application developers, and coach DBAs for ETL job troubleshooting
• Document and publish with the team all existing ETL jobs and processes
• Oracle DBA : Oracle database development using SQL, and Oracle PL / SQL
• Core skills to administer, monitor, and troubleshoot Oracle DBs
• Basic knowledge on patching and maintenance tasks on Oracle DBs
• Work closely with Data Architect for database schema changes.
• Ensure high availability for OBIEE, ODI, DB, through systems administration / support and change management.
• Ensure continuous support and maintenance for OBIEE, ODI, and Oracle DBs through fixes, patches, and upgrades, according to business schedules and requirements
• Communicate task status, roadblocks, and critical matters to management promptly
• Assist level 1 technical support as needed, provide level 2 technical support or open level 3 service requests with support entity or application vendor

Key Qualifications

BS in Computer Science, Software Engineering or related degree or equivalent combination of education and related experience

Strong analytical and problem-solving skills

Ability to work independently and in a team environment

Ability to define problems, analyze data, establish facts, and quickly draw valid conclusions

5+ years of experience designing, developing, supporting and maintaining enterprise level business intelligence application(s); performing OBIEE maintenance, catalog migration, role based security, repository development and administration

3+ years of experience in designing ETL jobs, preferably with ODI, and associated tasks : troubleshooting, tuning, documentation, migration between environments

3+ years of experience performing Oracle database support, maintenance, and development using PL / SQL and SQL

Desired Qualifications

Experience in working all or most tasks in RHEL systems, understanding WebLogic and Fusion Middleware, Identity Management concepts, basic Linux tasks and operations

Basic knowledge of Linux operating system, storage systems, networking concepts

Familiarity with agile concepts and methodology

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 : [e-mail] Do not email [e-mail] for an update on your application or to provide your resume as you will not receive a response.

Seniority level

Seniority level

Mid-Senior level

Employment type

Employment type

Full-time

Job function

Job function

Information Technology

Industries

Hospitals and Health Care

Referrals increase your chances of interviewing at Express Scripts Pharmacy Benefit Services by 2x

Get notified about new Business Intelligence Developer jobs in Mississauga, Ontario, Canada .

business intelligence analyst - Information technology (IT)

Business Analyst-Azure data / datawarehouse

Senior Business Intelligence Analyst, Business Innovation and Operations Management (Hybrid, Toronto)

Analyst, Data Science and Analytics Solutions

Sr. Analyst (Capital Markets, Cloud Data Platform, Databricks, and GenAI)

Senior Business Intelligence Analyst - Marketing Delivery (Salesforce)

Business Systems Analyst (Data Analyst) (contract)

Business Data Analyst (Credit Card Portfolio)

Scarborough, Ontario, Canada 15 hours ago

Senior Business Analyst, Investment Data Operations (12 month contract)

Business Analyst, Investment Data Operations

Sr. Analyst, Data Acquisition (16-Month Maternity Leave Contract)

Data Governance Technology Senior Analyst

Richmond Hill, Ontario, Canada 1 week ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

J-18808-Ljbffr