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 data modeling and reporting concepts applicable to business Intelligence.
Level 2 Behaviors
(Light Experience)
Collects business intelligence data to analyze our business's competitiveness.
Level 3 Behaviors
(Moderate Experience)
Partners with the management in streamlining business intelligence and analytics tools.
Level 4 Behaviors
(Extensive Experience)
Drives the overall data quality improvement initiatives to leverage business intelligence tools.
Level 5 Behaviors
(Mastery)
Creates overall solutions for various complex enterprise needs in the business intelligence area.
Skill definition-Creating a visual representation of an information system to illustrate the relationships among data types.
Level 1 Behaviors
(General Familiarity)
Explains the workflow and process of data modeling.
Level 2 Behaviors
(Light Experience)
Selects conceptual, logical, and physical data models to optimize efficiency and outputs.
Level 3 Behaviors
(Moderate Experience)
Utilizes operational data modeling processes and capabilities to streamline data visualization.
Level 4 Behaviors
(Extensive Experience)
Directs the integration of data modeling into an overall systems development methodology.
Level 5 Behaviors
(Mastery)
Leads the integration of approved data modeling best practices and standards company-wide.
Skill definition-Executing and completing a task with a high level of accuracy.
Level 1 Behaviors
(General Familiarity)
Identifies the procedures for making sure that results are mistake-free.
Level 2 Behaviors
(Light Experience)
Records all appointments on the calendar to easily track daily activities.
Level 3 Behaviors
(Moderate Experience)
Sets up processes to ensure delivery of high-quality work.
Level 4 Behaviors
(Extensive Experience)
Designs systems to help the team organize and track details and project progress.
Level 5 Behaviors
(Mastery)
Develops best practices for identifying and correcting errors, oversights, and omissions.
Skill definition-Managing and setting priorities, goals, and timetables to boost productivity and efficiency in completing tasks.
Level 1 Behaviors
(General Familiarity)
Discusses workplace barriers and issues that may affect time management.
Level 2 Behaviors
(Light Experience)
Employs the 80-20 rule to avoid perfectionism and minimize time-wasting.
Level 3 Behaviors
(Moderate Experience)
Handles workplace obstacles to maintain focus and manage time efficiently.
Level 4 Behaviors
(Extensive Experience)
Improves processes to organize workloads of teams efficiently.
Level 5 Behaviors
(Mastery)
Keeps current on the latest working models on time management to drive organizational 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.