strategie:p personalberatung

Data Warehouse Developer, DWH

strategie:p personalberatung

full-time

Posted on:

Location Type: Hybrid

Location: Oldenburg • 🇩🇪 Germany

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

ETLSQL

About the role

  • Administration, development and optimization of the data warehouse (DWH), in particular ETL processes using PL/SQL or other tools/languages, as well as the design and maintenance of dimensions, facts and hierarchies
  • Development of views and aggregations
  • Normalization and denormalization of data models
  • Coordination and documentation with business units regarding DWH development
  • Validation of data quality and consistency, as well as data cleansing
  • Creation of test cases and execution of tests in the DWH context
  • Execution of ad-hoc database queries (source systems and DWH) and provisioning of data for BI tools
  • Special tasks related to data within the IT department

Requirements

  • A degree is desirable in computer science, information technology, a mathematical, natural science, business or technical field, each with a focus on data processing, or equivalent skills and experience
  • Preferably demonstrable experience in data modeling and database design
  • Excellent knowledge of SQL and implementation of complex ETL processes (PL/SQL experience is an advantage)
  • Demonstrable experience with common BI tools (e.g., Power BI)
  • Strong analytical thinking and a systematic, solution-oriented working style
  • High degree of independence, attention to detail and quality awareness
  • Excellent communication skills and fluency in German, both written and spoken
Benefits
  • An interesting and varied role in a family-oriented environment
  • Work in a medium-sized company with growth ambitions
  • Short decision-making processes and flat hierarchies
  • Flexible working hours with a 38-hour workweek
  • Option for mobile/remote working
  • Training and development opportunities
  • Occupational health management and bike leasing
  • Company pension scheme and €40 VWL (capital-forming benefits)
  • Performance-based pay, Christmas bonus and optional discretionary bonus
  • Team activities such as barbecue and Christmas parties

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
PL/SQLETL processesSQLdata modelingdatabase designdata cleansingdata quality validationtest case creationad-hoc database queriesdata aggregation
Soft skills
analytical thinkingsolution-oriented working styleattention to detailquality awarenessindependencecommunication skills