Job Description Templates
  • Search
  • Menu Menu

Data Warehousing Specialists

CrowdSourceLawyers.com

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 Solution Architect


Tasks  |  Technology Skills  |  Tools Used  |  Knowledge  |  Skills  |  Abilities  |  Work Activities  |  Detailed Work Activities  |  Work Context  |  Job Zone  |  Education  |  Credentials  |  Interests  |  Work Styles  |  Work Values  |  Wages & Employment  |  Job Openings  |  Additional Information


Tasks

Show fewer All 18 displayed
  • Develop data warehouse process models, including sourcing, loading, transformation, and extraction.See more occupations related to this task.
  • Verify the structure, accuracy, or quality of warehouse data.See more occupations related to this task.
  • Map data between source systems, data warehouses, and data marts.See more occupations related to this task.
  • Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.See more occupations related to this task.
  • Design and implement warehouse database structures.See more occupations related to this task.
  • 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.See more occupations related to this task.
  • Provide or coordinate troubleshooting support for data warehouses.See more occupations related to this task.
  • Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.See more occupations related to this task.
  • 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.See more occupations related to this task.
  • Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.See more occupations related to this task.
  • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.See more occupations related to this task.
  • Create or implement metadata processes and frameworks.See more occupations related to this task.
  • Review designs, codes, test plans, or documentation to ensure quality.See more occupations related to this task.
  • Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.See more occupations related to this task.
  • Select methods, techniques, or criteria for data warehousing evaluative procedures.See more occupations related to this task.
  • Implement business rules via stored procedures, middleware, or other technologies.See more occupations related to this task.
  • Prepare functional or technical documentation for data warehouses.See more occupations related to this task.
  • Test software systems or applications for software enhancements or new products.See more occupations related to this task.

Find occupations related to multiple tasks

CrowdSourceLawyers.com

https://crowdsourcelawyers.com/job-description-templates/


Technology Skills

