Versions Compared

Version Old Version 1 New Version Current
Changes made by

Micah Schaafsma

Micah Schaafsma

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



...

Image Removed
Excerpt

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.  


Image Removed
Section


Column
 


Data Creation

CSM
DEPTSDMG
IDM
OIRCIS


Expand
title
System Backup
  • Backing up of institutional data
  • Restoration after data loss
Image RemovedImage RemovedImage Removed
Documentation and Training
  • Conducts training on the business usage of stewarded data and systems
  • Documents relevant processes and procedures for departmental users


Image Added
Image Added
Image Added
Image Added


Expand
titleSoftware 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 Added
Image Added
Image Added
Image Added

Data Management

DEPTSDMGOIRCIS


Expand
title
System Integration
  • Designing data flows between data systems
  • Maintaining existing data flows
Image RemovedImage RemovedImage Removed
Data Stewardship
  • 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 Added
Image Added
Image Added
Image Added


Expand
titleData Reporting
Understanding Column

Legend

 TitleDescriptionImage RemovedResponsibleResponsible for the workImage RemovedAccountableHas ultimate ownership and authorityImage Removed
/ Business Intelligence
  • Maintain strong understanding of shared and departmental data and databases
  • Designing and building reports for supported areas
    • Image RemovedImage RemovedImage RemovedImage Removed
    Expand
    titleData Stewardship
    • Maintain integrity of shared and departmental data
    • Manage access to departmental data
    Image RemovedImage RemovedImage RemovedImage Removed                                                                           

     

    • Design and build reports / dashboards on stewarded data.
    • Assist other technical staff writing reports / dashboards based on stewarded data.
    • Institutional and external reporting are the responsibility of OIR


    Image Added
    Image Added
    Image Added
    Image Added


    Expand
    titleData Import/Export
    • Build imports and exports of data from internal and external data systems
    • Oversee the quality and integrity of imported/exported data
    • Coordinate/Collaborate on imports/exports that impact shared data


    Image Added
    Image Added
    Image Added
    Image Added


    Expand
    titleData Definitions
    • Define how data will be recorded and stored at the institution
    • Define data definitions and standards


    Image Added
    Image Added
    Image Added
    Image Added


    Expand
    titleData 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
    titleData 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


    Expand
    titleData Security
    • Oversee secure usage, dissemination, and transfer of sensitive data
    • Maintain and enforce department data security policies and procedures
    • Maintain awareness of legal and regulatory requirements of stewarded data


    Image Added
    Image Added
    Image Added
    Image Added

    Data Software Systems

    		DEPTSDMGOIRCIS


    Expand
    titleSoftware Security
    • Manage software security, passwords, firewalls, and other technologies to protect institutional data
    • Configure core security protocols, creates and maintains security classes/groups
    • Build audits and other alerting systems to enforce security standards.


     Image Added
    Image Added
    Image Added
    Image Added


    Expand
    titleSoftware Configuration: Business
    • Configure software systems for usage by business units (custom fields, campaigns, permissions etc.)


    Image Added
    Image Added
    Image Added
    Image Added


    Expand
    titleSoftware Configuration: Technical
    • Configure software systems to work in the SPU environment
    • Set up software authentication, configures access, and web presence


    Image Added
    Image Added
    Image Added
    Image Added


    Expand
    titleSoftware Documentation and Training
    • Department document process and procedures for managing stewarded portions resources and systems
    • CIS document relevant processes, policies, and procedures technical administration by departments


    Image Added
    Image Added
    Image Added
    Image Added


    Expand
    titleSoftware Support
    • Provide support to end users of the software systems
    • 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 Added
    Image Added
    Image Added
    Image Added


    Expand
    titleSoftware Maintenance
    • Procure, install and maintain system software
    • Maintain is defined as installing system upgrades and patches and fixing bugs in custom code
    • Department responsible to assist with testing systems upgrades


    Image Added
    Image Added
    Image Added
    Image Added


    Expand
    titleSoftware Integration
    • Design, implementation and maintenance of automated data flows between data systems
    • Work with data stewards to build and ensure safe and reliable data transfer


    Image Added
    Image Added
    Image Added
    Image Added


    Expand
    titleCustom Development
    • Design, code and maintain legacy custom systems and code.


    Image Added
    Image Added
    Image Added
    Image Added


    Expand
    titleSoftware Purchasing
    • 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 Added
    Image Added
    Image Added

    Data Infrastructure Systems

    		DEPTSDMGOIRCIS


    Expand
    titleSystem Backup and Redundancy
    • 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 Added
    Image Added
    Image Added
    Image Added


    Expand
    titleSystem Maintenance
    • Procure, install and maintain system hardware (servers, storage, network) and infrastructure
    • Coordinate testing with data/system stewards


    Image Added
    Image Added
    Image Added
    Image Added



    Column
    width350px


    Chart Key

    Image Added
    		ResponsibleResponsible for the work
    Image Added
    		AssistsProvides assistance with work
    Image Added
    		ConsultedConsulted before decisions are made or action is taken
    Image Removed
    Image Added
    		InformedInformed that a decision has been made or action taken.

     

     

     


    Roles

    DEPTDepartments responsible for stewarding portions of institutional data and systems. Includes Directors, CSMs, Data Managers, etc.
    SDMGSystems and Data Management Group, responsible for campus wide communication and decision making about data and data systems
    OIRThe Office of Institutional Research, responsible for institutional data, reporting and analytics at SPU
    CISComputer and Information Systems, responsible for Information Technology services at SPU