Oracle Data Engineer, German Language

This is a fully remote position, open to applicants in Poland.

📋 Description

• About Us:

• Soname Solutions is a passionate group dedicated to data analytics and big data, assisting our clients in transforming into data-driven enterprises.

• Our team is continually growing, comprising over 60 professionals from Germany, Poland, and Georgia.

• We combine extensive expertise with a human touch, having worked in data analysis for the past 15 years. This wealth of experience, coupled with our team's analytical prowess and thirst for knowledge, shapes our collaborative approach with each other and our clients. This is enriched by qualities such as kindness, curiosity, empathy, a willingness to assist, trust, and transparency. These attributes enable us to discover optimal technical solutions that delight our customers, forming the foundation for enduring relationships with international corporations who consistently praise our services.

• **Position:**

• We are in search of a Senior Data Warehouse Developer to join our team.

• **Project Overview:** As part of this initiative, we collaborate with a German telecom company.

• **Technology Stack:** SQL, DWH, Power BI, Oracle, PostgreSQL.

⛳️ Requirements

• As a Data Engineer, your responsibilities will include:

• - Understanding intricate business processes and their technical execution in the DWH.

• - Designing and implementing ETL/ELT processes within a comprehensive, multi-layered DWH.

• - Optimizing performance at both the database and ETL levels.

• - Proposing architectural solutions for new developments within our DWH.

• - Collaborating closely with business departments to align requirements and develop joint solutions.

• - Working independently with a high level of personal accountability.

• We expect you to possess:

• - In-depth knowledge of traditional 3-layer DWH architectures (Staging/Core/Data Marts).

• - Strong proficiency in 3NF modeling, Inmon architectures, and dimensional modeling (Kimball).

• - Experience with technical data versioning (historization).

• - Extensive experience in performance optimization, including:

• - Analyzing and enhancing execution plans.

• - Implementing and managing partitioning strategies.

• - Monitoring and controlling large data volumes.

• - Excellent SQL skills; *PL/SQL* knowledge is a significant advantage.

• - Proficiency in German (very good level) along with strong communication abilities.

• **Soft Skills:**

• - An independent and organized approach to work.

• - The ability to convey complex technical solutions in a clear and comprehensible manner.

• - A proactive role in shaping the future architecture of the DWH.

🏝️ Benefits

• We provide you with:

• - Long-term projects (12 months+) with prominent global companies that have a stellar reputation;

• - Strong relationships with clients;

• - A friendly, well-coordinated, and supportive team;

• - Mentorship during the initial months of employment;

• - Paid sick leave and 5 days off annually;

• - Up to 26 days of paid vacation;

• - Coverage for medical care expenses;

• - Competitive salary with regular performance and salary reviews;

• - A fully remote working arrangement;

• - Engaging corporate events;

• - Gifts and delightful surprises for significant occasions;

• - Daily communication in English/German.