OBIEE Developer - Express Scripts Canada

The Cigna Group; Mississauga; On-site; CAD 85,000 - 110,000; Full time

Job summary

A leading health services company is seeking an OBIEE Developer to join their IT team in Mississauga. This permanent role involves designing BI interfaces, developing ETL processes, and supporting Oracle databases to enhance analytics capabilities. Candidates should have extensive experience with OBIEE and ETL technologies.

Benefits

Competitive salary and benefits

Positive work environment

Opportunity for career development

Qualifications

• 5+ years of experience in OBIEE applications.
• 3+ years with Oracle database support.
• Experience in ETL job design and implementation using ODI.

Responsibilities

• Design and implement BI solutions using OBIEE.
• Develop ETL jobs and perform data analysis.
• Administer Oracle databases and ensure high availability.

Skills

Analytical skills

Problem-solving skills

Team collaboration

Education

BS in Computer Science or Software Engineering

Job description

OBIEE Developer - Express Scripts Canada

Join to apply for the OBIEE Developer - Express Scripts Canada role at The Cigna Group

OBIEE Developer - Express Scripts Canada

1 day ago Be among the first 25 applicants

Join to apply for the OBIEE Developer - Express Scripts Canada role at The Cigna Group

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

  Not Applicable

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Hospitals and Health Care

Referrals increase your chances of interviewing at The Cigna Group by 2x

Sign in to set job alerts for “Business Intelligence Developer” roles.

Business Consultant, Data Warehouse & BI Reporting

Senior Business Intelligence Analyst (Power Automate / Apps)

Business Analyst-Azure data/ datawarehouse

Business Analyst (Power BI & Tableau), Technology Services Group

Senior Analyst, Investment Data Solutions

Senior Analyst, Data and Application Support

Senior Data Analyst, KYC Onboarding & Refresh Reporting

Data Analytics & Reporting Analyst - Fall 2025 (Co-op/Internship) - 8 Months

Business Analyst with SQL & Regulatory Data Analysis

Business Data Analyst (Credit Card Portfolio)

Applications Development Senior Programmer Analyst - FI Data

Meter Data Management Analyst (1-Year Contract)

Senior Business Analyst, Data Integration & Performance Platform (12 month contract)

IT Business Analyst Specialist, Data & Analytics team

Power BI and Change Management Consultant - (Hybrid - Toronto)

VP, EDO Business Execution Analyst - Data Transformation Program Staffing & Financial Commitments-Mississauga

Capital Markets, Client Data Analyst Fall 2025 Co-Op (8 Months)

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