Data Engineer (Oracle)

Scalo provides software projects and supports partners in business development, focusing on software, embedded systems, cloud solutions, data management, and dedicated project teams.

• Minimum 5 years of experience in a similar role
• Practical experience in building and developing data warehouses
• Very good knowledge of Oracle, preferably Oracle Exadata
• Ability to design and implement ETL processes, data modeling, and data flows
• Practical knowledge of Databricks and experience with data in cloud data platform environments and integration of Databricks with external systems
• Experience in hybrid cloud and on-premise environments, and Data & Analytics projects
• Knowledge of Azure Data Factory and data integration between cloud and on-premise systems, and Azure data platforms
• Knowledge of SAS 9.4, SAS Viya, and processes in the SAS environment
• Knowledge of Git, GitHub, Bitbucket, Bamboo for automation of the development process
• Ability to use AI tools such as GitHub Copilot in development and analytical tasks
• Ability to design analytical solutions, define technical standards, and design data architecture
• Knowledge of modern data architectures and design of data exchange interfaces between systems

Nice to have:

• Experience with Microsoft Fabric
• Programming experience in Python
• Automation of processes and creation of integration scripts
• Experience with data processing, Parquet format, working with Data Lake layers
• Experience with Kafka-based integration and data streaming

• Support project in the insurance industry involving integration of cloud system with Databricks and Oracle and SAS data warehouses
• Design and implement ETL processes and data flows between cloud and on-premise layers
• Integrate Databricks, Azure Data Factory, and Oracle preparing data for further processing in the Data Warehouse
• Participate in designing data solution architecture, defining technical standards, and designing data exchange interfaces between systems
• Automate development and maintenance processes using CI/CD, GitHub Copilot, and Visual Studio Code
• Perform ongoing development and maintenance of Data Warehouse/BI solutions using SAS, Oracle, Microsoft Fabric, Python, Kafka, and Sanmargar Metastudio
• Build technical data marts, BI reports, and components supporting data processing and optimization
• Support strategic projects in technological, integration, and architectural aspects
• Work in a hybrid mode with presence in the Warsaw office once a week