Experience Requirements Overview

  • Job Zone Four: Considerable Preparation Needed
  • 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.
  • Most of these occupations require a four-year bachelor's degree, but some do not.
  • Employees in these occupations usually need several years of work-related experience, on-the-job training, and/or vocational training.

Education, Training and Experience

Required Level of Education: Bachelor's Degree

Related Work Experience: Over 2 years, up to and including 4 years

On-Site or In-Plant Training: N.A.

On-the-Job Training: Over 1 month, up to and including 3 months

Detailed Work Activities

  • Develop diagrams or flow charts of system operation.
  • 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.
  • Write computer programming code.
  • Evaluate data quality.
  • Develop performance metrics or standards related to information technology.
  • Analyze data to identify trends or relationships among variables.
  • Develop procedures for data management.
  • Create databases to store electronic data.
  • Develop testing routines or procedures.
  • Develop models of information or communications systems.

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.

Recognition

Occupations that satisfy this work value offer advancement, potential for leadership, and are often considered prestigious. Corresponding needs are Advancement, Authority, Recognition and Social Status.

Relationships

Occupations that satisfy this work value allow employees to provide service to others and work with co-workers in a friendly non-competitive environment. Corresponding needs are Co-workers, Moral Values and Social Service.

Support

Occupations that satisfy this work value offer supportive management that stands behind employees. Corresponding needs are Company Policies, Supervision: Human Relations and Supervision: Technical.

Independence

Occupations that satisfy this work value allow employees to work on their own and make decisions. Corresponding needs are Creativity, Responsibility and Autonomy.

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.

Work Styles

Leadership

Job requires a willingness to lead, take charge, and offer opinions and direction.

Achievement/Effort

Job requires establishing and maintaining personally challenging achievement goals and exerting effort toward mastering tasks.

Persistence

Job requires persistence in the face of obstacles.

Initiative

Job requires a willingness to take on responsibilities and challenges.

Cooperation

Job requires being pleasant with others on the job and displaying a good-natured, cooperative attitude.

Concern for Others

Job requires being sensitive to others' needs and feelings and being understanding and helpful on the job.

Social Orientation

Job requires preferring to work with others rather than alone, and being personally connected with others on the job.

Self-Control

Job requires maintaining composure, keeping emotions in check, controlling anger, and avoiding aggressive behavior, even in very difficult situations.

Stress Tolerance

Job requires accepting criticism and dealing calmly and effectively with high-stress situations.

Adaptability/Flexibility

Job requires being open to change (positive or negative) and to considerable variety in the workplace.

Dependability

Job requires being reliable, responsible, and dependable, and fulfilling obligations.

Attention to Detail

Job requires being careful about detail and thorough in completing work tasks.

Integrity

Job requires being honest and ethical.

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.

Innovation

Job requires creativity and alternative thinking to develop new ideas for and answers to work-related problems.

Analytical Thinking

Job requires analyzing information and using logic to address work-related issues and problems.

Data Source: This page includes information from the O*NET 28.0 Database 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. This page includes Employment Projections program, Occupational Employment and Wage Statistics program, U.S. Bureau of Labor Statistics.