Data Warehouse Developer / Analyst

Position Purpose
ODIN is a Data Warehouse application and it is changing its overall architecture and migrating to new efficient data model, Also few of the technical upgrade are due in this year. We are looking for the mid experience team member in the team, who can learn the BAU quickly and come up with fresh ideas in the team and contribute in designing and development of the statistical models.The team is in charge of the maintenance and the development of new features on 3 reporting applications as well as a Data Warehouse. These applications are designed to provide KPI and reports for back-office and valuation and risk control teams. Direct Responsibilitieso Understand the need of Business/Operations teams and propose indicators to meet the expectations.o o Work on DWH environmento o Propose, when relevant, the architecture & flow of new applications that would help them integrate with existing ones and with the whole data architecture being developedo o Develop, when relevant, different components of this architecture/flow of the applications.o o Automation of recurring actions and implementation of tools to facilitate the support and evolution of applicationso o Contribution to the evolution of the application architecture to improve the quality of service provided to users (Operations, Business)Contributing Responsibilitieso Support and maintenance in operational condition of various applications focused on the collection and analysis of technical and functional dataThe technical environment consists of OS such as Windows, Linux Red Hat / Ubuntu, various technologies (Kafka, MQ, API, ELK) and a DevOps part using Ansible, Kubernetes, Git, Jenkins and all of the Atlassian tools.Creation of processes to onboard new projects (Infrastructure and Business)Study and advice on the technological choice for evolutions and new projectsImplementation and monitoring of action plans to avoid the recurrence of problemsTechnical and functional data analysis (Data Intelligence, Machine Learning, )

Technical & Behavioral Competencies
Mandatory Technical expertise required:- Oracle Database SQL Development (+++)- Advanced PL/SQL which includes Partitions, performance tuning, local & global indexing, Dynamic SQL, Exception Handling and Bulk data handling, etc.- ETL concepts- Shell scriptingNice to have Technical skills:- Data Warehousing- Oracle APEX- Python- Statistical/Machine Learning Modelling.Behavioral Skills- Curiosity and analysis skills and willingness to learn.- Good Communication skills.- Quality-focused with a good eye for detail.- Capacity to work in a high-pressure environment.- Must be able to work closely with distributed team, users and business analysts.- Willing to share knowledge and skills with other developers within the team.- Whilst able to work independently, should be a true team player.- Creativity and Problem solving attitude.