strategie:p personalberatung

Datawarehouse Developer, DWH

strategie:p personalberatung

full-time

Posted on:

Location Type: Hybrid

Location: Oldenburg • Germany

Visit company website

Explore more

✨ AI Apply
Apply

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
  • 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 context of the DWH
  • Execution of ad-hoc database queries (source systems and DWH) and provision of data for BI tools
  • Special tasks in the data context from the IT Data Management department

Requirements

  • A degree in computer science, information technology, mathematics, natural sciences, economics, engineering with a focus on data processing is desirable, or equivalent skills and experience
  • Preferably demonstrable experience in data modeling and database design
  • Excellent SQL skills and experience implementing complex ETL processes (knowledge of PL/SQL 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
  • Very good communication skills and fluent command of the German language, both spoken and written.
Benefits
  • An interesting and varied role in a friendly, family-like environment
  • Work in a medium-sized company with growth ambitions
  • Short decision-making paths and flat hierarchies
  • Flexible working hours with a 38-hour week
  • Possibility for mobile/home working
  • Training and development opportunities
  • Occupational health management and bike leasing
  • Company pension scheme and €40 employer-funded savings allowance (VWL)
  • Performance-related pay, Christmas bonus and optional discretionary bonus
  • Joint 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 & Tools
ETL processesPL/SQLSQLdata modelingdatabase designdata cleansingdata quality validationtest case creationad-hoc database queriesdata aggregation
Soft Skills
analytical thinkingsolution-oriented working styleattention to detailquality awarenessindependencecommunication skills