Data warehousing programs teach students how to stage, integrate, and access information. Programs expose students to information applications for specific industries, such as tracking inventory and working reservations in hotel and tourism fields, managing the supply chain in manufacturing industries, and identifying market variables in global economies. Topics in these degrees include management of information systems (IS), computer technology, business, or database management/technologies, enterprise systems, networks, security, and website development.
Students in an associate degree program in information technology learn to build and manage databases and analyze data. Bachelor's programs in information systems management have a strong business component and prepare students to use technology for business processes. Those enrolled in a master's program in information system management learn about similar business and computer topics as those in bachelor's programs, though with advanced studies in database management, security, communication networks principles, IS analysis, and design. Degrees may also include internships, projects, and seminars.
Associate of Applied Science in Information Technology
Data warehousing courses and concentrations are often part of an information technology degree. Graduates create new data repositories so businesses can extract specific information. Students also learn elementary concepts and principles in locating and integrating information from other applications. Other courses cover:
- Intro to computer science
- Access systems analysis and administration of databases
- Information systems management
- Business organizations
- Elementary data warehouse concepts
- Data mining and warehousing
Bachelor of Science in Information Systems Management
Colleges ask students to apply themselves in four areas of concentration as they gain knowledge and expertise in IS management. BS graduates learn to think critically, analyze, and communicate in an effective manner.
In addition to liberal arts electives, students take applied business courses and a core in macro- and microeconomics and statistic methodologies. The IS component addresses analysis and management, business computing, collaborative technologies, database design, and networks. Other courses offered as options, electives, or requirements include:
- Network administration
- Disaster recovery and advanced SQL
- Architecture and protocols
- Managing databases and securing information
- Data warehousing and mining
- Web architecture, design concepts, and principles
Master of Science in Information Systems Management
Graduates with MS-ISM degrees are ready for analytical positions which play an important strategic role in most businesses. This degree is also an excellent complement to an accounting degree, offered under a business school or college, as MS-ISM programs also require a well-rounded education in finance, accounting, and marketing. Most graduate schools design programs around a common background of information systems fundamentals and technical knowledge.
In addition to database management, courses prepare graduates for intensive study in data mining, multimedia databases, homeland security application, and warehousing. Further coursework, some of which are electives, includes:
- Knowledge management in e-business, IS policies, and administration
- Enterprise architecture, security audits, and compliance
- Electronic security, detecting intruders, and telecommunications management
- Acquisition and management of knowledge in e-commerce
- Secure software, protocols, and experimentation
- Advanced data warehousing
Popular Career Opportunities
As a stand-alone degree, AAS graduates find entry- and lower-level positions in educational and cultural institutions, in private sectors such as manufacture, finance, and the Internet, and in government, finance, research, and utilities. These positions may include:
- IT specialist
- Assistant manager of information systems
Other entry-level computer and IS analyst positions which involve data warehousing include:
- Software applications engineer
- Network administrator
- Security specialist
- Web developer
- Data warehouse manager
Employment Outlook and Salary Info
Job growth for computer and information systems managers is expected to increase by 11% from 2018 to 2028, reports the U.S. Bureau of Labor Statistics (BLS). New technology applications continue to drive demand for workers, fueling the need for managers. The field is expected to experience the greatest growth in systems design, mobile development, and cyber security, with the healthcare industry projected to see strong growth as it expands the use of IT services. Outsourcing and consolidation of IT services may reduce growth in other industries.
According to the BLS, wages vary by specialty and responsibility. The median annual wage of computer and systems information managers in May 2018 was $142,530. The middle 50% earned between $110,110 and $180,190. Mean annual wages in industries employing the most computer and information systems managers for the same period were software publishing ($170,790 per year); computer systems design and related services ($159,790); companies and enterprises ($155,460); scientific and technical consulting services ($161,070); and insurance ($152,870) (www.bls.gov).
Continuing Education Information
Lifetime learning is necessary because certificates and accreditation enhance job opportunities. Educational institutions, product vendors, associations, and other trainers provide certificates that many employers view as an industry standard and prerequisite to employment. Many certificates and training programs are offered as part of a degree, as a concentration in the degree, or as professional certificates.
Associate degree certificates can be earned in Oracle Database Administration, Oracle Certified Associate or Oracle Database Administration, Microsoft Certified IT Professional Database Administration, and SAS Data Mining for Marketers, among others. Undergraduates can find certificates in database systems technology, information technology, software engineering, project management, informatics and information assurance. There are also Data Warehouse and Business Intelligence certificates. They offer graduate certificates in open source database, database management, electronic commerce, information engineering, and data mining. Others, such as information technologies, data warehouse and business intelligence and data warehousing are also available.
Associate, bachelor's, and master's degrees in IT and ISM are commonly available and students interested in data warehousing may take it as a specialization. These degrees prepare graduates for careers at various levels of the information management field.