OAS/OBIEE Data Engineer

4 weeks ago

Mississauga, 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 right for you, we encourage you to apply

Our people make all the difference in our success.

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.

Please note that you must meet our posting guidelines to be eligible for consideration.  Policy can be reviewed at this link.

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

  • OAS/OBIEE Data Engineer

    3 weeks ago

    Mississauga, 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 24006303 This is a permanent Data Engineer position, integral part of the IT team and...

  • OAS/OBIEE Data Engineer

    3 weeks ago

    Mississauga, 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 24006303 This is a permanent Data Engineer position, integral part of the IT team and...

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

  • OAS/OBIEE Data Engineer

    4 weeks ago

    Mississauga, 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...

  • Data Engineer

    1 week ago

    Mississauga, Canada KUBRA Data Transfer Ltd Full time

    KUBRA is in growth mode and currently seeking a Data Engineer to join our Data Analytics Team!As 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 Engineer

    5 days ago

    Mississauga, Canada KUBRA Data Transfer Ltd Full time

    KUBRA is in growth mode and currently seeking a Data Engineer to join our Data Analytics Team!As 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 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, 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

    13 hours ago

    Mississauga, Canada Epsilon Solutions Ltd. Full time

    (SNOWFLAKE ) AND (SQL ) AND (PYTHON ) AND (POWERBI ) AND (AWS ) AND (ANALYTICS ) , IN (QC-CA, ON-CA) AND IN {CA} , TITLES= ("DATA ENGINEER" )Role: Data EngineerLocation: Mississauga, ON / Montreal, QC (Hybrid)Term: ContractExperience: 06+ years They will be designing, developing, and deploying a portfolio of Data & Analytics technology assets and...

  • Engineer, Data

    1 week ago

    Mississauga, Canada EllisDon Full time

    You as a Data Engineer will:  Be a technical lead in the development of high-volume platforms and data pipelines Work with relevant stakeholders to identify sources of data and map out processes/data flow while researching opportunities for data acquisition and innovative new uses for existing data Design, construct, install, test, and maintain...

  • 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

    4 weeks ago

    Mississauga, Canada COMPASS GROUP 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,...

  • Data Engineer

    4 weeks ago

    Mississauga, Canada COMPASS GROUP 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,...

  • Data Engineer

    6 days ago

    Mississauga, Canada Axelon Canada Full time

    Global Financial Firm located in Mississauga, ON has an immediate contract opportunity for an experienced Data Engineer"This role is currently on a Hybrid Schedule.You will need to have reliable internet, computer and android or iphone for remote access into the client systems during remote work.We will be expected in the office weekly 2-3 days depending on...

  • Data Engineer

    4 weeks ago

    Mississauga, Canada Synechron Full time

    Role: Python Data Engineer Mississauga, ON (hybrid/3 days in a week) - In Person Interview 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 th

  • Data Engineer

    4 weeks ago

    Mississauga, 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 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...