Data warehouse administrators are responsible for the day-to-day activities of running a computer data warehouse. A wide degree of competency in computer programming is required for this position, and tasks include archiving, tracking data changes, migration, and monitoring data systems. Some troubleshooting and resolving performance issues is also necessary, so strong interpersonal and analytical skills are beneficial.
Data warehouse administrators generally serve as supervisors within a data warehouse and oversee other technicians to ensure that everything runs smoothly. In addition to having direct reports, they themselves may report to a higher-level supervisor. They work exclusively indoors, typically in an office setting within a larger building which houses computer hardware and servers. While they may perform the majority of their duties from a desk, some troubleshooting within the network may be necessary. A typical day involves filing a large number of support tickets for various departments and assigning and overseeing troubleshooting measures, and although they work primarily during regular business hours, some positions have the potential for emergencies which require data warehouse administrators to be on-call at all times.
A great deal of experience in systems administration is required for this position, and an associate's or bachelor's degree in computer science or a related field may also be required by employers.
Data Warehouse Administrator Tasks
Handle customer requests for querying information.
Install, configure, troubleshoot, and maintain data warehouse systems.
Administer data warehouse systems including maintenance and verification of extract, transform, and load operations.