Oracle BI Analyst Developer — Dashboards & ETL (Hybrid)

Genesis Digital Solutions; Lisboa; Hybrid; EUR 55,000 - 80,000; Full time

Job summary

Genesis Digital Solutions is seeking an Oracle BI Analyst Developer to design, develop, and maintain data solutions that support business intelligence and reporting. You will work with Oracle databases, SQL/PL/SQL, ETL processes, and OBIEE dashboards to enable reliable data integration and multidimensional modelling.

The role involves building data marts, ensuring data quality, and applying TDD/BDD practices.

Qualifications

• Strong experience with SQL and PL/SQL.
• Experience with Oracle databases, preferably Oracle 12c.
• Experience developing and maintaining ETL processes.
• Experience developing dashboards and reports using OBIEE.
• Strong understanding of multidimensional data modelling.
• Experience developing and maintaining data marts.
• Experience with data integration tools.
• Knowledge of Test-Driven Development (TDD) and Behaviour-Driven Development (BDD).
• Knowledge of Continuous Delivery principles.
• Strong analytical and problem-solving skills.
• Ability to work collaboratively and translate business reporting needs into effective technical solutions.

Responsibilities

• Develop and maintain SQL and PL/SQL queries, procedures, and database solutions.
• Work with Oracle databases, preferably Oracle 12c.
• Design, develop, and maintain ETL processes for data extraction, transformation, and loading.
• Develop interactive and static dashboards and reports using OBIEE.
• Apply multidimensional data modelling concepts to support business intelligence solutions.
• Design, develop, and maintain data marts to support analytical and reporting requirements.
• Work with data integration tools to connect and consolidate data from different sources.
• Apply testing practices, including TDD and BDD.
• Contribute to Continuous Delivery practices and the continuous improvement of development processes.
• Ensure data quality, consistency, and reliability across BI solutions.

Skills

SQL

PL/SQL

Data Modelling

Data Integration

Analytical Thinking

Collaboration

Problem Solving

Tools

OBIEE

Oracle 12c

ETL Tools

Job description

Genesis Digital Solutions is seeking an Oracle BI Analyst Developer to design, develop, and maintain data solutions that support business intelligence and reporting. You will work with Oracle databases, SQL/PL/SQL, ETL processes, and OBIEE dashboards to enable reliable data integration and multidimensional modelling.

The role involves building data marts, ensuring data quality, and applying TDD/BDD practices.