Data Warehouse Developer (Oracle) k/m

Lumicode is part of the Pentacomp Group, a Polish IT group with over 30 years of experience. They execute projects for large organizations and the public sector. Currently, they are looking for a Data Warehouse Developer with expertise in Oracle and SAS for a long-term IT project in the insurance industry.

• Practical experience in building and developing Data Warehouses.
• Very good knowledge of Oracle, preferably including Oracle Exadata.
• Experience in designing and implementing ETL processes.
• Knowledge of data modeling and designing data flows.
• Practical experience with SAS and SAS Viya, including SAS DI Studio, SAS Enterprise Guide, SAS Studio, and SAS Visual Analytics.
• Familiarity with PL/SQL and data processing optimization in Oracle.
• Knowledge of CI/CD processes and tools like Git, Bitbucket, Bamboo, and JIRA.
• Experience in automation of the production process.
• Ability to design and build analytical solutions, technical data marts, BI reports, and components supporting data processing.

• Build and develop tools supporting Data Warehouse developers, including reusable components in SAS, SAS Viya, Oracle, and other technologies.
• Design and build API and integration components connecting technologies used in the Data Warehouse.
• Develop solutions supporting data exchange between systems, including file integrations, Kafka, and streaming solutions.
• Create POCs for new tools and technologies like SAS Viya, Oracle Exadata, Microsoft Fabric, Power BI, and automation tools.
• Build tools monitoring Data Warehouse user activity and supporting quality control, audit, maintenance, and optimization of data processing.
• Develop the dictionary system Sanmargar Metastudio 4.
• Optimize data processing through analysis, component development, and automation of maintenance tasks.
• Build technical data marts, BI reports, and components supporting data processing and optimization.
• Support strategic projects in technology, integration, and data architecture areas.

Applicants must consent to personal data processing according to GDPR for recruitment purposes by Lumicode sp. z o.o., part of the Pentacomp group, with data processed in Poland and not transferred outside the EU. Data will be stored until recruitment claims expire or consent is withdrawn; applicants have rights to access, correct, delete, limit, and transfer their data, and can withdraw consent at any time without affecting prior processing.