Business analysts of data warehouses work in a variety of fields, from healthcare to auto claims and even banking. A four-year bachelor's degree in business and knowledge of SQL servers and SQL queries are generally required for this position, and these analysts spend many days working in warehouses in teams or alone; some may also supervise other employees.
These analysts typically work during traditional weekly business hours, and some overtime may be expected. They may work with customers either directly or indirectly. The work can be both mental and physical; they generally work long days in an office filled with filing medical and insurance claims, and may also supervise other employees or spend time in a warehouse dealing with computer software. Some even work with technology in a healthcare facility, such as a hospital, or even an online company such as Google. SQL data knowledge is the most important requirement for this position.
Business Analyst, Data Warehouse Tasks
Identify business requirements of data warehouse.
Develop best practices for data loading and extraction into and out of the data warehouse.
Design end user interface including reporting.
Plan, design, schedule and coordinate data warehouse analysis, design, development, and deployment.