PL / SQL Engineer

About the position

You’ll be working on the foundational system in a complex, large-scale transformation chain of actuarial data. This platform serves the Global Office of a leading insurance group, providing the first touchpoint for data coming from over 40 countries. These countries are required to deliver and upload their actuarial extracts into the system within tight timeframes, forming the data bedrock for financial reserves calculations across all regions.

Your Role

As a PL/SQL Engineer, you’ll be responsible for uploading and validating large volumes of actuarial datasets, ensuring their technical accuracy, including formatting, structure, and compliance. You will be at the critical entry point of a global data flow, where quality, speed, and attention to detail are essential.

This is not just about uploading files. It’s about handling 200+ datasets arriving in rapid succession, identifying and resolving errors, and keeping the flow moving for downstream actuarial processing. You’ll collaborate closely with senior technical experts and functional analysts and be a key player in communication with global teams.

While full automation is on the near horizon, this role currently demands agility, precision, and strong communication skills more than advanced technical development. You’ll need to listen carefully, adapt quickly to priorities, and keep the team moving forward under pressure.

Key responsibilities

• Designing, implementing and testing ETL processes
• Maintaining existing ETLs and ensuring stability of DWH
• Proficiency in UNIX shell scripting
• Integration of data from multiple sources
• SQL tuning, identification, and resolution of bottlenecks in ongoing processes
• Data analysis
• Interacting with business users regularly to consolidate and analyze requirements
• Incident and problem resolution according to project needs
• Production maintenance

Competencies

• MS degree in Computer Science, Engineering, or a related field
• Strong hands-on experience with Oracle databases (10g, 11g, 12c)
• Advanced skills in Oracle PL/SQL: functions, procedures, triggers, packages
• Unix shell scripting
• Experience with performance tuning of SQL queries, applications, and Oracle instances
• Solid understanding of data warehouse (DWH) environments
• Knowledge of data modeling concepts
• Experience with ETL processes
• Familiarity with code repository tools
• Good English communication skills, spoken and written
• Knowledge of the insurance business is a plus
• Strong team player with attention to detail and a proactive mindset

What we offer

• Contract under Polish law: B2B or Umowa o Pracę
• Benefits such as private medical care, group insurance, and Multisport card
• Opportunity to work with excellent professionals
• High standards of work and focus on code quality
• Continuous learning and growth
• International team
• Pinball, PlayStation, and more on-site