Analista Programador Oracle BI

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

Joana Figueira

Tecnologia

1

Lisboa

1200-629

Genesis Digital Solutions is a consulting and technology company that helps organizations turn ideas into measurable business impact through digital expertise and AI innovation. Founded in 2018, we operate across Portugal and the United Arab Emirates, supporting clients in multiple industries with intelligent, scalable, and secure solutions. We combine strategy, engineering, and emerging technologies such as AI, Data, Web3, and Digital Product Development to drive transformation end to end. Our focus is on building practical, human-centered solutions and long-term partnerships that enable sustainable growth, innovation, and real-world results.

We are looking for an Oracle BI Analyst Developer to design, develop, and maintain data solutions that support business intelligence and reporting needs. You will work with Oracle databases, SQL/PL/SQL, ETL processes, and OBIEE dashboards, contributing to reliable data integration, multidimensional modelling, and the development of data marts.

What You’ll Work On

• 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 Oracle Business Intelligence Enterprise Edition (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 Test-Driven Development (TDD) and Behaviour-Driven Development (BDD).
• Contribute to Continuous Delivery practices and the continuous improvement of development processes.
• Ensure data quality, consistency, and reliability across BI solutions.

What We’re Looking For

• Strong experience with SQL and PL/SQL — mandatory.
• Experience working 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 — mandatory.
• Knowledge of TDD and BDD practices.
• Knowledge of Continuous Delivery principles.
• Strong analytical and problem-solving skills.
• Ability to work collaboratively and translate business reporting needs into effective technical solutions.

Bonus Points

• Advanced knowledge of Oracle database technologies.
• Experience optimizing SQL queries and database performance.
• Experience with automated testing and deployment in BI environments.
• Experience working on complex data warehousing and business intelligence projects.

Why You’ll Stay

• A workplace that values innovation and personal growth.
• Opportunities to work on high-impact projects for leading clients.
• Flexible hours and hybrid work options.
• Support for professional development, including training and certifications.