Senior DWH Architect responsible for Oracle Data Warehouse integration and ETL processes. Collaborating with teams to enhance data architecture in telecommunications sector.
Responsibilities
You take end-to-end responsibility — from requirements analysis to production deployment.
Integrate and connect new data sources into the central Oracle Data Warehouse
Develop and implement efficient ETL processes
Design and implement data models for staging, integration, and mart layers
Analyze, model, and prepare technical and financial data
Populate the mart layer for data delivery and integration into Power BI — with a focus on performance and high availability (Always-On)
Conduct performance analyses and targeted optimizations
Ensure data quality: plausibility checks, validations, monitoring
Maintain and further develop data lineage and metadata management
Prepare analyses, reports, and dashboards for business and management stakeholders
Work closely with IT, engineering, and business units to translate technical requirements into scalable data solutions
Provide thorough documentation of data flows, processes, and system architecture
Requirements
Degree in Computer Science, Business Informatics, or a comparable qualification
At least 7 years of experience developing Oracle-based data warehouse solutions
Strong knowledge of Oracle PL/SQL
Solid expertise in SQL tuning, performance optimization, and Oracle architecture
Deep understanding of data warehouse design, dimensional modeling, and ETL concepts
Experience in data modeling: ER models, star schema, snowflake schema
Experience with ETL tools, data lineage tools, and metadata management solutions
Excellent German skills (C1/C2, business fluent)
Good English skills
Benefits
Full-time (100% FTE)
Remote/Hybrid (on-site once per month in Southern Germany)
SAP Integration Architect responsible for leading SAP Integration projects across global clients. Utilizing expertise in SAP Integration and related technologies to enhance client operations.
Principal Engineer in CPU Architecture at Intel developing cutting - edge modular CPUs influencing industry performance. Focused on defining specifications and mentoring technical leaders to shape future CPU designs.
Technical Program Manager leading enterprise data platform modernization and Snowflake migration programs for BFSI clients. Collaborating with stakeholders to ensure alignment with business goals and regulatory requirements.
Junior Architect participating in all stages of residential project development. Involves client meetings, conceptual development, modeling, rendering, and technical detailing.
Principal Architect leading architectural decisions and cloud adoption for a top insurance software vendor. Influencing product direction and engineering practices across teams globally.
Architect/Project Manager developing innovative concepts for residential and commercial buildings in Hamburg. Collaborating closely with clients and project stakeholders in a hybrid work environment.
Business Intelligence Architect with over 10 years experience developing BI solutions. Leading enterprise projects using Power BI, Tableau, and data governance in insurance domain.
Hands - on Lead Architect focusing on SRE practices, cloud technology implementation, and automation. Working specifically within AWS architecture and observability frameworks.
Cloud Architect responsible for installation, operation, and maintenance of products on cloud infrastructures. Supporting development and management teams to enhance E - Health solutions in Germany.