Data Warehouse Managers direct the modeling, design, and database development of corporate data storage.  Data Warehouse Managers are responsible for the technical infrastructure designs, data management/flows and reports, as well as for the day-to-day operations and development activities.  

A Glossary of Terms follows and should be referred to for clarity.

DATABASE - A computer program that manages data and can be used to store, retrieve, and sort information. Examples are Oracle, Lotus Approach, Microsoft Access, Filemaker, and dBASE.

ARCHITECTURE - Architecture, in computer software context, is a framework or structure that provides the form of a software system and the conventions, policies, and mechanisms for composing itself with subsystems, or component parts, that can populate the architecture. The architecture defines how the parts relate to each other including constraints governing how they can relate. If a system is divided into parts and components, then there are interfaces that define how the parts intercommunicate or interface.

DATA WAREHOUSE- A collection of data designed to support management decision making. Data warehouses contain a wide variety of data that present a coherent picture of business conditions at a single point in time. Development of a data warehouse  includes development of systems to extract data

from operating systems plus installation of a warehouse database system that provides managers flexible access to the data. The term data warehousing   generally refers to the combination of many databases across an entire enterprise.

JOB DUTIES

Data Warehouse Managers may:  

Manage the enterprise data planning and support functions

Be responsible for the development and maintenance of the enterprise data and database architecture to include the data and database resource planning functions

Provide recommendations for data architecture and database strategies; and communicate data architecture concepts, strategies and standards throughout the organization

Participate in hardware installation and configuration, particularly in areas affecting data warehouse performance, scalability and sustainability

Oversee key performance decisions for the data warehouse and for web/application server configuration for existing data warehouse installations

Design, implement, deploy and maintain the data warehouse, processes, business intelligence and reporting solutions

Work with business users, management and executives to analyze, define and document systems, data sources and business requirements for analytical needs related to the data warehouse and processes

Participate in the complete systems development life cycle (planning, analysis, design, documentation, prototyping, development, testing, training, and launch) of new and existing business applications and business processes

Manage and deliver components of client engagements that identify, design and implement technology and creative business solutions for large companies

Direct teams in the identification of business requirements, functional design, process design (including scenario design, flow mapping), prototyping, testing, training, defining support procedures

The tools and equipment used may include:  

OCCUPATIONAL SPECIALTIES   

In addition to learning about this occupation, you may find it helpful to explore the following Career Exploration Scripts:  

[back to top]

WORKING CONDITIONS AND REQUIREMENTS   

Data Warehouse Managers normally work in offices or laboratories in comfortable surroundings. They typically work about 40 hours a week, the same as many other professional or office workers. However, evening or weekend work may be necessary to meet deadlines or to solve specific problems. Telecommuting is increasingly common for many computer professionals as networks expand, allowing more work to be done from remote locations through modems, laptops, electronic mail, and the Internet. However, some work still must be done in the office for security or other reasons.

Like other workers who spend long periods in front of a computer terminal typing on a keyboard, Data Warehouse Managers are susceptible to eyestrain, back discomfort, and hand and wrist problems such as carpal tunnel syndrome or cumulative trauma disorder.

  You should prefer:

•   Activities involving business contact with people

• Activities which bring recognition or appreciation by others

• Activities of a technical nature

You should be able to:

• Conduct long range strategic planning
• Support and translate company and department goals into ongoing work efforts
• Develop and negotiate contracts with vendors
• Lead and direct projects in a matrix organization
• Effectively motivate team members to achieve high quality results
• Oversee a variety of concurrent activities
• Communicate clearly, concisely, and persuasively about complex, technical or sensitive topics
• Communicate effectively with others in a work environment and with the public
• Make informed decisions by gathering relevant data and applying past experience and knowledge to the situation

Math Problem You Should Be Able to Solve:  

Factor: 12w + 10w - 8

Reading Example You Should Be Able to Read and Comprehend:  

Double space frees space on hard and floppy disks by compressing the data that is on them. Double space is easy to set up and use.

Writing Example You Should Be Able to Produce:  

You should be able to write a report detailing the design and model of your company's data storage methodologies and procedures.

Thinking Skill You Should Be Able to Produce:  

You should be able to analyze and determine company data storage needs.

EDUCATION AND PREPARATION OPPORTUNITIES   

NOTE: A  Bachelor's Degree (four years of study beyond high school) may qualify a person for this occupation.  

The following education and preparation opportunities are helpful in preparing for occupations in this Career Exploration Script:  

***SCHOOL SUBJECTS***

1000 COMPUTERS , 2200 MATH

***VOCATIONAL EDUCATION PROGRAMS***   

There are no Vocational Education Programs related to this Career Exploration Script.

***POSTSECONDARY PROGRAMS***   

 DATA WAREHOUSING   

Programs in Data Warehouse Management, Data Architecture, Computer Science, Computer Engineering, and Mathematics provide opportunities to gain the knowledge and skills needed for becoming a Data Warehouse Manager.

Listed below are schools located in the State of Michigan that offers Certificate, Associate, Baccalaureate, and Master Degree programs in Data Warehouse Management.

Courses vary from school to school but may include:

  Search for a College and/or Instructional Program

***APPRENTICESHIP OPPORTUNITIES***  

There are no Apprenticeships related to this Career Exploration Script.

***MILITARY TRAINING PROGRAMS***

There are no Military Programs related to this Career Exploration Script. 

E-Learning Courses and Programs

OPPORTUNITIES FOR EXPERIENCE AND METHODS OF ENTRY   

In addition, you should access and search the Internet's on-line employment services sites such as: 

You should also enter an electronic resume on these on-line services.

[back to top]

EARNINGS AND ADVANCEMENT   

Earnings of Data Warehouse Managers usually depend on their experience, capabilities, job responsibilities, education, and on the type, size, and location of the employing organization.

Nationally, recent college graduates of bachelor's degree programs in Computer Science were offered starting annual salaries averaging $61,467(mid 2009).  Those with a master's degree averaged $68,427 annually. The median yearly earnings of "all" workers in the U.S. were $38,428 in 2009.

Data Warehouse Managers annual average salaries in the United States in early 2009 were:

Data Warehouse Managers annual salaries in the Great Lakes Region in early 2009 were:  

Depending on the employer fringe benefits for Data Warehouse Managers usually include: paid holidays, vacations, and sick leave; group health, life and disability insurance; pension plans; profit sharing and stock ownership plans; and tuition reimbursement.

[back to top]

EMPLOYMENT AND OUTLOOK   

The number of U.S. employed Data Warehouse Managers is unknown.  The current recession has effected employment in every industry, which has caused both employers as well as employees to make changes. There have been layoffs and cutbacks  across industries, including information technology.  However, businesses, governmental agencies, and other organizations are creating and upgrading their in-house data warehousing systems in order to compete (reduce corporate costs and boost revenues) in a global economy.  As a result, there is a strong demand for the skills, knowledge, and expertise of Data Warehouse Managers.

[back to top]

SOURCES OF ADDITIONAL INFORMATION   

[back to top]

              Copyright © 2010 Michigan Department of Energy, Labor & Economic Growth