Data Warehousing Specialists
Overview
SaveJob Zone Four: Considerable Preparation Needed
Experience
A considerable amount of work-related skill, knowledge, or experience is needed for these occupations. For example, an accountant must complete four years of college and work for several years in accounting to be considered qualified.
Education
Most of these occupations require a four-year bachelor's degree, but some do not.
Job Training
Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.
Examples
Many of these occupations involve coordinating, supervising, managing, or training others. Examples include real estate brokers, sales managers, database administrators, graphic designers, conservation scientists, art directors, and cost estimators.
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
Demand
Core Tasks
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- Verify the structure, accuracy, or quality of warehouse data.
- Map data between source systems, data warehouses, and data marts.
- Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
- Design and implement warehouse database structures.
- Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
- Provide or coordinate troubleshooting support for data warehouses.
- Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
- Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
- Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
- Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- Create or implement metadata processes and frameworks.
- Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
- Review designs, codes, test plans, or documentation to ensure quality.
- Select methods, techniques, or criteria for data warehousing evaluative procedures.
- Implement business rules via stored procedures, middleware, or other technologies.
- Prepare functional or technical documentation for data warehouses.
- Test software systems or applications for software enhancements or new products.
Technology Skills
Technology
Example
Hot Technology
Tools Used
Tool
Example
Top 10 Knowledge Required
Computers and Electronics
86%
Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
Mathematics
65%
Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
English Language
64%
Knowledge of the structure and content of the English language including the meaning and spelling of words, and rules of composition and grammar.
Design
61%
Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.
Engineering and Technology
58%
Knowledge of the practical application of engineering science and technology. This includes applying principles, techniques, procedures, and equipment to the design and production of various goods and services.
Administration and Management
53%
Knowledge of business and management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources.
Customer and Personal Service
49%
Knowledge of principles and processes for providing customer and personal services. This includes customer needs assessment, meeting quality standards for services, and evaluation of customer satisfaction.
Economics and Accounting
45%
Knowledge of economic and accounting principles and practices, the financial markets, banking, and the analysis and reporting of financial data.
Education and Training
45%
Knowledge of principles and methods for curriculum and training design, teaching and instruction for individuals and groups, and the measurement of training effects.
Production and Processing
43%
Knowledge of raw materials, production processes, quality control, costs, and other techniques for maximizing the effective manufacture and distribution of goods.
Top 10 Skills
Critical Thinking
78%
Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
Reading Comprehension
78%
Understanding written sentences and paragraphs in work-related documents.
Programming
75%
Writing computer programs for various purposes.
Complex Problem Solving
73%
Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
Active Listening
70%
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.
Systems Analysis
70%
Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
Judgment and Decision Making
68%
Considering the relative costs and benefits of potential actions to choose the most appropriate one.
Speaking
68%
Talking to others to convey information effectively.
Systems Evaluation
65%
Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.
Writing
65%
Communicating effectively in writing as appropriate for the needs of the audience.
Top 10 Abilities
Information Ordering
78%
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
78%
The ability to read and understand information and ideas presented in writing.
Deductive Reasoning
75%
The ability to apply general rules to specific problems to produce answers that make sense.
Inductive Reasoning
75%
The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
Oral Comprehension
75%
The ability to listen to and understand information and ideas presented through spoken words and sentences.
Near Vision
73%
The ability to see details at close range (within a few feet of the observer).
Category Flexibility
70%
The ability to generate or use different sets of rules for combining or grouping things in different ways.
Oral Expression
70%
The ability to communicate information and ideas in speaking so others will understand.
Speech Recognition
70%
The ability to identify and understand the speech of another person.
Written Expression
70%
The ability to communicate information and ideas in writing so others will understand.
Top 10 Work Activities
Working with Computers
100%
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
91%
Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
Processing Information
90%
Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
Getting Information
89%
Observing, receiving, and otherwise obtaining information from all relevant sources.
Updating and Using Relevant Knowledge
85%
Keeping up-to-date technically and applying new knowledge to your job.
Identifying Objects, Actions, and Events
81%
Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.
Thinking Creatively
80%
Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
Communicating with Supervisors, Peers, or Subordinates
79%
Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
Making Decisions and Solving Problems
79%
Analyzing information and evaluating results to choose the best solution and solve problems.
Interpreting the Meaning of Information for Others
76%
Translating or explaining what information means and how it can be used.
Detailed Work Activities
- Develop models of information or communications systems.
- Evaluate data quality.
- Develop diagrams or flow charts of system operation.
- Develop procedures for data management.
- Create databases to store electronic data.
- Troubleshoot issues with computer applications or systems.
- Modify software programs to improve performance.
- Design software applications.
- Write computer programming code.
- Analyze data to identify trends or relationships among variables.
- Document operational procedures.
- Evaluate project designs to determine adequacy or feasibility.
- Develop testing routines or procedures.
- Develop performance metrics or standards related to information technology.
- Apply new technologies to improve work processes.
- Apply information technology to solve business or other applied problems.
- Test software performance.
Education
Interests
Conventional
91%
Work involves following procedures and regulations to organize information or data, typically in a business setting. Conventional occupations are often associated with office work, accounting, mathematics/statistics, information technology, finance, or human resources.
Investigative
68%
Work involves studying and researching non-living objects, living organisms, disease or other forms of impairment, or human behavior. Investigative occupations are often associated with physical, life, medical, or social sciences, and can be found in the fields of humanities, mathematics/statistics, information technology, or health care service.
Enterprising
45%
Work involves managing, negotiating, marketing, or selling, typically in a business setting, or leading or advising people in political and legal situations. Enterprising occupations are often associated with business initiatives, sales, marketing/advertising, finance, management/administration, professional advising, public speaking, politics, or law.
Realistic
41%
Work involves designing, building, or repairing of equipment, materials, or structures, engaging in physical activity, or working outdoors. Realistic occupations are often associated with engineering, mechanics and electronics, construction, woodworking, transportation, machine operation, agriculture, animal services, physical or manual labor, athletics, or protective services.
Social
29%
Work involves helping, teaching, advising, assisting, or providing service to others. Social occupations are often associated with social, health care, personal service, teaching/education, or religious activities.
Artistic
24%
Work involves creating original visual artwork, performances, written works, food, or music for a variety of media, or applying artistic principles to the design of various objects and materials. Artistic occupations are often associated with visual arts, applied arts and design, performing arts, music, creative writing, media, or culinary art.
Work Values
Achievement
86%
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
77%
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
72%
Occupations that satisfy this work value allow employees to work on their own and make decisions. Corresponding needs are Creativity, Responsibility and Autonomy.
Recognition
58%
Occupations that satisfy this work value offer advancement, potential for leadership, and are often considered prestigious. Corresponding needs are Advancement, Authority, Recognition and Social Status.
Support
58%
Occupations that satisfy this work value offer supportive management that stands behind employees. Corresponding needs are Company Policies, Supervision: Human Relations and Supervision: Technical.
Relationships
39%
Occupations that satisfy this work value allow employees to provide service to others and work with co-workers in a friendly non-competitive environment. Corresponding needs are Co-workers, Moral Values and Social Service.