OAS/OBIEE Data Engineer

2 weeks ago

Mississauga, Ontario, Canada The Cigna Group Full time

This is a permanent Data Engineer 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 June 11, 2024.

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 PharmacyTM 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.

  • OAS/OBIEE Data Engineer

    2 weeks ago

    Mississauga, Ontario, Canada Cigna Health and Life Insurance Company Full time

    OAS/OBIEE Data Engineer - Express Scripts Canada page is loaded OAS/OBIEE Data Engineer - Express Scripts Canada Apply remote type Hybrid locations Mississauga, ON time type Full time posted on Posted 6 Days Ago job requisition id This is a permanent Data Engineer position, integral part of the IT team and plays a critical role in the DBA team. The BI &...

  • OAS/OBIEE Data Engineer

    4 weeks ago

    Mississauga, Ontario, Canada The Cigna Group Full time

    The job profile for this position is Software Engineering Advisor, which is a Band 4 Senior Contributor Career Track Role.Excited to grow your career?We value our talented employees, and whenever possible strive to help one of our associates grow professionally before recruiting new talent to our open positions. If you think the open position you see is...

  • Data Engineer

    2 weeks ago

    Mississauga, Ontario, Canada CB Canada Full time

    Data Engineer On behalf of our client in the Retail Sector, PROCOM is looking for a Data Engineer. Data Engineer – Mandatory Skills Proficient in building data pipelines in Hadoop/GCP Expert in data analysis using SQL Ability to build scalable resilient systems with minimum guidance 5+ years' experience in data engineering Team player, mindset to work...

  • Data Engineer

    4 weeks ago

    Mississauga, Ontario, Canada Compass Canada Full time

    You might not know our name, but you know where we are. That's because Compass Group Canada is part of a global foodservice and support services company that's the 6th largest employer in the world, with 625,000 employees. You'll find us in schools, colleges, hospitals, office buildings, senior living communities, tourist attractions, sports venues, remote...

  • Data Engineer

    1 month ago

    Mississauga, Ontario, Canada Compass Canada Full time

    You might not know our name, but you know where we are. That's because Compass Group Canada is part of a global foodservice and support services company that's the 6th largest employer in the world, with 625,000 employees. You'll find us in schools, colleges, hospitals, office buildings, senior living communities, tourist attractions, sports venues, remote...

  • Data Engineer

    2 weeks ago

    Mississauga, Ontario, Canada Synechron Full time

    Role: Data Engineer(Databricks, Python/Pyspark, SQL, Azure)Mississauga, ON (hybrid/3 days in a week) Overview: Looking for an Integration engineer responsible for daily support and project based development of credit risk management systems. ETL developers are responsible for designing and creat

  • Data Engineer

    2 weeks ago

    Mississauga, Ontario, Canada Jace Holdings Ltd. Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Job Category: EDO-Mktg. Loyalty and Digital DataTravel Requirements: 0 - 10%Job Type: Full-TimeCity: Mississauga / Calgary / StellartonLocation: Tahoe OfficePostal Code: L4W 0C7Our family of 131,000 employees and franchise affiliates share a collective passion for...

  • Data Engineer

    2 weeks ago

    Mississauga, Ontario, Canada KUBRA Full time

    OverviewKUBRA is in growth mode and currently seeking a Data Engineer to join our Data Analytics TeamAs a Data Engineer, you will be working on designing and maintaining our data Infrastructure and ETL processes under the direction of the Team Lead, or Senior Data Engineer. The best part? You will also get the opportunity to collaborate with an amazing Data...

  • Data Analytics Engineer

    2 weeks ago

    Mississauga, Ontario, Canada Aviyatech Full time

    Aviya Aerospace Systems is a leader in engineering services and solutions for mission critical Aerospace and Defense applications. Aviya provides expertise in program management, systems, software, mechanical, and hardware engineering to many of the top-tier Aerospace and Defense Contractors. We have an opening for aData Analytics Engineer to join our...

  • Data Engineer

    2 weeks ago

    Mississauga, Ontario, Canada Synechron Full time

    Role: Python Data EngineerLocation: Mississauga, ON (hybrid/3 days in a week) - In Person InterviewOverview:Searching for a Python Data Engineer responsible for supporting credit risk management systems on a daily basis. The role involves designing data warehouse and handling data extraction, transformation, and loading functions.This is a valuable...

  • Data Engineer

    2 weeks ago

    Mississauga, Ontario, Canada Synechron Full time

    Role: Data Engineer(Databricks, Python/Pyspark, SQL, Azure)Mississauga, ON (hybrid/3 days in a week)Overview:Looking for an Integration engineer responsible for daily support and project based development of credit risk management systems. ETL developers are responsible for designing and creating the data warehouse and all related extraction, transformation...

  • Data Engineering Manager

    2 weeks ago

    Mississauga, Ontario, Canada Cooper Equipment Rentals Full time

    Build your Career at Cooper Equipment Rentals We are looking for a talented problem-solver with an "automate everything" attitude to lead our professional Data Engineering and Integration Team as Data Engineering Manager. Please note to be considered for this position applicants should currently be residing in Canada and legally entitled to work. ...

  • Sr. Data Engineer

    2 weeks ago

    Mississauga, Ontario, Canada F. Hoffmann-La Roche Gruppe Full time

    Roche fosters diversity, equity and inclusion, representing the communities we serve. When dealing with healthcare on a global scale, diversity is an essential ingredient to success. We believe that inclusion is key to understanding people's varied healthcare needs. Together, we embrace individuality and share a passion for exceptional care. Join Roche,...

  • Senior Data Engineer

    2 weeks ago

    Mississauga, Ontario, Canada Jace Holdings Ltd. Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: City: Mississauga / Calgary / StellartonLocation: Tahoe OfficePostal Code: L4W 0C7Our family of 131,000 employees and franchise affiliates share a collective passion for delivering exceptional shopping experiences and amazing food to all our customers. Our mission is...

  • Sr Developer, Data Engineering

    2 weeks ago

    Mississauga, Ontario, Canada Bell Canada Full time

    Press Tab to Move to Skip to Content Link Select how often to receive alerts (in days): Create alert At Bell, we do more than build world-class networks, develop innovative services and create original multiplatform media content – we advance how Canadians connect with each other and the world. If you're ready to bring game-changing ideas to life and...

  • Data Engineer

    4 weeks ago

    Mississauga, Ontario, Canada RBC - Royal Bank Full time

    Job SummaryJob DescriptionWhat is the opportunity?Supports the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. Applies complete knowledge, skills, and practices to perform assignments. Data Engineer on the Insurance data Lake Team in Technology & Operations at the Royal Bank of Canada?RBC`s...

  • Data Engineer

    2 months ago

    Mississauga, Ontario, Canada RBC - Royal Bank Full time

    Job SummaryJob DescriptionWhat is the opportunity?Supports the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. Applies complete knowledge, skills, and practices to perform assignments. Data Engineer on the Insurance data Lake Team in Technology & Operations at the Royal Bank of Canada?RBC`s...

  • Lead Data Engineer

    2 weeks ago

    Mississauga, Ontario, Canada Royal Bank of Canada> Full time

    Summary of the JobJob DescriptionExciting OpportunityThis position offers you the chance to join the RBC Insurance Active Data Platform team, working alongside a group of tech experts focused on providing solutions to the insurance industry. Our approach is centered on Agile development, DevOps, Open Source, Software as a Service (SaaS), and modern tools and...

  • Engineer - Data Engineering

    2 weeks ago

    Mississauga, Ontario, Canada Synopsys, Inc. Full time

    Seeking a motivated and innovative mixed signal AMS co-simulation verification engineer with strong theoretical and practical background in high-speed data recovery circuits. The position offers an excellent opportunity to work with an expert team of digital, analog and mixed signal engineers responsible for delivering high-end mixed-signal designs.Setup UVM...

  • Lead Data Engineer

    4 weeks ago

    Mississauga, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryJob DescriptionWhat is the opportunity? This is an opportunity to work at RBC Insurance Active Data Platform team with a group of technology specialists dedicated to deliver solution to Insurance business and clients. We are all in with Agile development, DevOps, Open Source, Software as a Service (SaaS) and modern tools and processes. You will...