Your #1 choice for free
Job Descriptions
Job Details
Occupation Information

Data Warehousing Specialists
SOC Code: 15-1199.07

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 Manager, Data Warehouse Solution Architect

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.
  • 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.

Technology Skills

  • Analytical or scientific software - IBM SPSS Statistics ; SAS ; 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 ; Tableau ; TIBCO Spotfire (see all 6 examples)
  • Clustering software - Aster Data nCluster
  • Communications server software - IBM Domino
  • Configuration management software - Perforce Helix software
  • Content workflow software - Atlassian JIRA
  • Customer relationship management CRM software - Blackbaud The Raiser's Edge
  • Data base management system software - Apache Hadoop ; MongoDB ; Oracle PL/SQL ; Teradata Database (see all 23 examples)
  • Data base reporting software - IBM Netezza TwinFin; Microsoft SQL Server Reporting Services ; Oracle SQL Loader; SAP Crystal Reports (see all 5 examples)
  • Data base user interface and query software - Apache Hive ; Microsoft Access ; Structured query language SQL ; Teradata BTEQ (see all 9 examples)
  • Data mining software - Rapid-I RapidMiner; SAP NetWeaver Business Warehouse; Teradata Parallel Transporter; Teradata Tpump (see all 5 examples)
  • Desktop publishing software - Microsoft Publisher
  • Development environment software - C ; Common business oriented language COBOL ; Eclipse IDE ; Microsoft .NET Framework (see all 12 examples)
  • Document management software - Teradata FastExport
  • Electronic mail software - Microsoft Outlook
  • Enterprise application integration software - Extensible markup language XML ; IBM WebSphere ; SMSi Twister Data Integrator; Talend Open Studio (see all 6 examples)
  • Enterprise resource planning ERP software - Microsoft Dynamics ; NetSuite ERP ; Oracle PeopleSoft ; SAP (see all 8 examples)
  • Enterprise system management software - Splunk Enterprise
  • File versioning software - Apache Subversion SVN
  • Graphics or photo imaging software - Microsoft Visio
  • Human resources software - Human resource management software HRMS
  • Information retrieval or search software - Apache Avro
  • Map creation software - ESRI ArcGIS software
  • Metadata management software - CA Erwin Data Modeler ; Oracle Warehouse Builder; Pentaho Kettle; SAS Data Integration Server (see all 16 examples)
  • Network monitoring software - Nagios
  • Object or component oriented development software - Advanced business application programming ABAP ; Oracle Java ; Python ; Scala (see all 10 examples)
  • Object oriented data base management software - PostgreSQL
  • Office suite software - Microsoft Office
  • Operating system software - Bash ; Linux ; Oracle Solaris ; Shell script (see all 12 examples)
  • Portal server software - Apache HTTP Server
  • Presentation software - Microsoft PowerPoint
  • Project management software - Microsoft Project ; Microsoft SharePoint
  • Requirements analysis and system architecture software - Unified modeling language UML
  • Spreadsheet software - Microsoft Excel
  • Transaction security and virus protection software - McAfee ; Symantec
  • Transaction server software - Customer information control system CICS
  • Web platform development software - Ruby on Rails
  • Word processing software - Microsoft Word

Tools Used

  • Computer servers - Storage servers
  • Desktop computers
  • High end computer servers - Data warehouse appliances
  • Mainframe computers
  • Notebook computers - Laptop computers
  • Personal computers
  • Special purpose telephones - Multi-line telephone systems

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

  • 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.
  • Systems Analysis - Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
  • Judgment and Decision Making - Considering the relative costs and benefits of potential actions to choose the most appropriate one.
  • Speaking - Talking to others to convey information effectively.
  • Systems Evaluation - Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.
  • Writing - Communicating effectively in writing as appropriate for the needs of the audience.
  • Coordination - Adjusting actions in relation to others' actions.
  • Active Learning - Understanding the implications of new information for both current and future problem-solving and decision-making.
  • Mathematics - Using mathematics to solve problems.
  • Social Perceptiveness - Being aware of others' reactions and understanding why they react as they do.

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.
  • Near Vision - The ability to see details at close range (within a few feet of the observer).
  • Category Flexibility - The ability to generate or use different sets of rules for combining or grouping things in different ways.
  • Oral Expression - The ability to communicate information and ideas in speaking so others will understand.
  • Speech Recognition - The ability to identify and understand the speech of another person.
  • Written Expression - The ability to communicate information and ideas in writing so others will understand.
  • Problem Sensitivity - The ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing there is a problem.
  • Speech Clarity - The ability to speak clearly so others can understand you.
  • Fluency of Ideas - The ability to come up with a number of ideas about a topic (the number of ideas is important, not their quality, correctness, or creativity).
  • Mathematical Reasoning - The ability to choose the right mathematical methods or formulas to solve a problem.
  • Flexibility of Closure - The ability to identify or detect a known pattern (a figure, object, word, or sound) that is hidden in other distracting material.
  • Number Facility - The ability to add, subtract, multiply, or divide quickly and correctly.
  • Originality - The ability to come up with unusual or clever ideas about a given topic or situation, or to develop creative ways to solve a problem.
  • Selective Attention - The ability to concentrate on a task over a period of time without being distracted.

Interests

  • Interest code: IC
    • 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 Context

  • Electronic Mail - 100% responded “Every day.”
  • Spend Time Sitting - 86% 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 - 52% responded “Very important.”
  • Freedom to Make Decisions - 65% responded “Some freedom.”
  • Duration of Typical Work Week - 52% responded “40 hours.”
  • Structured versus Unstructured Work - 57% responded “Some freedom.”
  • Contact With Others - 39% responded “Contact with others most of the time.”
  • Importance of Repeating Same Tasks - 39% responded “Very important.”
  • Time Pressure - 48% responded “Once a month or more but not every week.”
  • Impact of Decisions on Co-workers or Company Results - 48% responded “Important results.”
  • Spend Time Making Repetitive Motions - 26% responded “Continually or almost continually.”
  • Coordinate or Lead Others - 35% responded “Important.”
  • Level of Competition - 43% responded “Moderately competitive.”

Education

Percentage of RespondentsEducation Level Required
78%Bachelor's degree
4%High school diploma or equivalent
4%Post-secondary certificate

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.
  • Dependability - Job requires being reliable, responsible, and dependable, and fulfilling obligations.
  • Adaptability/Flexibility - Job requires being open to change (positive or negative) and to considerable variety in the workplace.
  • Achievement/Effort - Job requires establishing and maintaining personally challenging achievement goals and exerting effort toward mastering tasks.
  • Integrity - Job requires being honest and ethical.
  • Innovation - Job requires creativity and alternative thinking to develop new ideas for and answers to work-related problems.
  • Stress Tolerance - Job requires accepting criticism and dealing calmly and effectively with high stress situations.
  • Independence - Job requires developing one's own ways of doing things, guiding oneself with little or no supervision, and depending on oneself to get things done.
  • Leadership - Job requires a willingness to lead, take charge, and offer opinions and direction.
  • Self Control - Job requires maintaining composure, keeping emotions in check, controlling anger, and avoiding aggressive behavior, even in very difficult situations.

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.

Wages & Trends

  • Median wages (2017)
    • $42.56 hourly, $88,510 annual
  • Employment (2016)
    • 287,000 employees
  • Projected growth (2016-2026)
    • Average (5% to 9%)
  • Projected job openings (2016-2026)
    • 22,400

Similar Job Descriptions: