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
- 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.
- Identifying Objects, Actions, and Events - Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.
- Making Decisions and Solving Problems - Analyzing information and evaluating results to choose the best solution and solve problems.
- Thinking Creatively - Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
- Communicating with Supervisors, Peers, or Subordinates - Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
- Interpreting the Meaning of Information for Others - 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
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
NetApp Certified Technology AssociateCertifying Organization
Network Appliance, Inc.
Type
Product/Equipment
Certificate name
IBM Certified Architect - Cloud Pak for Data V4.7Certifying Organization
IBM Corporation
Type
Product/Equipment
Certificate name
Certified Data Management AdministratorCertifying Organization
Network Appliance, Inc.
Type
Specialty
Certificate name
CompTIA Cloud EssentialsCertifying Organization
Computing Technology Industry Association (CompTIA)
Type
Core
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 | Income |
|---|---|
| Low (10%) | $NaN |
| Median (50%) | $NaN |
| High (90%) | $NaN |
Income by Experience
This table shows how income typically grows with experience—from entry level (0–2 years), to mid-level (3–7 years), to senior level (8+ years).
| Experience | Income |
|---|---|
| Entry Level | $50,000 |
| Mid Level | $100,000 |
| Senior Level | $150,000 |
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%
The career information and data on this site incorporates information from O*NET Web Services by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA), with ONET® being a registered trademark of USDOL/ETA. Used under the CC BY 4.0 license. O*NET® is a trademark of USDOL/ETA; CareerOneStop, sponsored by the U.S. Department of Labor, Employment and Training Administration (DOLETA) and the Minnesota Department of Employment and Economic Development (DEED); and the U.S. Bureau of Labor Statistics (BLS).
Career Resources
Search All Careers
Compare Careers
Income Outlook
Career Pathways
Career Clusters
Job Suite Home
CVs
Resumes
Cover Letters
Templates
Job Resources
Blog Articles
Podcast