Oracle Data Specialist

eir business talent; Dublin; Remote; EUR 80,000 - 120,000; Full time

Job summary

eir business talent is seeking an Oracle Data Specialist in Dublin with remote options. The role focuses on documenting and supporting ODI processes for the Oracle Data Warehouse, with emphasis on OBIEE, data flows, scheduling and knowledge transfer.

The candidate should have 4+ years in OBIEE and 6–7 years in BI/Data Analysis, plus Python and PL/SQL. Strong presentation and documentation skills are essential, as is eligibility to work in Ireland long-term.

Qualifications

• 4+ years of OBIEE experience and 6–7 years in BI/Data Analysis
• Strong presentation and documentation skills for knowledge transfer
• Proven ability to document data flows, processes and run books

Responsibilities

• Maintain documentation of ODI processes supporting the Oracle Data Warehouse
• Document source-to-target data flows and processing logic for ODI/OBIEE and other ingestions
• Capture scheduling, frequency, dependencies and upstream/downstream processes
• Gain knowledge from SMEs and contractors to implement critical processes
• Create run books and operational procedures for ODI processes and BAU support
• Lead knowledge-transfer activities and walkthroughs for IT Data Office team
• Create training videos to transfer complex technical knowledge

Skills

BI/Data Analysis

Python

PL/SQL

Azure SQL

Azure Fabric

Tools

OBIEE

Job description

eir business talentis currently seeking applicants for Oracle Data Specialist for our client based in Dublin

Oracle Data Specialist

Location – Dublin – Remote

Type – 12+ months Contract—highly extendable

Your responsibilities:

• Establishing and maintaining comprehensive documentation of Oracle Data Integrator (ODI) processes supporting the Oracle Data Warehouse
• Document key source-to-target data flows, including source systems, target tables, transformations, dependencies and processing logic for OBIEE platform but also extending to other platform ingestions.
• Capture scheduling and orchestration information, including frequency, sequencing, dependencies, triggers and upstream/downstream processes
• Garnering technical knowledge from subject matter experts, experienced staff and contractors and establishing how critical processes are implemented
• Establish and maintain run books and operational procedures for business-critical ODI processes to support BAU operational and incident
• Leading structured technical knowledge-transfer activities and walkthroughs facilitating knowledge transfer into the IT Data Office team by allowing shadowing and/or holding walkthrough sessions as part of quarterly team
• Producing videos where these provide an effective means of transferring complex technical knowledge

Mandatory:

• Oracle OBIEE (should have more than 4 years of experience in OBIEE – and probably at least 6-7 years minimum experience in BI/Data Analysis as a whole, ideally also with some exposure to Azure SQL/Fabric)
• Python
• PL/SQL
• This candidate will need very strong presentation and documentation skills (knowledge transfer is a huge part of this role)

Candidates should hold appropriate RTWs for Ireland i.e. Stamp1G Dependant, Stamp 4, Irish/British/EU passport.

Candidates must be eligible to work full time and long term in the location specified or currently hold a valid appropriate long term work Visa to apply.

eirbusinesstalent, eir business and our clients are equal opportunity employers who seeks to recruit and appoint the best available person for a job regardless of marital / civil partnership status, sex (including pregnancy), age, religion, belief, race, nationality and ethnic or national origin, colour, sexual orientation or disability.

eirbusiness talent, eirbusiness and our clients apply all relevant Data Protection laws when processing your Personal Data.

If you choose to apply to this opportunity and share your CV or other personal information with eirbusiness talent, eirbusiness and our clients, these details will be held by us in accordance with our privacy policy used by our recruitment team to contact you regarding this or other relevant opportunities at eirbusiness talent and eirbusiness.

Ref: EET8345