At Cornell, we have developed a reusable methodology for data mart development. Below are some terms that are commonly used in conjunction with this proven methodology.
Configuration Manager - CIT staff member responsible for change management and source code control of all programs relating to extract, transformation and load of the data mart.
Data Administrator - provides direction and assistance in defining and integrating common data between data marts
Data Warehouse Architect - CIT staff member who oversees the development of the Cornell Data Warehouse, ensuring that the individual data marts are created in conformance with the "big picture", allowing data marts to interoperate.
DBA(s) - Data Base Administrator. CIT staff member(s) responsible for the effecting the actual physical creation and loading of the data mart. Implements security and provides expertise in monitoring and tuning the data mart for improved performance.
Functional Analyst(s) - user(s) from sponsoring business area who is well-versed in the day-to-day business of the area and acts as the primary source for defining requirements and validating the content and usability of the data mart. This role is involved in all phases of the project.
Functional Developer - End-user (usually a "power-user" who has experience creating Brio REPORTs and using Brio MODELs) who develops reports according to Brio Development Standards to be published on the Brio Portal.
Functional Tester(s) - member(s) of the user community who tests the data mart for accuracy and consistency of content as well as for usability.
Functional Trainer - member of the user community, identified by the sponsor, with the responsibility for carrying out the data mart training as developed in collaboration with the Training Coordinator. Must be: a) well versed in the business area and data of the data mart; b) have time and training experience necessary to deliver this training.
Production Controller - CIT Data Operations staff member responsible for approving, testing and running the data mart load process.
Project Manager - CIT staff member assigned the responsibility for project management; ensures the technical aspects of the project scope are met. This role is involved in all phases of the project.
Security Administrator - CIT staff member who receives and processes all requests for access to the data mart.
Sponsor - High-level business area manager who will provide support for the project as well as have authority to make decisions that affect functional aspects project scope. This role is involved in all phases of the project.
Technical Analyst(s) - CIT staff member(s) responsible for translating functional requirements into the logical and physical requirements for the data mart; creates and populates the metadata mapping document based on information provided by the functional analyst. This role is involved in all phases of the project.
Technical Developer(s) - CIT staff member(s) who takes the physical requirements and creates the necessary extract/transformation/load routines to populate the data mart. Works with Production Control and the DBA to develop proper data mart load procedures.
Training Coordinator - CIT staff member who collaborates with the Functional Trainer to develop the data mart training. Provides oversight and coordination for data mart training, including the hiring of external trainers as necessary.
User Interface Analyst - CIT staff member who designs and builds the user interface through which the end-user will view the data.
User Interface Administrator - CIT staff member who implements, integrates and automates tool-level security.