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

NOTE: Internal candidates should apply before March 12, 2025.

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: eschr2@express-scripts.com Do not email eschr2@express-scripts.com for an update on your application or to provide your resume as you will not receive a response.