Occupation Details
Data Warehousing Specialists
Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.
Quick Navigation
Interests
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 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.
Salary & Job Outlook
Starting Salary
$84,580.00
New York StateMedian Salary
$134,740.00
New York StateExperienced Salary
$165,230.00
New York StateNational Average for Comparison
New York State Job Market Outlook
Jobs Right Now (2018)
291,900
professionals in NYFuture Job Growth (2030)
359,610
+6,771 jobs/yearNew Jobs Every Year
29,521
new opportunities yearlyGrowth Rate
0.2%
projected increasePreparation: Experience, Training, and Education
The list below outlines the prior educational experience required to perform in this occupation.
Degree Needed - Four-year college
Experience Requirements
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.
Education Requirements
Most of these occupations require a four-year bachelor's degree, but some do not.
Training Details
Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.
Transferrable Skills and Experience
Many of these occupations involve coordinating, supervising, managing, or training others. Examples include real estate brokers, sales managers, database administrators, graphic designers, conservation scientists, art directors, and cost estimators.
School Programs
The following lists school programs which are applicable to this occupation.
Licensing & Certification
State License and Certifications Requirements are not currently associated with this occupation.
Skills
The list below includes the skills required by workers in this occupation; skills are what allow you to learn more quickly and improve your performance.
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.
Skill level is measured on a seven point scale, where one means 'some competence required for this occupation' and seven means 'a high level of expertise required for this occupation'.
Knowledge
The list below includes knowledge items, the principles and facts required by this occupation.
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.
Engineering and Technology
Knowledge of the practical application of engineering science and technology. This includes applying principles, techniques, procedures, and equipment to the design and production of various goods and services.
Administration and Management
Knowledge of business and management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, production methods, and coordination of people and resources.
Knowledge level is measured on a seven point scale, where one means 'some competence required for this occupation' and seven means 'a high level of expertise required for this occupation'.
Work Environment
The list below includes the physical and social factors that influence the nature of work in this occupation.
Hover over or tap each factor to see its description.
Work Styles
Included in the list below are the personal work style characteristics that can affect how well a worker is likely to perform in this occupation.
Achievement/Effort
Job requires establishing and maintaining personally challenging achievement goals and exerting effort toward mastering tasks.
Adaptability/Flexibility
Job requires being open to change (positive or negative) and to considerable variety in the workplace.
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.
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.
Initiative
Job requires a willingness to take on responsibilities and challenges.
Innovation
Job requires creativity and alternative thinking to develop new ideas for and answers to work-related problems.
Integrity
Job requires being honest and ethical.
Persistence
Job requires persistence in the face of obstacles.
Tools & Technology
This list below describes the machines, equipment, tools, software, and information technology that workers in this occupation will use.
Tools
- Computer servers
- Data warehouse appliances
- Desktop computers
- Laptop computers
- Mainframe computers
- Multi-line telephone systems
- Personal computers
Technology
- Adaptive Metadata Manager
- Adeptia ETL Suite
- Advanced business application programming ABAP
- Altova MapForce
- Amazon DynamoDB
- Amazon Redshift
- Amazon Simple Storage Service S3
- Amazon Web Services AWS software
- Apache Avro
- Apache HBase
- Apache HTTP Server
- Apache Hadoop
- Apache Hive
- Apache Kafka
- Apache Solr
- Apache Spark
Duties
Job duties information is not available for this occupation.
Tasks
The list below outlines specific tasks that a worker in this occupation is called upon to do regularly.
- Verify the structure, accuracy, or quality of warehouse data.
- Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
- 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.