af05383bb1
Snapshot before the quality program (relevance gates, tiered mapping, QA linter). v1 is the immutable before/after reference; evidence crawl was at ~175/3039 occupations when tagged. Co-Authored-By: Claude Fable 5 <noreply@anthropic.com> Claude-Session: https://claude.ai/code/session_01PDKeXvpT6tENSvyQGLV1Uq
62 lines
2.7 KiB
Markdown
62 lines
2.7 KiB
Markdown
---
|
|
name: data-warehouse-designer
|
|
description: "Occupational skill for the role 'data warehouse designer' (also: data warehouse architect, data warehouse developer). Use when the user asks for typical data warehouse designer work such as: Test software systems or applications for software enhancements or new products.; Review designs, codes, test plans, or documentation to ensure quality.; Provide or coordinate troubleshooting support for data warehouses."
|
|
---
|
|
|
|
# Data Warehouse Designer
|
|
|
|
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.
|
|
|
|
## Core workflow
|
|
|
|
1. Test software systems or applications for software enhancements or new products.
|
|
2. Review designs, codes, test plans, or documentation to ensure quality.
|
|
3. Provide or coordinate troubleshooting support for data warehouses.
|
|
4. Prepare functional or technical documentation for data warehouses.
|
|
5. Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
|
|
6. Verify the structure, accuracy, or quality of warehouse data.
|
|
7. Select methods, techniques, or criteria for data warehousing evaluative procedures.
|
|
8. Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
|
|
|
|
## How to use this skill
|
|
|
|
- Read [references/profile.md](references/profile.md) for the occupation profile and scope.
|
|
- Consult [references/tasks.md](references/tasks.md) for the full task and activity inventory.
|
|
- Check [references/skills.md](references/skills.md) for essential vs. optional competences.
|
|
- Check [references/tools.md](references/tools.md) for the software commonly used in this role.
|
|
- See [references/ai-skills.md](references/ai-skills.md) — matched external AI agent skills (per-source attribution).
|
|
|
|
## Key competences (essential)
|
|
|
|
- analyse business requirements
|
|
- apply ICT systems theory
|
|
- assess ICT knowledge
|
|
- business process modelling
|
|
- create data sets
|
|
- create database diagrams
|
|
- create software design
|
|
- data warehouse
|
|
- database
|
|
- database development tools
|
|
- database management systems
|
|
- define technical requirements
|
|
- design database scheme
|
|
- develop automated migration methods
|
|
- ICT security legislation
|
|
|
|
## Hot technologies
|
|
|
|
- IBM SPSS Statistics
|
|
- SAS
|
|
- The MathWorks MATLAB
|
|
- Microsoft Power BI
|
|
- Tableau
|
|
- Splunk Enterprise
|
|
- Atlassian JIRA
|
|
- Amazon DynamoDB
|
|
- Apache Cassandra
|
|
- Apache Hadoop
|
|
|
|
---
|
|
*Sources: ESCO v1.2.1 (http://data.europa.eu/esco/occupation/1562c7a3-c7d9-419d-b9b6-db26610bcf84), O*NET 30.3 (15-1243.01). See manifest.json for licensing/attribution.*
|