**Main Responsibilities** * **Develop a Data Warehouse** using Oracle Database 19c Enterprise Edition. * **Code in PL/SQL** for data movement, transformation, and reporting. * **Create complex reports** for areas such as Risk, Finance, and Regulatory. * **Collaborate with business users** to understand requirements and data flows. * **Modernize legacy systems** (refactoring for better performance and scalability). * **Follow company development best practices** (clean, maintainable code). * **Optimize SQL and PL/SQL**, using advanced features such as: + Parallelism + Partitioning + Compression + Analytic functions * **Analyze and improve performance** using tools like ASH (Active Session History) and Real\-Time SQL Monitoring. * **Participate in data modeling**, using Kimball, Data Vault, or 3NF. * **Work in an agile environment**, participate in design reviews, and mentor other developers. **✅ Required Qualifications** * **Solid experience (5\+ years)** with Oracle SQL and PL/SQL. * **Knowledge of data modeling**, both dimensional (Kimball) and normalized (3NF). * **Strong command of advanced SQL**: analytic functions, hierarchical queries, complex joins, etc. * **Experience with tuning and troubleshooting** using Oracle tools (e.g., AWR, ASH). * **Proactive and detail-oriented profile**, with strong English communication skills. **➕ Nice-to-have (not required, but valued)** * Experience in the **financial or insurance sector**. * Knowledge of **Git** (version control). * Programming skills in **Python**. * Experience with **Oracle APEX** (Oracle Application Express) for web applications. * Interest in **complex financial products** (such as derivatives). **What they look for in terms of profile** * Someone **technical and experienced**, yet able to interact with business teams. * **Collaborative mindset**, who enjoys working in an agile team. * Ability to **analyze complex problems** and design scalable solutions. * Interest (or background) in the **financial sector**, especially regulatory topics. **Conclusion** This position is ideal for someone with: * Solid experience with **Oracle (SQL and PL/SQL)**; * Experience in **Data Warehousing and data modeling**; * Skills to **optimize performance** and handle large data volumes; * Interest or experience in the **financial/regulatory sector**.