Welcome to lesson seven of module one on data warehouse concepts and architectures. I'm going to start with an important questions about a career involving data warehouses and business intelligence. What position do you want to aspire in your career? What is your strategy to obtain this position? Lesson seven concludes the informational background in module one, with details about career opportunities. You will learn about position requirements, skill acquisition, and salary levels. You have two learning objectives in this lesson. You should gain awareness about employment and career opportunities. Most importantly, you should begin reflecting on a strategy for initial employment evolving into a career involving data warehousing and business intelligence. These job titles were taken from an employment publication created by the Robert Half Technology Division. Robert Half is a leading firm providing professional staffing services with more than 400 locations world wide. The duties and qualifications of these positions have some overlap. The data warehouse analyst and business intelligence analyst collaborate with users. The data warehouse analyst is more involved with data warehouses and collaborates with business analysts and data warehouse managers. The business intelligence analyst is more involved with analytics and communicates with management. The data analyst position does not specialize in data warehouses and business intelligence, but has similar duties as a data warehouse analyst. In smaller organizations, data analysts may work with both operational databases and data warehouses. The data warehouse manager designs, implements, and maintains data warehouses. Data warehouse managers can specialize in processes environment, that is reporting versus data integration, product, and task, the design implementation or maintenance. Senior data warehouse managers often have management responsibilities to supervise a team of data warehouse administrators. This matrix relates skills in positions. The data analyst position is omitted due to overlap with the data warehouse analyst and business intelligence analyst positions. Communication skills are major requirements for data warehouse and business intelligence analysts. But somewhat less for data warehouse managers. For data warehouse managers involved with the design and implementation, communication skill requirements are comparable to analyst positions. Business intelligence analysts have skill requirements for data mining and quantitative modeling, that are not usually necessary for a data warehouse analyst. Data warehouse analyst have scale requirements for data integration tools and schema design, that are not typically necessary for business intelligence analysts. Data analyst have more skill requirements for SQL however. Data warehouse managers have high skill requirements for schema design performance analysis, and SQL extensions. According to analysts the technology division of Robert Half, these positions are not entry level. They typically require three to five years of experience in information technology areas. Along with an education in computing such as computer science or information systems. Thus, you need to take a long term perspective and obtain a position in data warehousing or business intelligence. You need specialized education, such as provided in this specialization. You also need experience, perhaps initially through an internship. Certification in specific products can be important to move from an information technology or business analyst position, into data warehousing or business intelligence positions. Job experience as an analyst can propel you into a data warehouse manager position. According to salaries reported to the Robert Half salary survey. USA demand for data warehouse managers, data warehouse analysts and business intelligence analysts is high, with good compensation growth in recent years. The first three position titles in this table, not specific to data warehouses, have also had good growth. The salary survey reports a substantial premium for Oracle and Microsoft Sequel Server Skills of about ten percent. The salary trends in Europe and Australia, reported by Robert Heft, are not as clear and lack reporting about data warehouse positions. These trends show wide variance with flat salary growth in the ranges reported. The global salary survey, conducted by Robert Half, lacks the specificity and data of the USA survey. This lesson concludes the informational background in module one. You learned about positions, skill requirements and acquisition, and salary trends. This background should provide strong motivation as you work through remaining modules in this course, and other courses in the data warehousing for business intelligence specialization. In answer to the opening questions, you should carefully evaluate your aspirations for a career in data warehousing and business intelligence. You need a plan to acquire education and professional experience. This specialization provides targeted education that costs thousands from other sources. Employers will be impressed with the certificate demonstrating your completion of this specialization. You may need to augment this specialization with initial experience in product training. To acquire a data warehouse manager position you may need to work in an analyst position for several years. However, if you work for a small firm in an information technology position. You should have opportunity to acquire a variety of experience as a data warehouse analyst and manager.