Performs technical administration duties for the development and maintenance of data warehouses.
Provides technical support and coordination during warehouse design, testing and movement to production. Acts as a liaison between engineers, data architects, programmers, and analysts. Implements and enforces standards and procedures to ensure data is managed consistently and properly integrated within the warehouse. Manipulates and combines data from various sources to enlarge and enhance the data warehouse.
Salary.com identifies five increasing levels of proficiency for each skill/competency. Some jobs require only a relatively low level of proficiency in each skill/competency, while other jobs will require a more advanced level of proficiency in the same skill/competency. These levels rate the degree of proficiency (skill level, expertise) we expect the incumbent to perform in the given skill/competency for the given job. Note that we intentionally do not associate timeframes or years of experience in performing the skill/competency because that can be misleading. Proficiency levels identify what the incumbent knows and can do rather than how long they have been doing it. Also, note that the proficiency levels are cumulative, e.g., a level 4 proficiency implies the ability to perform all the behaviors at the lower levels.
Check each Data Warehouse Administrator, Senior skill and competencie below to view definitions.
Skill definition-Evaluating business data, translating it to actionable insights, and using it to make better-informed decisions.
Level 1 Behaviors
(General Familiarity)
Describes the basic terminologies used in business intelligence and business analytics processes.
Level 2 Behaviors
(Light Experience)
Assists in preparing insights for business performance by using business intelligence tools.
Level 3 Behaviors
(Moderate Experience)
Implements the integration of proprietary business intelligence applications within the department.
Level 4 Behaviors
(Extensive Experience)
Directs the development of a business intelligence platform to report end-user data mining.
Level 5 Behaviors
(Mastery)
Creates business intelligence reviews and strategies to interpret short-term and long-range forecasts.
Skill definition-Creating a visual representation of an information system to illustrate the relationships among data types.
Level 1 Behaviors
(General Familiarity)
Discusses the best practices and benefits of data modeling.
Level 2 Behaviors
(Light Experience)
Conducts data manipulation and modeling to improve operational efficiencies of the business.
Level 3 Behaviors
(Moderate Experience)
Implements data modeling to create a visual representation of the information system.
Level 4 Behaviors
(Extensive Experience)
Designs data modeling frameworks to dive deep into sources of information and data value.
Level 5 Behaviors
(Mastery)
Explores the latest technological advances to help accelerate the data modeling capabilities.
Skill definition-Executing and completing a task with a high level of accuracy.
Level 1 Behaviors
(General Familiarity)
Explains why attention to detail plays an important role in own function or unit.
Level 2 Behaviors
(Light Experience)
Performs assigned responsibilities according to standard procedures and standards.
Level 3 Behaviors
(Moderate Experience)
Processes large quantities of detailed information with high levels of accuracy.
Level 4 Behaviors
(Extensive Experience)
Demonstrates expertise in quality assurance tools, techniques, and standards.
Level 5 Behaviors
(Mastery)
Designs techniques for measuring the cost and impact of errors.
Skill definition-Managing and setting priorities, goals, and timetables to boost productivity and efficiency in completing tasks.
Level 1 Behaviors
(General Familiarity)
Describes how to utilize a time management matrix for efficient completion of most important tasks.
Level 2 Behaviors
(Light Experience)
Classifies assigned tasks into specific, smaller, and more achievable goals.
Level 3 Behaviors
(Moderate Experience)
Demonstrates a willingness to abandon tasks or projects that prove to be of little value to the business.
Level 4 Behaviors
(Extensive Experience)
Develops best techniques and methods to improve time management throughout our business.
Level 5 Behaviors
(Mastery)
Designs tools to efficiently organize and keep track of tasks in progress to boost productivity.
There are 0 hard skills for Data Warehouse Administrator, Senior.
12 general skills for Data Warehouse Administrator, Senior, Business Intelligence, Data Modeling, Technical Troubleshooting, etc.
7 soft skills for Data Warehouse Administrator, Senior, Attention to Detail, Time Management, Problem Solving, etc.
While the list totals 19 distinct skills, it's important to note that not all are required to be mastered to the same degree. Some skills may only need a basic understanding, whereas others demand a higher level of expertise.
For instance, as a Data Warehouse Administrator, Senior, he or she needs to be skilled in Attention to Detail, be skilled in Time Management, and be proficient in Problem Solving.