Data Warehousing Specialists


About

Exploring this Job

Become a member of the Technology Student Association (http://www.tsaweb.org), which will provide you with an opportunity to explore career opportunities in technology, science, engineering, and mathematics, enter academic competitions (including one in Data Science and Analytics), and participate in summer exploration programs.

Participate in information interviews with data warehousing managers. In such an interview—which can be conducted in-person, on the phone, or through video-conferencing technology—you will get the opportunity to ask child life specialists about their job duties, work environment, likes and dislikes about their careers, educational training, and other topics that will help you to learn more about the field. Ask your school counselor or a computer science teacher to help you set up information interviews. In addition, participate in job-shadowing experiences with specialists to learn more about the field.

Check out the following resources to learn more about data science and data warehousing:

  • Data Science Glossary: http://www.datascienceglossary.org
  • Working With Big Data:http://www.bls.gov/careeroutlook/2013/fall/art01.pdf
  • Computerworld: http://www.computerworld.com
  • What is a Data Warehouse?: https://cloud.google.com/learn/what-is-a-data-warehouse

The Job

According to IBM, 2.5 quintillion bytes of data are created every day. These massive collections of data, which are known as Big Data, consist of texts, videos, photographs, maps, electronic medical records, scientific information from sensors, purchase transaction records, cell phone GPS signals, articles and books, blog posts, bank records, census and other survey data, and other types of data.

Big data is used by businesses, government agencies, and nonprofit organizations, and data warehousing specialists design, develop, and maintain data warehouses to store data and allow it to be used for a wide range of applications. The management consulting firm Bain & Company reports that “early adopters of Big Data analytics have gained a significant lead over the rest of the corporate world…those with the most advanced analytics capabilities are outperforming competitors by wide margins.”

Job responsibilities vary for data warehousing specialists depending on their employer, job title, and other factors, but most perform the following duties:

  • design, develop, and maintain data warehouses, user interfaces, and data mart systems (sub-areas of a data warehouse that contain all the information stored on a particular topic such as business operations in a particular country, climate statistics and research from a particular decade, or photographs and biographical information for suspected terrorists living in Kazakhstan)
  • work with database architects and developers during the design process to ensure that the proposed design is in agreement with organizational strategies and existing data systems
  • develop data warehouse process models, including sourcing, loading, and transformation
  • develop and implement data extraction procedures from legacy or other systems, including creating a master data dictionary (which IBM defines as a "centralized repository of information about data such as meaning, relationships to other data, origin, usage, and format”)
  • prepare technical or functional documentation for data warehouses
  • troubleshoot and address any technical problems that arise relating to data warehouses
  • develop strategies to integrate data from their employer’s or client’s databases into the data warehouse
  • collect and analyze data to find useful relationships or patterns (known as data mining)
  • teach employees how to use the data warehouse and related data systems
  • monitor the data warehouse to ensure it is functioning properly and security systems are working
  • liaise with vendors on issues such as upgrades and technical problems and solutions