Data Warehousing Specialists

Also called: Data Management Specialist, Data Storage Specialist, Data Warehouse Analyst, Data Warehouse Developer, Data Warehouse Engineer

Varies

estimated salary

Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.

  • 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.
  • Review designs, codes, test plans, or documentation to ensure quality.
  • Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
  • 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.
Work Context
  • Electronic Mail — 100% responded "Every day".
  • Spend Time Sitting — 87% responded "Continually or almost continually".
  • Indoors, Environmentally Controlled — 96% responded "Every day".
  • Face-to-Face Discussions — 55% responded "Every day".
  • Importance of Being Exact or Accurate — 57% responded "Extremely important".
  • Telephone — 50% responded "Every day".
  • Work With Work Group or Team — 53% responded "Very important".
  • Read More
Work Activities
  • Interacting 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.
  • Thinking Creatively — Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
  • Making Decisions and Solving Problems — Analyzing information and evaluating results to choose the best solution and solve problems.
  • Read More
Detailed Work Activities
  • Test software performance.
  • Evaluate project designs to determine adequacy or feasibility.
  • Troubleshoot issues with computer applications or systems.
  • Document operational procedures.
  • Modify software programs to improve performance.
  • Design software applications.
  • Read More

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.

Skills

Reading Comprehension
  • Understanding written sentences and paragraphs in work related documents.
Critical Thinking
  • Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
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.
Read More

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.
Oral Comprehension
  • The ability to listen to and understand information and ideas presented through spoken words and sentences.
Inductive Reasoning
  • The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
Read More

Personality

People interested in this work like activities that include ideas, thinking, and figuring things out.
They do well at jobs that need:
  • Achievement/Effort
  • Persistence
  • Initiative
  • Leadership
  • Cooperation
  • Concern for Others
  • Social Orientation
  • Self Control
Read More

Technology

You might use software like this on the job:

Analytical or scientific software
  • IBM SPSS Statistics Hot Technology
  • SAS Hot Technology
  • The MathWorks MATLAB Hot Technology
  • StataCorp Stata
Electronic mail software
  • Microsoft Outlook Hot Technology
Presentation software
  • Microsoft PowerPoint Hot Technology
Read More

Education

Get started on your career:

Job Outlook

New job opportunities are very likely in the future.
Salary
NA
NA
NA

Explore More