To develop or deploy a BI solution for your organizations, you need to have the right people involved in the time time. Here are typical roles involved in a BI data warehouse project.

  • Project Sponsor
  • Project Manager
  • Functional Analyst
  • SME
  • BI Architect
  • ETL Developers
  • DBA

The job description and responsibilities are listed in this table:

Job Role Description Responsibilities
Project Sponsor The project sponsor is normally an executive from the company, such as CIO, CFO, Controller.
  • Represent the data warehouse project to the upper management.
  • Authorize the resources to the project
  • Represent the client when the project is outsourced to the external consulting firm.
Project Manager The project manager is responsible for the project planning and tracking the overall project status. If the project is outsourced to the consulting firm. The project manager is typically from the external company.
  • Develop and Update the project plan
  • Held the periodic project meetings
  • Track progress
  • Track Issue
  • Report the project status to sponsor
Functional Analyst The functional analyst analyze the requirements and define the metrics, reports, and dashboards. The functional analyst should translate the business requirements to the technical specifications.
  • Gather requirements from users
  • Create the business requirement document
Subject Matter Expert (SME) The SME is typically from the deploying company. The SME is usually the end-user who represents the departmens or business function and can explain the business process and information requirements. The SME works as part time in the project, but are essential in the requirement gathering and user acceptance testing.
  • Describe the business requirement and business process to the functional analyst
  • End User Acceptence Testing
  • Provide feedback to the report and dashboard design
  • May be the trainer in their own departments
BI Architect The BI Architect is familar with dimensional modeling and the BI tools. BI architect defines the star schema and the metrics. BI architect typically comes from the specialized BI consulting firm.
  • Design the logical model with the inputs from the functional analyst
  • Develop the BI meta data in the repository
  • Define the Physical to Business Model Mapping
ETL Developers The ETL developer in charge of the programs which extract the data from source OLTP applications and populate the data warehouse. The ETL developer should be familiar with the ETL tool such as Oracle Data Integrator or Informatica, or the programming language used to perform the ETL jobs. The ETL developer typically from the external consulting firm.
  • Design and develop the ETL program
  • Perform the testing
DBA The DBA or system adminsitratoris from the deploying company to support the BI data warehouse deployment. DBA works with the BI architect and ETL developer on performance tuning.
  • Create and maintain the database
  • Provide the backup and recovery support to the development as well as on-ong environment