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)
Explains the functions of existing and emerging data and business intelligence platforms.
Level 2 Behaviors
(Light Experience)
Gathers business intelligence data to make informed conclusions on business practices.
Level 3 Behaviors
(Moderate Experience)
Produces a user manual for the business intelligence system to assist stakeholders with proper data navigation.
Level 4 Behaviors
(Extensive Experience)
Manages the overall data transformation from multiple sources into actionable business intelligence.
Level 5 Behaviors
(Mastery)
Designs a new strategy for business intelligence insights to support our business's objectives.
Skill definition-Creating a visual representation of an information system to illustrate the relationships among data types.
Level 1 Behaviors
(General Familiarity)
Lists commonly used data modeling, diagramming, and visualization tools.
Level 2 Behaviors
(Light Experience)
Supports data acquisition and preparation to create modeling datasets for predictive models.
Level 3 Behaviors
(Moderate Experience)
Validates documentation for all the metadata related to data modeling and design.
Level 4 Behaviors
(Extensive Experience)
Evaluates data processes and modeling techniques to address the enterprise's needs and requirements.
Level 5 Behaviors
(Mastery)
Monitors the development and design of a data vision, strategy, and implementation path.
Skill definition-Executing and completing a task with a high level of accuracy.
Level 1 Behaviors
(General Familiarity)
Lists best practices and tools to maintain high accuracy and thoroughness in the workplace.
Level 2 Behaviors
(Light Experience)
Uses checklists to ensure that information goes out error-free.
Level 3 Behaviors
(Moderate Experience)
Suggests solutions to issues that arise while executing the tasks.
Level 4 Behaviors
(Extensive Experience)
Employs techniques for motivating personnel to meet or exceed accuracy goals.
Level 5 Behaviors
(Mastery)
Leads the creation of tools for enhancing and assuring accuracy.
Skill definition-Managing and setting priorities, goals, and timetables to boost productivity and efficiency in completing tasks.
Level 1 Behaviors
(General Familiarity)
Explains the importance of time management in driving the overall productivity of our business.
Level 2 Behaviors
(Light Experience)
Follows an updated calendar to list and complete tasks and assignments according to priority level.
Level 3 Behaviors
(Moderate Experience)
Utilizes departmental tools and best practices to organize tasks effectively and productively.
Level 4 Behaviors
(Extensive Experience)
Manages teams in streamlining work-related tasks to prioritize highest value tasks firsts.
Level 5 Behaviors
(Mastery)
Leads transformational changes to work plans to drive the proper utilization of time and resources.
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.
