Typical Tasks
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.
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.
A day in the life
What kind of work is this?
Conventional
Organized, Procedural Work
Investigative
Studying, Research based work
Enterprising
Business based Work
What personality traits do you need to succeed?
Analytical Thinking
Attention to Detail
Initiative
Persistence
Cooperation
Dependability
What key skills are needed for this job?
Reading Comprehension
Critical Thinking
Programming
Complex Problem Solving
Active Listening
Systems Analysis
Expected 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.
Common Activities
Working with Computers
Using computers and computer systems (including hardware and software) to program, write software, set up functions, enter data, or process information.
Analyzing Data or Information
Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
Processing Information
Compiling, coding, categorizing, calculating, tabulating, auditing, or verifying information or data.
