Data Creation | DEPT | SDMG | 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
|
| | | | |
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
|
| | | | |
Data Management | DEPT | SDMG | 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
|
| | | | |
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 / dashboards based on stewarded data.
- Institutional and external reporting are the responsibility of OIR
|
| | | | |
Expand |
---|
| - 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
|
| | | | |
Expand |
---|
| - Define how data will be recorded and stored at the institution
- Define data definitions and standards
|
| | | | |
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)
|
| | | | |
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)
|
| | | | |
Expand |
---|
| - 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
|
| | | | |
Data Software Systems | DEPT | SDMG | OIR | CIS |
---|
Expand |
---|
| - 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.
|
| | | | |
Expand |
---|
title | Software Configuration: Business |
---|
| - Configure software systems for usage by business units (custom fields, campaigns, permissions etc.)
|
| | | | |
Expand |
---|
title | Software Configuration: Technical |
---|
| - Configure software systems to work in the SPU environment
- Set up software authentication, configures access, and web presence
|
| | | | |
Expand |
---|
title | Software 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
|
| | | | |
Expand |
---|
| - 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
|
| | | | |
Expand |
---|
title | Software 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
|
| | | | |
Expand |
---|
title | Software 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
|
| | | | |
Expand |
---|
| - Design, code and maintain legacy custom systems and code.
|
| | | | |
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
|
| | | | |
Data Infrastructure Systems | DEPT | SDMG | OIR | CIS |
---|
Expand |
---|
title | System 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
|
| | | | |
Expand |
---|
| - Procure, install and maintain system hardware (servers, storage, network) and infrastructure
- Coordinate testing with data/system stewards
|
| | | | |