Data Warehousing Specialists
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
Sample of reported job titles:
Data Warehouse Analyst, Data Warehouse Solution Architect
Occupation-Specific Information
Tasks
- 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.
- Prepare functional or technical documentation for data warehouses.
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
Technology Skills
- Analytical or scientific software:IBM SPSS Statistics,SAS statistical software,StataCorp Stata,The MathWorks MATLAB
- Application server software:Oracle WebLogic Server
- Backup or archival software:Veritas NetBackup
- Business intelligence and data analysis software:IBM Cognos Impromptu,MicroStrategy,Oracle Business Intelligence Enterprise Edition,Qlik Tech QlikView,Tableau,TIBCO Spotfire
- Cloud-based data access and sharing software:Microsoft SharePoint
Occupational Requirements
Work Activities
- Working with Computers:Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
- Analyzing Data or Information:Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
- Processing Information:Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
- Getting Information:Observing, receiving, and otherwise obtaining information from all relevant sources.
- Updating and Using Relevant Knowledge:Keeping up-to-date technically and applying new knowledge to your job.
Detailed Work Activities
- Analyze data to identify trends or relationships among variables.
- Create databases to store electronic data.
- Design software applications.
- Develop diagrams or flow charts of system operation.
- Develop models of information or communications systems.
Work Context
- Electronic Mail:100% responded"Every day"
- Indoors, Environmentally Controlled:96% responded"Every day"
- Spend Time Sitting:86% responded"Continually or almost continually"
- Physical Proximity:74% responded"Slightly close (e.g., shared office)"
- Freedom to Make Decisions:65% responded"Some freedom"
Worker Requirements
Skills
- Critical Thinking:Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
- Reading Comprehension:Understanding written sentences and paragraphs in work-related documents.
- Programming:Writing computer programs for various purposes.
- Complex Problem Solving:Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
- Active Listening:Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
Knowledge
- Computers and Electronics:Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
- Mathematics:Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
- English Language:Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
- Design:Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.
Education
How much education does a new hire need to perform a job in this occupation? Respondents said:
- 78%Bachelor's Degree
Worker Characteristics
Abilities
- Information Ordering:The ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations).
- Written Comprehension:The ability to read and understand information and ideas presented in writing.
- Deductive Reasoning:The ability to apply general rules to specific problems to produce answers that make sense.
- Inductive Reasoning:The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
- Oral Comprehension:The ability to listen to and understand information and ideas presented through spoken words and sentences.
Interests
- Investigative:Investigative occupations frequently involve working with ideas, and require an extensive amount of thinking. These occupations can involve searching for facts and figuring out problems mentally.
- Conventional:Conventional occupations frequently involve following set procedures and routines. These occupations can include working with data and details more than with ideas. Usually there is a clear line of authority to follow.
Work Values
- Achievement:Occupations that satisfy this work value are results oriented and allow employees to use their strongest abilities, giving them a feeling of accomplishment. Corresponding needs are Ability Utilization and Achievement.
- Working Conditions:Occupations that satisfy this work value offer job security and good working conditions. Corresponding needs are Activity, Compensation, Independence, Security, Variety and Working Conditions.
- Independence:Occupations that satisfy this work value allow employees to work on their own and make decisions. Corresponding needs are Creativity, Responsibility and Autonomy.
Work Styles
- Analytical Thinking:Job requires analyzing information and using logic to address work-related issues and problems.
- Attention to Detail:Job requires being careful about detail and thorough in completing work tasks.
- Initiative:Job requires a willingness to take on responsibilities and challenges.
- Persistence:Job requires persistence in the face of obstacles.
- Cooperation:Job requires being pleasant with others on the job and displaying a good-natured, cooperative attitude.
More Information
Get yourself a new skill
In this Path
Track1
Analytical Skills
Track2
Microsoft Office Set
Microsoft Excel
This course is designed to take you from Zero to Hero on Excel, and make your accounting job and req...
Read moreFiltered AI
Microsoft Word
Word is not just for writing plain text; and this is why this course is here to guide you through ev...
Read moreIntellezy Learning