Data Warehouse Engineer (m/f/d)

PAUL Tech AG is a technology leader in the real estate industry with the mission to make buildings carbon neutral. Our proprietary technology, consisting of IoT-enabled hardware and AI-supported software, permanently optimizes water-bearing systems in buildings. This reduces CO2 emissions and energy costs. Everyone benefits: owners, operators, occupants and the climate. At Paul, we are researchers, developers and practitioners with the common goal of developing intelligent solutions for buildings to combat climate change.

As a Data Warehouse engineer (m/f/d) in Berlin or Mannheim, you will play a pivotal role in utilizing data to inform and drive strategic business decisions. Collaborating closely with various teams and business partners, you gain a comprehensive understanding of business domains and processes, create and analyze diverse datasets.

Key Responsibilities

Holistic Data Management

• Your work comprises the full spectrum of data management, including data modelling, data integration, as well as aggregating data for analytical consumption and reporting

Data Modeling

• Develop a data model that allows accurate and consistent reporting and self-service analysis

Data Quality Ensurance

• You work on advancing data quality and ensure consistency

Process optimization

• Proactively improve processes, monitoring, optimizing and troubleshooting our data solutions (running Athena/Snowflake and Airflow)

Stakeholder Communication

• You will be in direct contact with stakeholders and analysts from business departments, understanding their business requirements and translating them into technical solutions

What you will bring

• Profound experience as a DWH developer
• Profound experience with data warehouse models
• Strong T-SQL / SQL skills, with proven ability to code effectively preferably Python
• Practiced and proficient in ETL/ELT procedures, data migration, integration, or data quality concepts
• Solid experience with RDBMS like Postgres plus strong NoSQL and unstructured datastore skills
• You have worked with the AWS data stack in the past (e.g: S3, Redshift, Lambda, Athena etc.)
• Team player, highly motivated, able to work independently with extreme user-orientation

Are you convinced ? Then we offer

• A meaningful job that contributes to global CO2 savings
• A collegial working atmosphere with short decision paths
• A permanent contract with an above-average salary
• 30 days vacation per calendar year plus 24.12. and 31.12. off
• Company private health insurance and supplementary pension
• Company fitness subsidy in your region
• Regular company events to which you are very welcome
• Tram ticket as well as drinks and fruit in our offices