Oracle Data Engineer (with German Language)

Job Description

Who we are:

Soname Solutions is a group of enthusiasts who are in love with data analytics and big data. We help our clients in becoming data-driven companies.

Our team keeps expanding, and it includes 60+ professionals from Germany, Poland and Georgia.

We blend deep expert knowledge with humanity. We have been working in data analysis for the last 15 years. This vast experience, analytical skills of our team members, hunger for knowledge define our way of working with each other and our clients. This is all seasoned with kindness, curiosity, empathy, willingness to help, trust, and transparency. The best qualities of our team serve us in finding optimal technical solutions that please our customers. All of that is a base for long-term relations with international corporations. They are always wowed with our services.

Position:

We are looking for a Senior Data Warehouse Developer to become a part of our team.

About the project:
As part of this project, we cooperate with German telecom company.

Tech stack: SQL, DWH, Power BI, Oracle, PostgreSQL.

Requirements

As a Data Engineer, you will be responsible for:

• Familiarization with complex business processes and their technical implementation in the DWH
• Designing and implementing ETL/ELT processes in a comprehensive, multi-layered DWH.
• Performance optimization at the database and ETL level
• Creating architecture proposals for new developments within our DWH.
• Close collaboration with business departments to align requirements and find joint solutions
• Independent work with a high degree of personal responsibility

We expect from you:

• Deep expertise in classic 3-layer DWH architectures (Staging/Core/Data Marts).
• Strong knowledge of 3NF modeling, Inmon architectures, and dimensional modeling (Kimball).
• Experience with technical data versioning (historization).
• Solid experience in performance optimization, including:
• Analyzing and improving execution plans.
• Implementing and managing partitioning concepts.
• Monitoring and controlling large data volumes.

• Excellent knowledge of SQL; PL/SQL is a distinct advantage.
• Proficiency in German (very good level) and strong communication skills.

Soft Skills:

• Independent and structured way of working.
• Ability to explain complex technical solutions clearly and understandably.
• Proactive involvement in shaping the future DWH architecture.

Benefits

We offer you:

• Long-term projects (12m+) with leading global companies with a worldwide reputation;
• Strong relationships with clients;
• Friendly, well-coordinated, and helpful team;
• Mentoring in the first months of work;
• Paid sick leave and 5 days off a year;
• Up to 26-days of paid vacation;
• Medical care payment;
• Competitive salary, regular performance, and salary review process;
• Fully remote position;
• Interesting corporate events;
• Gifts and pleasant surprises for significant events;
• Daily English / German communication.