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)
Lists the basic features of general business intelligence systems and database structure.
Level 2 Behaviors
(Light Experience)
Supports end-users in using business intelligence tools to query databases for outputs and data preparation.
Level 3 Behaviors
(Moderate Experience)
Utilizes business intelligence platforms to derive insights to present the data to our business.
Level 4 Behaviors
(Extensive Experience)
Provides technical oversight and design to support the development of business intelligence solutions.
Level 5 Behaviors
(Mastery)
Leads the development of visual business intelligence models to utilize business intelligence tools.
Skill definition-Creating a visual representation of an information system to illustrate the relationships among data types.
Level 1 Behaviors
(General Familiarity)
Lists major types of data modeling and illustrates the differences among them.
Level 2 Behaviors
(Light Experience)
Supports modeling of data warehouse programs to moderate complexity based on the business' needs.
Level 3 Behaviors
(Moderate Experience)
Works directly with senior leadership to turn insights into actions in data modeling.
Level 4 Behaviors
(Extensive Experience)
Leverages data modeling methods to promote efficient database and data storage solutions.
Level 5 Behaviors
(Mastery)
Stays current with complex data trends and data modeling to develop driven improvement solutions.
Skill definition-Executing and completing a task with a high level of accuracy.
Level 1 Behaviors
(General Familiarity)
Lists the traits of an employee showing great attention to detail.
Level 2 Behaviors
(Light Experience)
Utilizes specific approaches and tools for checking and cross-checking outputs.
Level 3 Behaviors
(Moderate Experience)
Uses tools to organize and monitor work progress.
Level 4 Behaviors
(Extensive Experience)
Manages training to improve staffs' concentration and attention to detail.
Level 5 Behaviors
(Mastery)
Learns from previous works' strengths and weaknesses to guide new projects.
Skill definition-Managing and setting priorities, goals, and timetables to boost productivity and efficiency in completing tasks.
Level 1 Behaviors
(General Familiarity)
Lists basic planning tools and applications used in tracking and organizing time and tasks visually.
Level 2 Behaviors
(Light Experience)
Seeks all resources needed to accomplish a task efficiently and effectively.
Level 3 Behaviors
(Moderate Experience)
Works closely with colleagues to identify and reduce interruptions and barriers to time utilization.
Level 4 Behaviors
(Extensive Experience)
Provides strategic direction to the workforce in managing time to avoid low-value work.
Level 5 Behaviors
(Mastery)
Monitors the performance of business units to determine and eliminate deviations from priorities.
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.
