Data warehouse designer

Also searched as: Diseñador de almacenes de datos

Code 2521.5

What does a Data warehouse designer do?

Data warehouse designers are responsible for planning, connecting, designing, scheduling, and deploying data warehouse systems. They develop, monitor and maintain ETL processes, reporting applications and data warehouse design.

Working on a Data warehouse designer role?

Use this profile as a starting point. Align responsibilities and assessment criteria with your team's actual needs.

The app link opens registration. You can create your role after signing in.

Essential skills

Knowledge

  • data warehouse
  • database
  • business process modelling
  • information structure
  • database development tools
  • ICT security legislation
  • resource description framework query language
  • query languages
  • web programming
  • database management systems
  • systems theory

Skills and competences

  • analyse business requirements
  • apply ICT systems theory
  • create database diagrams
  • create software design
  • define technical requirements
  • develop automated migration methods
  • design database scheme
  • assess ICT knowledge
  • create data sets
  • manage database
  • manage standards for data exchange
  • identify software for warehouse management
  • operate relational database management system
  • migrate existing data
  • write database documentation
  • use databases
  • use markup languages

Download the role profile

We'll send you a profile ready to paste into your job ad: purpose, essential and optional skills, and what to assess. One email, no signup.

What to assess for this role

Technical knowledge can be verified with tests and references. What never shows up on a CV are the transversal competences, and they explain most failed hires. Before closing, it pays to measure them with a standardised battery.

See psychometric assessment

Need to find this profile?

We source, screen and assess candidates for this kind of role, with a replacement guarantee. Fast process and a flat fee per role, no percentage of the salary.

In Obrii App the profile becomes a job descriptor, a CV screener and an interview scorecard.

Sources

This service uses the ESCO classification of the European Commission and the Mapha Taxonomy developed by OTIC SOFOFA (CC BY 4.0), in an adapted version. Group codes come from the ILO's ISCO-08. See sources and licences