Show fewer All 42 displayed     Show 7 tools used
  • Analytical or scientific software — IBM SPSS Statistics Hot technology ; SAS Hot technology ; StataCorp Stata; The MathWorks MATLAB Hot technologySee more occupations related to this technology.
  • Application server software — Oracle WebLogic Server Hot technologySee more occupations related to this technology.
  • Backup or archival software — Veritas NetBackupSee more occupations related to this technology.
  • Business intelligence and data analysis software — IBM Cognos Impromptu Hot technology ; MicroStrategy Hot technology ; Oracle Business Intelligence Enterprise Edition Hot technology ; Qlik Tech QlikView Hot technology (see all 6 examples)See more occupations related to this technology.
  • Clustering software — Aster Data nClusterSee more occupations related to this technology.
  • Communications server software — IBM DominoSee more occupations related to this technology.
  • Configuration management software — Perforce Helix software; VMWare Hot technologySee more occupations related to this technology.
  • Content workflow software — Atlassian JIRA Hot technologySee more occupations related to this technology.
  • Customer relationship management CRM software — Blackbaud The Raiser’s EdgeSee more occupations related to this technology.
  • Data base management system software — Amazon DynamoDB Hot technology ; Apache Solr Hot technology ; MongoDB Hot technology ; Oracle PL/SQL Hot technology (see all 24 examples)See more occupations related to this technology.
  • Data base reporting software — IBM Netezza TwinFin; Microsoft SQL Server Reporting Services Hot technology ; Oracle Business Intelligence Discoverer; SAP Crystal Reports Hot technology (see all 5 examples)See more occupations related to this technology.
  • Data base user interface and query software — Amazon Elastic Compute Cloud EC2 Hot technology ; Apache Hive Hot technology ; MySQL Hot technology ; Transact-SQL Hot technology (see all 13 examples)See more occupations related to this technology.
  • Data mining software — Rapid-I RapidMiner; SAP NetWeaver Business Warehouse; Teradata Parallel Transporter; Teradata Tpump (see all 5 examples)See more occupations related to this technology.
  • Desktop publishing software — Microsoft PublisherSee more occupations related to this technology.
  • Development environment software — Apache Kafka Hot technology ; Common business oriented language COBOL Hot technology ; Integrated development environment IDE software Hot technology ; Microsoft .NET Framework Hot technology (see all 12 examples)See more occupations related to this technology.
  • Document management software — Teradata FastExportSee more occupations related to this technology.
  • Electronic mail software — Microsoft Outlook Hot technologySee more occupations related to this technology.
  • Enterprise application integration software — Extensible markup language XML Hot technology ; IBM InfoSphere DataStage; IBM WebSphere Hot technology ; Microsoft SQL Server Integration Services SSIS Hot technology (see all 7 examples)See more occupations related to this technology.
  • Enterprise resource planning ERP software Hot technology — NetSuite ERP Hot technology ; Oracle Hyperion Hot technology ; Oracle JD Edwards EnterpriseOne Hot technology ; Oracle PeopleSoft Hot technology (see all 9 examples)See more occupations related to this technology.
  • Enterprise system management software — Splunk Enterprise Hot technologySee more occupations related to this technology.
  • File versioning software — Apache Subversion SVN Hot technologySee more occupations related to this technology.
  • Financial analysis software — Oracle E-Business Suite FinancialsSee more occupations related to this technology.
  • Graphics or photo imaging software — Microsoft Visio Hot technologySee more occupations related to this technology.
  • Human resources software — Human resource management software HRMSSee more occupations related to this technology.
  • Information retrieval or search software — Apache AvroSee more occupations related to this technology.
  • Map creation software — ESRI ArcGIS software Hot technologySee more occupations related to this technology.
  • Metadata management software — CA Erwin Data Modeler; Oracle Warehouse Builder; SAS Data Integration Server; Talend Data Fabric (see all 16 examples)See more occupations related to this technology.
  • Network monitoring software — Nagios Hot technologySee more occupations related to this technology.
  • Object or component oriented development software — Advanced business application programming ABAP Hot technology ; Apache Spark Hot technology ; Objective C Hot technology ; Scala Hot technology (see all 10 examples)See more occupations related to this technology.
  • Object oriented data base management software — PostgreSQL Hot technologySee more occupations related to this technology.
  • Office suite software — Microsoft Office Hot technologySee more occupations related to this technology.
  • Operating system software — Bash Hot technology ; Oracle Solaris Hot technology ; Red Hat Enterprise Linux Hot technology ; UNIX Shell Hot technology (see all 13 examples)See more occupations related to this technology.
  • Portal server software — Apache HTTP Server Hot technologySee more occupations related to this technology.
  • Presentation software — Microsoft PowerPoint Hot technologySee more occupations related to this technology.
  • Project management software — Microsoft Project Hot technology ; Microsoft SharePoint Hot technologySee more occupations related to this technology.
  • Requirements analysis and system architecture software — Unified modeling language UML Hot technologySee more occupations related to this technology.
  • Spreadsheet software — Microsoft Excel Hot technologySee more occupations related to this technology.
  • Storage networking software — Amazon Simple Storage Service S3 Hot technologySee more occupations related to this technology.
  • Transaction security and virus protection software — McAfee; Symantec Hot technologySee more occupations related to this technology.
  • Transaction server software — Customer information control system CICSSee more occupations related to this technology.
  • Web platform development software — Ruby on Rails Hot technologySee more occupations related to this technology.
  • Word processing software — Microsoft Word Hot technologySee more occupations related to this technology.

Hot technology Hot Technology — a technology requirement frequently included in employer job postings.

back to top

CrowdSourceLawyers.com

https://crowdsourcelawyers.com/job-description-templates/


Knowledge

Show fewer All 4 displayed
  • Computers and Electronics — Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.See more occupations related to this knowledge.
  • Mathematics — Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.See more occupations related to this knowledge.
  • English Language — Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.See more occupations related to this knowledge.
  • Design — Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models.See more occupations related to this knowledge.

