Description
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
Interests
- Conventional
- Investigative
Work Values
- Achievement
- Working Conditions
- Independence
Work Styles
- Analytical Thinking
- Attention to Detail
- Initiative
- Persistence
- Cooperation
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.
Work Activities
- Working with Computers
- Analyzing Data or Information
- Processing Information
- Getting Information
- Updating and Using Relevant Knowledge
Detailed Work Activities
- Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
- Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
- Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
- Observing, receiving, and otherwise obtaining information from all relevant sources.
- Keeping up-to-date technically and applying new knowledge to your job.
- Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.
- Analyzing information and evaluating results to choose the best solution and solve problems.
- Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
- Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
- Translating or explaining what information means and how it can be used.
Technology Skills
- Data base management system software
- Presentation software
- Metadata management software
- Operating system software
- Development environment software
Abilities
- Information Ordering
- Written Comprehension
- Deductive Reasoning
- Inductive Reasoning
- Oral Comprehension
Skills
- Critical Thinking
- Reading Comprehension
- Programming
- Complex Problem Solving
- Active Listening
Knowledge
- Computers and Electronics
- Mathematics
- English Language
- Design
Most Common Education Level
The “Most Common Education Level” refers to the level of education held by the majority of workers in a given occupation. For example, if the highest percentage of workers in a role have an Associate’s Degree, that suggests this is the typical educational requirement. Knowing this helps you plan how many years of education you may need to pursue that career.
Certificates
Certificate name
HP Technical Certified I - SMB Storage Solutions [2012]Certifying Organization
Hewlett Packard Certification and Learning
Type
Product/Equipment
Certificate name
Teradata Aster Certified Professional 6.10Certifying Organization
Teradata
Type
Product/Equipment
Certificate name
Specialist - Systems Administrator, Avamar Version 8.0Certifying Organization
Dell Corporation
Type
Product/Equipment
Certificate name
SAP Certified Development Associate - SAP Cloud PlatformCertifying Organization
SAP America, Inc.
Type
Product/Equipment
Certificate name
HP ASE - Data Center and Cloud Architect V2Certifying Organization
Hewlett Packard Certification and Learning
Type
Product/Equipment
Income Percentile
The income percentiles show how earnings are distributed within a profession. The 10th percentile means that 10% of workers earned less than that amount. The median (50th percentile) indicates that half of workers earned more, and half earned less. The 90th percentile reflects what the top 10% of earners in the field make.
| Income Percentile | Annual Income |
|---|---|
| Low (10%) | $59,697 |
| Median (50%) | $133,872 |
| High (90%) | $185,992 |
Income by Experience
This table shows how income typically grows with experience—from entry level (0–2 years), to mid-level (3–5 years), to senior level (6–8 years), to expert level (8+ years).
| Experience | Income |
|---|---|
Entry Level  | N/A |
| Mid Level | N/A |
| Senior Level | N/A |
| Expert Level | N/A |
Employability
There are currently 61,400 jobs in this career path. Over the next 10 years, that number is expected to increase to 68,000 positions, reflecting a projected growth of 11%.
The Projected Job Growth figure refers to the expected increase or decrease in employment within a specific career field over a certain period of time.
Projected Job Growth of 11%
Related Careers
The career information and data on this site incorporates information from O*NET Web Services, Lightcast, CareerOneStop, and the U.S. Bureau of Labor Statistics (BLS). For more details regarding the data sources and the specific information sourced, click here.
Career Resources
Search All Careers
Compare Careers
Income Outlook
Career Pathways
Career Clusters
Job Suite Home
CV Templates
Resume Templates
Cover Letter Templates
All Templates
Job Resources
Blog Articles
Podcast