Data Warehousing Specialists

Personality

Job Aptitudes

Who's Hiring

Does this career fit your work personality?

Begin The Career Assessment Test

Get Your FIT Score for this career.

FIT Score

Discover your work personality strengths.

This is a Premium Feature X Find your

Best Fitting Careers
Work Personality Strengths
Work Style Preferences
and more

Begin Career Test

Job Outlook:

None

Education: Bachelor's degree Details

Education Details

78%

Bachelor's Degree

High School Diploma - or the equivalent (for example, GED)

Post-Secondary Certificate - awarded for training completed after high school (for example, in agriculture or natural resources, computer services, personal or culinary services, engineering technologies, healthcare, construction trades, mechanic and repair technologies, or precision production)

Some College Courses

Associate's Degree (or other 2-year degree)

Master's Degree

Salary

High: $197,350.00

Average: $136,540.00

Hourly

Average: $65.65

Summary of What they do:

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

Responsibilities

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.

Design software applications.

Write computer programming code.

Develop diagrams or flow charts of system operation.

Develop procedures for data management.

Create databases to store electronic data.

Develop diagrams or flow charts of system operation.

Document operational procedures.

Develop testing routines or procedures.

Develop models of information or communications systems.

Develop procedures for data management.

Tasks On The Job

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

PERSONALITY

KEY:

Strength

Caution

Warning

Your Assessment Results		CAREER CHARACTERISTICS Importance


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

Your Assessment Results		IMPORTANT STRENGTHS Importance


? ? ? ? Begin Career Assessment		78%	Investigative - Work involves studying and researching non-living objects, living organisms, disease or other forms of impairment, or human behavior. Investigative occupations are often associated with physical, life, medical, or social sciences, and can be found in the fields of humanities, mathematics/statistics, information technology, or health care service.
? ? ? ? Begin Career Assessment		61%	Conventional - Work involves following procedures and regulations to organize information or data, typically in a business setting. Conventional occupations are often associated with office work, accounting, mathematics/statistics, information technology, finance, or human resources.

Your Assessment Results		WORK VALUES Importance


? ? ? ? Begin Career Assessment	83%	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.
? ? ? ? Begin Career Assessment	72%	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.
? ? ? ? Begin Career Assessment	67%	Independence - Occupations that satisfy this work value allow employees to work on their own and make decisions. Corresponding needs are Creativity, Responsibility and Autonomy.

APTITUDES

KEY:

Strength

Caution

Warning

Your Assessment Results		ABILITIES \| SKILLS Importance


? ? ? ? Begin Career Assessment	72%	Written Comprehension - The ability to read and understand information and ideas presented in writing.
? ? ? ? Begin Career Assessment	72%	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).
? ? ? ? Begin Career Assessment	69%	Oral Comprehension - The ability to listen to and understand information and ideas presented through spoken words and sentences.
? ? ? ? Begin Career Assessment	69%	Deductive Reasoning - The ability to apply general rules to specific problems to produce answers that make sense.
? ? ? ? Begin Career Assessment	69%	Inductive Reasoning - The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
? ? ? ? Begin Career Assessment	66%	Near Vision - The ability to see details at close range (within a few feet of the observer).
? ? ? ? Begin Career Assessment	63%	Oral Expression - The ability to communicate information and ideas in speaking so others will understand.
? ? ? ? Begin Career Assessment	63%	Written Expression - The ability to communicate information and ideas in writing so others will understand.
? ? ? ? Begin Career Assessment	63%	Category Flexibility - The ability to generate or use different sets of rules for combining or grouping things in different ways.
? ? ? ? Begin Career Assessment	63%	Speech Recognition - The ability to identify and understand the speech of another person.
? ? ? ? Begin Career Assessment	60%	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 that there is a problem.
? ? ? ? Begin Career Assessment	60%	Speech Clarity - The ability to speak clearly so others can understand you.
? ? ? ? Begin Career Assessment	57%	Reading Comprehension - Understanding written sentences and paragraphs in work-related documents.
? ? ? ? Begin Career Assessment	55%	Critical Thinking - Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
? ? ? ? Begin Career Assessment	54%	Programming - Writing computer programs for various purposes.
? ? ? ? Begin Career Assessment	53%	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).
? ? ? ? Begin Career Assessment	53%	Mathematical Reasoning - The ability to choose the right mathematical methods or formulas to solve a problem.
? ? ? ? Begin Career Assessment	52%	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.
? ? ? ? Begin Career Assessment	52%	Speaking - Talking to others to convey information effectively.
? ? ? ? Begin Career Assessment	52%	Judgment and Decision Making - Considering the relative costs and benefits of potential actions to choose the most appropriate one.

