Continue in 2 seconds

What are the responsibilities of a data warehouse project manager?

  • Joe Oates, Sid Adelman, Chuck Kelley, Clay Rehm, Les Barbusinski
  • December 09 2003, 1:00am EST
More in


What are the responsibilities of a data warehouse project manager?


Sid Adelman’s Answer: DW project manager roles:

  • Overall responsibility for the data warehouse
  • Defines and plans the project
  • Creates a schedule
  • Recruits the best possible team
  • Coordinates the team activities
  • Estimates the cost and benefits
  • Acts as a quality reviewer of the deliverables
  • Produces or ensures the production of project deliverables
  • Measures the costs and benefits
  • Makes improvement recommendations
  • Communicates with sponsor, IT management

Les Barbusinski’s Answer: See Chapter 8 of Data Warehouse Project Management (by Sid Adelman and Larissa Moss).

Chuck Kelley’s Answer: To make sure that the data warehouse project is a success and on budget.

Joe Oates’ Answer: In my experience, the responsibilities of a data warehouse project manager are planning, organizing, facilitating and reporting. The organization management usually delegates to the project manager the responsibility to deliver the assigned project on schedule and within a budget from initiation through implementation. In order to do this, the project manager must at least do the following:

  • Publish the goals and objectives of the data warehouse project and how these tie into the overall organization goals and objectives
  • Define a project methodology for the data warehouse if none already exists
  • Develop the set of planning documents for each data warehouse implementation phase. These plans include, but are not limited to:
    * Project Charter
    *Project Plan
    *Communications Plan
    *Data Quality Plan
    *Issue Management Plan
    *Change Management Plan
  • Modify the above planning documents to reflect changes in resources, schedule and budget for each phase
  • Monitor adherence to business policies and procedures and organization standards
  • Prepare, maintain and communicate above planning documents and status to the DW team and management
  • Communicate project status, issues and concerns to project stakeholders according to communications plan
  • Escalate critical issues and recommended solutions to upper management in a timely manner
  • Manage user expectations throughout the project life cycle
  • Negotiate for internal and external resources needed to meet project needs
  • General scheduling of meetings
  • Smooth path for DW team members in performing their assigned tasks
  • Obtain and allocate resources

Clay Rehm’s Answer: The responsibilities of a data warehouse project manager are covered in a book by Sid Adelman and Larissa Moss called Data Warehouse Project Management.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access