Occupation
Data Warehousing Specialists
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
$139,500 medianBright outlookBachelor's typical
O*NET 31.0 · 15-1243.01
A typical week, in the words of people in the job
- 01Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- 02Verify the structure, accuracy, or quality of warehouse data.
- 03Map data between source systems, data warehouses, and data marts.
- 04Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
- 05Design and implement warehouse database structures.
- 06Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
- 07Provide or coordinate troubleshooting support for data warehouses.
- 08Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
- 09Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
- 10Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
- 11Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- 12Create or implement metadata processes and frameworks.
Task statements ranked by how many workers report them · O*NET 31.0
What the posting will be called
Data Warehouse AnalystData Warehouse Solution Architect
Titles reported by employers for this occupation. Search job boards with these, not the O*NET name.
Knowledge the job leans on
Computers and ElectronicsMathematicsEnglish LanguageDesignEngineering and TechnologyAdministration and ManagementCustomer and Personal ServiceEconomics and Accounting
Skills that carry over from service
ProgrammingComplex Problem SolvingSystems AnalysisJudgment and Decision MakingSystems EvaluationCoordinationSocial PerceptivenessTime Management