back to top

CrowdSourceLawyers.com

https://crowdsourcelawyers.com/job-description-templates/


Skills

Show fewer All 14 displayed
  • Critical Thinking — Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.See more occupations related to this skill.
  • Reading Comprehension — Understanding written sentences and paragraphs in work related documents.See more occupations related to this skill.
  • Programming — Writing computer programs for various purposes.See more occupations related to this skill.
  • Complex Problem Solving — Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.See more occupations related to this skill.
  • 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.See more occupations related to this skill.
  • Systems Analysis — Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.See more occupations related to this skill.
  • Judgment and Decision Making — Considering the relative costs and benefits of potential actions to choose the most appropriate one.See more occupations related to this skill.
  • Speaking — Talking to others to convey information effectively.See more occupations related to this skill.
  • 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.See more occupations related to this skill.
  • Writing — Communicating effectively in writing as appropriate for the needs of the audience.See more occupations related to this skill.
  • Coordination — Adjusting actions in relation to others’ actions.See more occupations related to this skill.
  • Active Learning — Understanding the implications of new information for both current and future problem-solving and decision-making.See more occupations related to this skill.
  • Mathematics — Using mathematics to solve problems.See more occupations related to this skill.
  • Social Perceptiveness — Being aware of others’ reactions and understanding why they react as they do.See more occupations related to this skill.

back to top

Abilities

Show fewer All 18 displayed
  • 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).See more occupations related to this ability.
  • Written Comprehension — The ability to read and understand information and ideas presented in writing.See more occupations related to this ability.
  • Deductive Reasoning — The ability to apply general rules to specific problems to produce answers that make sense.See more occupations related to this ability.
  • Inductive Reasoning — The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).See more occupations related to this ability.
  • Oral Comprehension — The ability to listen to and understand information and ideas presented through spoken words and sentences.See more occupations related to this ability.
  • Near Vision — The ability to see details at close range (within a few feet of the observer).See more occupations related to this ability.
  • Category Flexibility — The ability to generate or use different sets of rules for combining or grouping things in different ways.See more occupations related to this ability.
  • Oral Expression — The ability to communicate information and ideas in speaking so others will understand.See more occupations related to this ability.
  • Speech Recognition — The ability to identify and understand the speech of another person.See more occupations related to this ability.
  • Written Expression — The ability to communicate information and ideas in writing so others will understand.See more occupations related to this ability.
  • 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.See more occupations related to this ability.
  • Speech Clarity — The ability to speak clearly so others can understand you.See more occupations related to this ability.
  • 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).See more occupations related to this ability.
  • Mathematical Reasoning — The ability to choose the right mathematical methods or formulas to solve a problem.See more occupations related to this ability.
  • 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.See more occupations related to this ability.
  • Number Facility — The ability to add, subtract, multiply, or divide quickly and correctly.See more occupations related to this ability.
  • 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.See more occupations related to this ability.
  • Selective Attention — The ability to concentrate on a task over a period of time without being distracted.See more occupations related to this ability.

back to top

Work Activities

