Data Warehousing Specialists

Data warehousing analysts must complete an internship, co-operative education experience, or summer job during college. Managers need at least five years of experience in a data warehousing environment, which includes work in a supervisory capacity.

Data warehousing specialists must have excellent analytical, project management, organizational, communication, and interpersonal skills; the ability to manage multiple tasks in a fast-paced environment, meet deadlines, and prioritize tasks; and a willingness to continue to learn throughout their careers. In addition, they must have a working knowledge of the following software programs (although requirements vary by employer):

• data warehousing tools and database systems: especially Oracle, Microsoft SQL Server, and IBM Db2
• database management system software: especially Apache Hadoop and Teradata Database, but also Apache Oozie and Talend Data Integration
• development environment software: especially C, COBOL; Microsoft .NET Framework; and Microsoft Visual Basic Scripting Edition VBScript
• metadata management software: especially erwin Data Modeler and Talend Data Fabric, but also Oracle Warehouse Builder and SAS Data Management
• object- or component-oriented development software: especially C++; Objective C; and Python, but also Apache Spark
• operating system software: especially Linux; Oracle Solaris; and Ubuntu, but also Apple Macintosh OS