Data Warehouse Developer

Jobtailor; Oldenburg; Vor Ort; EUR 65.000 - 90.000; Vollzeit

Zusammenfassung

Jobtailor is looking for a Data Warehouse Administrator to manage and optimize the DWH, focusing on ETL processes and data quality. You will create views, perform data modeling and coordinate with business units to ensure reliable data for BI reporting.

The role requires strong SQL skills, experience with ETL, and excellent German communication. You will work in Niedersachsen, Oldenburg, primarily on-site with cross-functional collaboration.

Qualifikationen

• Degree in Computer Science or equivalent qualifications/experience
• Proven experience in data modeling and database design
• Strong SQL skills and experience implementing ETL processes (PL/SQL a plus)
• Experience with common BI tools (e.g., Power BI)
• Strong analytical thinking and a systematic, solution-oriented work style
• Very good German language skills, both written and spoken

Aufgaben

• Administration, development and optimization of the data warehouse (DWH), with a focus on ETL processes
• Development of views and aggregations
• Normalization and denormalization of data models
• Coordination and documentation with business units
• Validation of data quality and consistency, as well as data cleansing
• Creation and execution of tests
• Performing ad-hoc database queries and providing data for BI tools

Kenntnisse

Analytical thinking

Solution-oriented work style

Coordination

Documentation

Ausbildung

Degree in Computer Science

Tools

SQL

Power BI

Jobbeschreibung

• Administration, development and optimization of the data warehouse (DWH), with a focus on ETL processes
• Development of views and aggregations
• Normalization and denormalization of data models
• Coordination and documentation with business units
• Validation of data quality and consistency, as well as data cleansing
• Creation and execution of tests
• Performing ad-hoc database queries and providing data for BI tools

Requirements

• Degree in Computer Science or equivalent qualifications/experience
• Proven experience in data modeling and database design
• Strong SQL skills and experience implementing ETL processes (PL/SQL a plus)
• Experience with common BI tools (e.g., Power BI)
• Strong analytical thinking and a systematic, solution-oriented work style
• Very good German language skills, both written and spoken

Hard Skills

• Data Warehouse Administration
• ETL Processes
• SQL
• Data Modeling
• Database Design
• Data Quality Validation
• Data Cleansing
• Ad-Hoc Database Queries
• Views Development
• Aggregations Development

Soft Skills

• Analytical Thinking
• Solution-Oriented Work Style
• Coordination
• Documentation