Show fewer All 18 displayed
  • Interacting With Computers — Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.See more occupations related to this activity.
  • Analyzing Data or Information — Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.See more occupations related to this activity.
  • Processing Information — Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.See more occupations related to this activity.
  • Getting Information — Observing, receiving, and otherwise obtaining information from all relevant sources.See more occupations related to this activity.
  • Updating and Using Relevant Knowledge — Keeping up-to-date technically and applying new knowledge to your job.See more occupations related to this activity.
  • Identifying Objects, Actions, and Events — Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.See more occupations related to this activity.
  • Making Decisions and Solving Problems — Analyzing information and evaluating results to choose the best solution and solve problems.See more occupations related to this activity.
  • Thinking Creatively — Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.See more occupations related to this activity.
  • Communicating with Supervisors, Peers, or Subordinates — Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.See more occupations related to this activity.
  • Interpreting the Meaning of Information for Others — Translating or explaining what information means and how it can be used.See more occupations related to this activity.
  • Organizing, Planning, and Prioritizing Work — Developing specific goals and plans to prioritize, organize, and accomplish your work.See more occupations related to this activity.
  • Establishing and Maintaining Interpersonal Relationships — Developing constructive and cooperative working relationships with others, and maintaining them over time.See more occupations related to this activity.
  • Provide Consultation and Advice to Others — Providing guidance and expert advice to management or other groups on technical, systems-, or process-related topics.See more occupations related to this activity.
  • Evaluating Information to Determine Compliance with Standards — Using relevant information and individual judgment to determine whether events or processes comply with laws, regulations, or standards.See more occupations related to this activity.
  • Developing Objectives and Strategies — Establishing long-range objectives and specifying the strategies and actions to achieve them.See more occupations related to this activity.
  • Developing and Building Teams — Encouraging and building mutual trust, respect, and cooperation among team members.See more occupations related to this activity.
  • Documenting/Recording Information — Entering, transcribing, recording, storing, or maintaining information in written or electronic/magnetic form.See more occupations related to this activity.
  • Scheduling Work and Activities — Scheduling events, programs, and activities, as well as the work of others.See more occupations related to this activity.

back to top

Detailed Work Activities

Show fewer All 15 displayed
  • Develop models of information or communications systems.See more occupations related to this activity.
  • Evaluate data quality.See more occupations related to this activity.
  • Develop diagrams or flow charts of system operation.See more occupations related to this activity.
  • Develop procedures for data management.See more occupations related to this activity.
  • Create databases to store electronic data.See more occupations related to this activity.
  • Design software applications.See more occupations related to this activity.
  • Write computer programming code.See more occupations related to this activity.
  • Modify software programs to improve performance.See more occupations related to this activity.
  • Troubleshoot issues with computer applications or systems.See more occupations related to this activity.
  • Analyze data to identify trends or relationships among variables.See more occupations related to this activity.
  • Document operational procedures.See more occupations related to this activity.
  • Evaluate project designs to determine adequacy or feasibility.See more occupations related to this activity.
  • Develop performance metrics or standards related to information technology.See more occupations related to this activity.
  • Develop testing routines or procedures.See more occupations related to this activity.
  • Test software performance.See more occupations related to this activity.

Find occupations related to multiple detailed work activities

back to top

Work Context

Show fewer All 17 displayed
  • Electronic Mail — 100% responded “Every day.”See more occupations related to this work context.
  • Spend Time Sitting — 86% responded “Continually or almost continually.”See more occupations related to this work context.
  • Indoors, Environmentally Controlled — 96% responded “Every day.”See more occupations related to this work context.
  • Face-to-Face Discussions — 55% responded “Every day.”See more occupations related to this work context.
  • Importance of Being Exact or Accurate — 57% responded “Extremely important.”See more occupations related to this work context.
  • Telephone — 50% responded “Every day.”See more occupations related to this work context.
  • Work With Work Group or Team — 52% responded “Very important.”See more occupations related to this work context.
  • Freedom to Make Decisions — 65% responded “Some freedom.”See more occupations related to this work context.
  • Duration of Typical Work Week — 52% responded “40 hours.”See more occupations related to this work context.
  • Structured versus Unstructured Work — 57% responded “Some freedom.”See more occupations related to this work context.
  • Contact With Others — 39% responded “Contact with others most of the time.”See more occupations related to this work context.
  • Importance of Repeating Same Tasks — 39% responded “Very important.”See more occupations related to this work context.
  • Time Pressure — 48% responded “Once a month or more but not every week.”See more occupations related to this work context.
  • Impact of Decisions on Co-workers or Company Results — 48% responded “Important results.”See more occupations related to this work context.
  • Spend Time Making Repetitive Motions — 26% responded “Continually or almost continually.”See more occupations related to this work context.
  • Coordinate or Lead Others — 35% responded “Important.”See more occupations related to this work context.
  • Level of Competition — 43% responded “Moderately competitive.”See more occupations related to this work context.

