This RACI Chart describes the division of roles and responsibilities between various SPU business units for systems and data management. It should be referred to when managing day to day work, designating tasks for projects or designing business process. The goal is to eliminate confusion by assigning clear ownership different scopes of work.
| Section |
|---|
BusinessIDM| OIR | CIS |
|---|
| Expand |
|---|
| title | Documentation and Training |
|---|
| - Conducts training on the business usage of stewarded data and systems
- Documents relevant processes and procedures for departmental users
|
|
|
 Image Removed |  Image Added |
|
 Image Removed Image Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
| Expand |
|---|
| title | Software and Business Alignment |
|---|
| - Aligning people and processes with software tools to improve business efficiency and effectiveness
- Conducts business process analysis to design process and procedures that best utilize existing software tools or identifies new software needs
|
|
|
Image Removed | Image Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added | Data Management | DEPT | SDMG |
|---|
|
IDM| OIR | CIS |
|---|
| Expand |
|---|
| - Maintain quality and integrity of shared and stewarded data
- Manage access and appropriate usage of stewarded data
- Ensure institutional data quality including consistent usage of data and terms institutionally
|
|
|
Image Removed | Image Added |
|
Image RemovedImage Added |
|
 Image Removed Image Added |
|
 Image Removed Image Added |
| Expand |
|---|
| title | Data Reporting / Business Intelligence |
|---|
| - Maintain strong understanding of shared and departmental data and databases
- Design and build reports / dashboards on stewarded data.
- Assist other technical staff writing reports
|
|
|
off Image Removed- / dashboards based on stewarded data.
|
|
|
| Image Removed | Image Removed | Image Removed | Building - Build imports and exports of data from internal and external data systems
|
|
|
Overseeing - Oversee the quality and integrity of imported/exported data
|
|
|
CoordinatesCollaborates - Collaborate on imports/exports that impact shared data
|
|
|
Image Removed | Image Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added | |
|
Defining - Define how data will be recorded and stored at the institution
|
|
|
Setting - Define data definitions and standards
|
|
|
Image Removed | Image Removed | Image Removed | Image Removed | Image Added | Image Added | Image Added | Image Added |
| Expand |
|---|
| title | Data Warehouse: Data |
|---|
| - Manage warehouse content and ensure data quality
- Collaborate with departments, ensuring data warehouse structure improves institutional use of data
- CIS assists OIR with data extract, transform, and load operations and automation
- CIS maintains the Data Warehouse system (see Systems responsibilities on this page)
|
| Image Added | Image Added | Image Added | Image Added |
| Expand |
|---|
| title | Data Warehouse: Architecture |
|---|
| - CIS defines the Data Warehouse structures and architecture for enterprise analytics
- CIS maintains the Data Warehouse system (see Systems responsibilities on this page)
|
| Image Added | Image Added | Image Added | Image Added | |
|
Oversees - Oversee secure usage, dissemination, and transfer of sensitive data
|
|
|
Maintains enforces - enforce department data security policies and procedures
|
|
|
Maintains - Maintain awareness of legal and regulatory requirements of stewarded data
|
|
|
Image Removed | Image Added |
|
 Image Removed Image Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added | Data Software Systems | DEPT | SDMG |
|---|
|
IDMManages - Manage software security, passwords, firewalls, and other technologies to protect institutional data
|
|
|
Configures protocals- protocols, creates and maintains security classes/groups
|
|
|
Builts - Build audits and other alerting systems to enforce security
|
|
|
standartsImage RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
| Expand |
|---|
| title | Software Configuration: Business |
|---|
|
|
|
Configures - Configure software systems for usage by business units (custom fields, campaigns, permissions etc.)
|
|
|
Image Removed | Image Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
| Expand |
|---|
| title | Software Configuration: Technical |
|---|
|
|
|
Configures - Configure software systems to work in the SPU
|
|
|
envronmentSets - Set up software authentication, configures access, and web presence
|
|
|
Image Removed | Image Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
| Expand |
|---|
| title | Software Documentation and Training |
|---|
|
|
|
Departments - Department document process and procedures for managing stewarded portions resources and systems
- CIS
|
|
|
documents - document relevant processes, policies, and procedures
|
|
|
for the DTU audienceImage Removed | Image Removed | Image Removed | Image RemovedProvides - Provide support to end users of the software systems
|
|
|
Maintains - Maintain working knowledge of software capabilities, features, future upgrades and direction
- Work with software vendors and external peers to troubleshoot and resolved software issues
|
|
|
Image Removed | Image Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
| Expand |
|---|
| title | Software Maintenance |
|---|
|
|
|
Procures installs maintains Maintains - Maintain is defined as installing system upgrades and patches and fixing bugs in custom code
|
|
|
Departments - Department responsible to assist with testing systems upgrades
|
|
|
Image Removed | Image Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
| Expand |
|---|
| title | Software Integration |
|---|
| - Design, implementation and maintenance of automated data flows between data systems
|
|
|
Works - Work with data stewards to build and ensure safe and reliable data transfer
|
|
|
Image Removed | Image Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added | |
|
Designs codes maintains - maintain legacy custom systems and code.
|
|
|
Image Removed | Image Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
| Expand |
|---|
| - Software purchasing for a single department is handled by that department with consultation and approval from CIS
- Cross departmental purchases are handled by a cross departmental project team, SDMG or CIS
|
|
|
| Image Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image Removed | Data Infrastructure Systems | DEPT | SDMG |
|---|
|
IDM| OIR | CIS |
|---|
| Expand |
|---|
| title | System Backup and Redundancy |
|---|
|
|
|
Backing up - Backup of institutional data according to SPU's data retention policies
- Data recovery in the occurrence of data loss
- Disaster recovery planning and implementation
|
|
|
Image Removed | Image Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added | |
|
Procures installs maintains - maintain system hardware (servers, storage, network) and infrastructure
|
|
|
Coordinates - Coordinate testing with data/system stewards
|
|
|
Image Removed | Image Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added |
|
Image RemovedImage Added | Responsible | Responsible for the work |
|
Image RemovedImage Added | Assists | Provides assistance with work |
|
Image RemovedImage Added | Consulted | Consulted before decisions are made or action is taken |
|
Image RemovedImage Added | Informed | Informed that a decision has been made or action taken. |
Roles |
|---|
| DEPT | Departments responsible for stewarding portions of institutional data and systems. Includes Directors, CSMs, Data Managers, etc. | | SDMG | Systems and Data Management Group, responsible for campus wide communication and decision making about data and data systems |
|
IDM | Information and Data Management| OIR | The Office of Institutional Research, responsible for institutional data, reporting and analytics at SPU | | CIS | Computer and Information Systems, responsible for |
|
IT | Information Technology services at SPU |
|
|