Oracle Data Warehouse Developer

Quick Facts - Role: Data Warehouse Developer (Oracle) - Focus: Building reusable data warehouse components, integrations, and APIs for enterprise sales, policy, and claims processing Description Build and maintain reusable components supporting a data warehouse team, integrating SAS/SAS Viya with Oracle and BI/data platforms. Design and implement ETL/data modeling, REST/API integrations, and both batch (file) and streaming (e.g., Kafka) data exchanges. Support monitoring, auditing, data-quality controls, and performance optimization, including creation of data marts and BI artifacts. Responsibilities - Build reusable tools/components in SAS, SAS Viya, and Oracle for the Data Warehouse team - Design and develop APIs and integration components connecting SAS, SAS Viya, Oracle, Power BI, Microsoft Fabric, Office 365, and REST API - Implement data exchange between systems (file-based, API-based, and streaming, incl. Kafka) - Conduct POCs for new tools/technologies (e.g., SAS Viya, Oracle Exadata, Microsoft Fabric, Power BI) - Build user activity monitoring tools and support auditing, data quality, and processing optimization - Optimize data warehouse processing using analysis components and automation for maintenance tasks - Build technical data marts, BI reports, and processing/optimization components - Support strategic projects with technical, integration, and architectural input Requirements - Practical experience in building and developing a data warehouse - Very good Oracle knowledge (Oracle Exadata experience is a plus) - Experience with SAS and SAS Viya environments/tools (DI Studio, Enterprise Guide, SAS Studio, Visual Analytics) - Knowledge of CI/CD topics and tools (Git, Bitbucket, Bamboo, JIRA) and experience automating the development process - Experience designing and implementing ETL processes, data modeling, and data flow design - PL/SQL knowledge and experience optimizing data processing - Availability for coordination meetings at the client office approximately 1 day per week; remote for the rest Benefits - Project-based collaboration with milestone-based billing and acceptance protocols for deliverables - Flexible B2B model for projects for a recognized insurance-industry partner - Administrative and settlement support via Connectis - Participation in industry events and technology meetups - Referral bonus for recommending a friend (5,000 PLN) - Fast and remote application process formatted_html_description:

Quick Facts

• Role: Data Warehouse Developer (Oracle)

• Focus: Building reusable data warehouse components, integrations, and APIs for enterprise sales, policy, and claims processing

Description

Build and maintain reusable components supporting a data warehouse team, integrating SAS/SAS Viya with Oracle and BI/data platforms. Design and implement ETL/data modeling, REST/API integrations, and both batch (file) and streaming (e.g., Kafka) data exchanges. Support monitoring, auditing, data-quality controls, and performance optimization, including creation of data marts and BI artifacts.

Responsibilities

• Build reusable tools/components in SAS, SAS Viya, and Oracle for the Data Warehouse team

• Design and develop APIs and integration components connecting SAS, SAS Viya, Oracle, Power BI, Microsoft Fabric, Office 365, and REST API

• Implement data exchange between systems (file-based, API-based, and streaming, incl. Kafka)

• Conduct POCs for new tools/technologies (e.g., SAS Viya, Oracle Exadata, Microsoft Fabric, Power BI)

• Build user activity monitoring tools and support auditing, data quality, and processing optimization

• Optimize data warehouse processing using analysis components and automation for maintenance tasks

• Build technical data marts, BI reports, and processing/optimization components

• Support strategic projects with technical, integration, and architectural input

Requirements

• Practical experience in building and developing a data warehouse

• Very good Oracle knowledge (Oracle Exadata experience is a plus)

• Experience with SAS and SAS Viya environments/tools (DI Studio, Enterprise Guide, SAS Studio, Visual Analytics)

• Knowledge of CI/CD topics and tools (Git, Bitbucket, Bamboo, JIRA) and experience automating the development process

• Experience designing and implementing ETL processes, data modeling, and data flow design

• PL/SQL knowledge and experience optimizing data processing

• Availability for coordination meetings at the client office approximately 1 day per week; remote for the rest

Benefits

• Project-based collaboration with milestone-based billing and acceptance protocols for deliverables

• Flexible B2B model for projects for a recognized insurance-industry partner

• Administrative and settlement support via Connectis

• Participation in industry events and technology meetups

• Referral bonus for recommending a friend (5,000 PLN)

• Fast and remote application process