PL / SQL Developer

About Webellian

Webellian is a well-established Digital transformation and IT consulting company committed to creating a positive impact for our clients. We are driven by shared values, strong principles, and a passion for innovative and disruptive technologies. We are a community of engineers and senior advisors who work with our clients across industries, playing a deep and meaningful role in accelerating and realizing their vision and strategy.

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 an PL /SQL Developer, you'll be responsible for uploading and validating large volumes of actuarial datasets, ensuring their technical accuracy (formatting, structure, 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.


• Data modeling of Global Data Model - Data Store and Data Marts (Star Schema/Snowflake).


• Integration of data from multiple sources.


• SQL tuning, identification, and resolution of bottlenecks in ongoing processes.


• Data analysis.


• Interact with business users on a regular basis to consolidate and analyze the 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


• 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, Multisport card


• Opportunity to work with excellent professionals


• High standards of work and focus on the quality of code


• Continuously learning and growth


• International team


• Pinball, PlayStation & much more (on-site 🤫)