Data Warehouse Consultant

Response Informatics; Andover; On-site; GBP 40,000 - 70,000; Full time

Job summary

A tech company in the UK is seeking a professional to design and implement analytics solutions using Oracle technologies. Key responsibilities include developing Oracle Analytics Server security, maintaining ETL processes, and providing production support for existing data warehouse solutions. Strong experience in RPD design and performance tuning is essential. This role contributes to enhancing data-driven decision-making across the organization.

Qualifications

• Experience with Oracle Analytics and RPD design.
• Proficient in Oracle Data Integrator for ETL processes.
• Strong knowledge of data warehouse solutions.

Responsibilities

• Design and implement security in Oracle Analytics.
• Develop and maintain ETL mappings.
• Provide production support for OAS and ODI objects.

Skills

Oracle Analytics

Oracle Data Integrator

Data Warehouse

ETL processes

Performance tuning

Dashboard development

Job description

• Designed subject areas using RPD (Repository) design in Oracle Analytics.
• Designed, developed, and implemented Oracle Analytics Server (OAS) security including users, roles, and data-level security.
• Designed, developed, and implemented ODI (Oracle Data Integrator) mappings for ETL processes.
• Designed, developed, and implemented Data Warehouse solutions including data modelling and integration.
• Developed and implemented OAS reports and dashboards to support business analytics and reporting needs.
• Provided production support for existing live OAS, ODI, data warehouse objects.
• Analysed and resolved data, ETL, and reporting issues to ensure system stability.
• Performed performance tuning of RPD objects, ODI mappings, queries, and reports.
• Maintained and documented standard processes, procedures, and technical documentation.