back to top

Job Zone

Title Job Zone Four: Considerable Preparation Needed
Education Most of these occupations require a four-year bachelor’s degree, but some do not.
Related 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.
Job Training Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.
Job Zone Examples Many of these occupations involve coordinating, supervising, managing, or training others. Examples include real estate brokers, sales managers, database administrators, graphic designers, chemists, art directors, and cost estimators.
SVP Range (7.0 to < 8.0)

back to top

Education


Percentage of Respondents
Education Level Required
78   Bachelor’s degree
4   High school diploma or equivalent

Help
4   Post-secondary certificate

Help

back to top

Credentials

Find Training Find Certifications Apprenticeship.gov

back to top

Interests

Show fewer All 2 displayed

Interest code: IC   Want to discover your interests? Take the O*NET Interest Profiler at My Next Move.

  • 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.See more occupations related to this interest.
  • 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.See more occupations related to this interest.

back to top

Work Styles

Show fewer All 14 displayed
  • Analytical Thinking — Job requires analyzing information and using logic to address work-related issues and problems.See more occupations related to this work style.
  • Attention to Detail — Job requires being careful about detail and thorough in completing work tasks.See more occupations related to this work style.
  • Initiative — Job requires a willingness to take on responsibilities and challenges.See more occupations related to this work style.
  • Persistence — Job requires persistence in the face of obstacles.See more occupations related to this work style.
  • Cooperation — Job requires being pleasant with others on the job and displaying a good-natured, cooperative attitude.See more occupations related to this work style.
  • Dependability — Job requires being reliable, responsible, and dependable, and fulfilling obligations.See more occupations related to this work style.
  • Adaptability/Flexibility — Job requires being open to change (positive or negative) and to considerable variety in the workplace.See more occupations related to this work style.
  • Achievement/Effort — Job requires establishing and maintaining personally challenging achievement goals and exerting effort toward mastering tasks.See more occupations related to this work style.
  • Integrity — Job requires being honest and ethical.See more occupations related to this work style.
  • Innovation — Job requires creativity and alternative thinking to develop new ideas for and answers to work-related problems.See more occupations related to this work style.
  • Stress Tolerance — Job requires accepting criticism and dealing calmly and effectively with high stress situations.See more occupations related to this work style.
  • 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.See more occupations related to this work style.
  • Leadership — Job requires a willingness to lead, take charge, and offer opinions and direction.See more occupations related to this work style.
  • Self Control — Job requires maintaining composure, keeping emotions in check, controlling anger, and avoiding aggressive behavior, even in very difficult situations.See more occupations related to this work style.

back to top

Work Values

Show fewer All 3 displayed
  • 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.See more occupations related to this work value.
  • 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.See more occupations related to this work value.
  • Independence — Occupations that satisfy this work value allow employees to work on their own and make decisions. Corresponding needs are Creativity, Responsibility and Autonomy.See more occupations related to this work value.

back to top

Wages & Employment Trends

Median wage data for Database Administrators and Architects.
Employment data for Database Administrators and Architects.
Industry data for Database Administrators and Architects.

Median wages (2020) $47.53 hourly, $98,860 annual
State wages
 
Local wages
  
Employment (2020) 168,000 employees
Projected growth (2020-2030) Average (5% to 10%) Average (5% to 10%)
Projected job openings (2020-2030) 13,900
State trends
 
Top industries (2020)
Professional, Scientific, and Technical Services
Finance and Insurance

This page includes information from O*NET OnLine by the U.S. Department of Labor, Employment and Training Administration (USDOL/ETA). Used under the CC BY 4.0 license. O*NET® is a trademark of USDOL/ETA.

© Copyright | CrowdSourceLawyers
Scroll to top