How do most people structure BI/DW teams? Who do we want on the team? What's the typical chain of command? Are they part of the IT department?
Business intelligence/data warehousing teams are constructed quite differently from shop to shop. The most common placement is within IT, although recently I've noticed more in the CFO's area instead.
In business intelligence and data warehousing teams, there is a Director, a Technical Lead (which is somebody that oversees the architecture and can roam into multiple of the other positions), ETL developers (typically mutliple of these) and data access developers. Data modelers may also be a distinct role, or modeling may be done by the Technical Lead. Business analysis is required and may be done by the modeler in small shops. The Physical DBA/System Admininstration needs are generally done by service level agreement (SLA) with those core IT teams -- although in larger shops, a Logical DBA/physical modeler may be needed.
More information on business intelligence and data warehousing teams:
Dig Deeper on Data warehouse software
Related Q&A from William McKnight
There are loads of business intelligence tools out there on the market today. Our business intelligence expert provides some valuable resources for ... Continue Reading
Find out how Oracle’s acquisition of Sun may affect Oracle data warehouse strategy and what it means for users. Also, see what role packaged BI ... Continue Reading
Find out when you should use a DBMS with your data warehouse, and learn about the future of data warehousing data management and current state of ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.