We are looking for a Middle/Senior Full-Stack Engineer with strong Python/Django and SQL expertise to help develop and maintain a web application for migrating reporting functionality from Oracle APEX. The role combines backend and frontend development with database analysis, reporting, dashboard development, and performance optimization. Our client is a leading Ukrainian bank undergoing significant digital transformation. The team is working on modernizing reporting solutions and migrating existing reporting functionality from Oracle APEX to a Python/Django-based web application.

The team is developing the bank’s analytical system. The main focus is migrating reports and dashboards from the legacy Oracle APEX platform to a new Django-based project, building new visualization logic, and integrating with data from the bank’s systems. Responsibilities: Analyze existing Oracle APEX reports, dashboards, SQL queries, and business logic. Develop and maintain backend functionality using Python and Django. Develop web interfaces using Django Templates, HTML, CSS, and JavaScript. Build interactive dashboards, tables, charts, and calculated metrics.

Implement data filtering, search, sorting, grouping, and pagination. Develop report generation and export functionality in XLSX, CSV, and PDF formats. Migrate and implement user roles, authentication, authorization, and access control for reports and data. Analyze and optimize SQL queries and overall application performance. Connect Django applications to Oracle Database and work with Oracle SQL and PL/SQL. Validate migrated functionality and ensure data consistency between Oracle APEX and the Django application. Develop and integrate REST APIs, preferably using Django REST Framework.

Document implemented functionality and support further development of the solution. Migrate reports and dashboards from the legacy Oracle APEX system to a Django-based application. Design and implement new data visualization logic. Integrate the analytical system with data from banking systems. Build and maintain ETL/ELT pipelines. Work with large data volumes and optimize performance (indexes, partitioning, query execution plans). Work with file storage (S3) and analytical file formats (Parquet, CSV, PDF). Support and extend analytical interfaces.

Requirements: Strong Python skills and hands-on experience developing web applications with Django. Commercial experience with Django backend and frontend development. Strong knowledge of Django ORM, including query optimization and resolving N+1 issues. Solid SQL skills and practical experience with Oracle Database, including indexes, JOINs, partitioning, EXPLAIN/query plan analysis, and optimization of heavy queries. Good understanding of PL/SQL. Experience analyzing Oracle APEX applications, reports, dashboards, SQL queries, and business logic.

Experience integrating Django with Oracle Database, preferably using python-oracledb. Experience developing interactive dashboards, tables, charts, filters, and calculated metrics. Strong HTML5, CSS3, and JavaScript skills. Experience implementing search, sorting, filtering, grouping, and pagination. Experience with data visualization libraries such as Chart.js, Apache ECharts, or similar. Experience generating and exporting reports in XLSX, CSV, and PDF formats. Understanding of authentication, authorization, role-based access control, and data access restrictions.

Experience developing and integrating REST APIs. Experience optimizing web application performance and SQL queries for large datasets. Experience with Git. Experience working with large data volumes and reporting. Experience building analytical systems or dashboards. Experience migrating legacy solutions to a modern stack. Experience with ETL/ELT pipelines. Nice to Have: Experience with Django REST Framework. Experience with PostgreSQL. Experience with Oracle APEX migration or modernization projects. Experience working with enterprise reporting or business intelligence applications. Experience with Kafka.

Experience with S3 and file storage for analytics, preferably Parquet. Experience with banking or fintech data. React for building tables and dashboards.

We offer*: Flexible working format - remote, office-based or flexible A competitive salary and good compensation package Personalized career growth Professional development tools (mentorship program, tech talks and trainings, centers of excellence, and more) Active tech communities with regular knowledge sharing Education reimbursement Memorable anniversary presents Corporate events and team buildings Other location-specific benefits *not applicable for freelancers