Your Assessment Results		TASKS \| ACTIVITIES Importance


? ? ? ? Begin Career Assessment	99%	Working with Computers - Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
? ? ? ? Begin Career Assessment	89%	Analyzing Data or Information - Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
? ? ? ? Begin Career Assessment	87%	Processing Information - Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
? ? ? ? Begin Career Assessment	86%	Getting Information - Observing, receiving, and otherwise obtaining information from all relevant sources.
? ? ? ? Begin Career Assessment	81%	Updating and Using Relevant Knowledge - Keeping up-to-date technically and applying new knowledge to your job.
? ? ? ? Begin Career Assessment	76%	Identifying Objects, Actions, and Events - Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.
? ? ? ? Begin Career Assessment	74%	Thinking Creatively - Developing, designing, or creating new applications, ideas, relationships, systems, or products, including artistic contributions.
? ? ? ? Begin Career Assessment	74%	Making Decisions and Solving Problems - Analyzing information and evaluating results to choose the best solution and solve problems.
? ? ? ? Begin Career Assessment	73%	Communicating with Supervisors, Peers, or Subordinates - Providing information to supervisors, co-workers, and subordinates by telephone, in written form, e-mail, or in person.
? ? ? ? Begin Career Assessment	69%	Interpreting the Meaning of Information for Others - Translating or explaining what information means and how it can be used.
? ? ? ? Begin Career Assessment	68%	Organizing, Planning, and Prioritizing Work - Developing specific goals and plans to prioritize, organize, and accomplish your work.
? ? ? ? Begin Career Assessment	63%	Establishing and Maintaining Interpersonal Relationships - Developing constructive and cooperative working relationships with others, and maintaining them over time.
? ? ? ? Begin Career Assessment	61%	Providing Consultation and Advice to Others - Providing guidance and expert advice to management or other groups on technical, systems-, or process-related topics.
? ? ? ? Begin Career Assessment	59%	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.
? ? ? ? Begin Career Assessment	57%	Developing Objectives and Strategies - Establishing long-range objectives and specifying the strategies and actions to achieve them.
? ? ? ? Begin Career Assessment	53%	Developing and Building Teams - Encouraging and building mutual trust, respect, and cooperation among team members.

Your Assessment Results		CONTEXT \| ATTRIBUTES Importance


? ? ? ? Begin Career Assessment	100%	Electronic Mail - How often do you use electronic mail in this job?
? ? ? ? Begin Career Assessment	97%	Spend Time Sitting - How much does this job require sitting?
? ? ? ? Begin Career Assessment	96%	Indoors, Environmentally Controlled - How often does this job require working indoors in environmentally controlled conditions?
? ? ? ? Begin Career Assessment	86%	Face-to-Face Discussions - How often do you have to have face-to-face discussions with individuals or teams in this job?
? ? ? ? Begin Career Assessment	86%	Importance of Being Exact or Accurate - How important is being very exact or highly accurate in performing this job?
? ? ? ? Begin Career Assessment	83%	Telephone - How often do you have telephone conversations in this job?
? ? ? ? Begin Career Assessment	83%	Work With Work Group or Team - How important is it to work with others in a group or team in this job?
? ? ? ? Begin Career Assessment	77%	Freedom to Make Decisions - How much decision making freedom, without supervision, does the job offer?
? ? ? ? Begin Career Assessment	73%	Structured versus Unstructured Work - To what extent is this job structured for the worker, rather than allowing the worker to determine tasks, priorities, and goals?
? ? ? ? Begin Career Assessment	61%	Contact With Others - How much does this job require the worker to be in contact with others (face-to-face, by telephone, or otherwise) in order to perform it?
? ? ? ? Begin Career Assessment	60%	Importance of Repeating Same Tasks - How important is repeating the same physical activities (e.g., key entry) or mental activities (e.g., checking entries in a ledger) over and over, without stopping, to performing this job?
? ? ? ? Begin Career Assessment	58%	Time Pressure - How often does this job require the worker to meet strict deadlines?
? ? ? ? Begin Career Assessment	57%	Impact of Decisions on Co-workers or Company Results - What results do your decisions usually have on other people or the image or reputation or financial resources of your employer?
? ? ? ? Begin Career Assessment	52%	Spend Time Making Repetitive Motions - How much does this job require making repetitive motions?
? ? ? ? Begin Career Assessment	51%	Coordinate or Lead Others - How important is it to coordinate or lead others in accomplishing work activities in this job?
? ? ? ? Begin Career Assessment	74%	Duration of Typical Work Week - Number of hours typically worked in one week.