Information Management Roles and Skills

From MIKE2.0 Methodology

A generic Information Management organisation includes many roles that span most areas of the organisation itself. The skills required are also varied. Four tables are presented that break down the roles into categories for presentation simplicity.

The first table shows the typical skills needed by the individuals that fill management and client liason type roles.

Generic Information Management Roles and Skills Role (one of four tables) General / Project Management Client Liason / Consulting Skills Business Unit Manager Program Manager Vendor Manager Administrative Assistant Data Project Manager Account Manager Business Consultant Business Analyst (Client) Subject Matter Expert Business Unit (Internal) Management Programme Portfolio Management Benefit Realisation Management Service Delivery Management Vendor Management SLA Development and Administration Procurement Management Business Case Development RFI/FRP/Tender Development Strategic Planning Financial Management Resource Management Client Advocacy Subject Matter Expertise Business Requirements Analysis / Definition Business Process Design Solution Proposal Development Project Management Project Definition and Scoping DW Methodologies Cost Benefit Analysis Project Planning Data Management Strategy Definition Methodology and Standards Definition Logical Architecture Design Technical Architecture Design Data Security Design Data Standards Definition Metadata Design Product Selection Proof of Concept Data Quality Assurance Logical Database Design Third Normal Form Modeling Dimensional Modeling Physical Database Design Design in VLDB Environments Data Admin (eg Data Standards Enforcement) Data Modeling Tools RDBMS's Metadata Tools (eg MDS) Database Definition Language (DDL) Data Manipulation Language (DML) Data Source Analysis Source to Target Mapping Extract - Transformation - Load (ETL) Data Transformation and Conditioning Data Staging Design Metadata Collection Data Matching Application Design System Modeling Tools UML Application Development Language (eg COBOL) Middleware (eg. Tibco) Application Development Frameworks (eg. Net) Data Conditioning Tools (eg. Ascential Integrity) Data Matching Tools (eg. Ascential Integrity) Data Profiling Tools End-user Application Development Ad-hoc Query Support SQL Production Reporting Tools (eg. SQR) Data Mining Tools Data Visualisation Tools GUI Development XML Testing Strategy Testing Tools (eg. SQA) Testing and Quality Assurance Methods PC Applications (eg. MS Office) Technical Documentation User Documentation Application Development Teradata Database Administration Database Administration (non-Teradata) DW Capacity Planning Database Admin Tools (eg. DBArtisan) DW Performance Tuning DW Software Installation and Configuration Hardware Installation and Configuration System / Database Back-up and Recovery Operating Systems Data Security Administration Configuration Management User Training Strategy Planning Conduct User Training User Support / Help Desk Teradata Certified Professional Teradata Certified SQL Specialist Teradata Certified Implementation Specialist Teradata Certified Administrator Teradata Certified Designer Teradata Certified Application Developer

The second table shows the typical skills needed by the individuals that fill data management type roles.

Generic Information Management Roles and Skills Role (two of four tables) Data Management Skills Warehouse Architect Data Quality Administrator Data Administrator Data Designer Data Analyst Data Modeler Metadata Analyst ETL Developer Data Conditioning Analyst Database Administrator Business Unit (Internal) Management Programme Portfolio Management Benefit Realisation Management Service Delivery Management Vendor Management SLA Development and Administration Procurement Management Business Case Development RFI/FRP/Tender Development Strategic Planning Financial Management Resource Management Client Advocacy Subject Matter Expertise Business Requirements Analysis / Definition Business Process Design Solution Proposal Development Project Management Project Definition and Scoping DW Methodologies Cost Benefit Analysis Project Planning Data Management Strategy Definition Methodology and Standards Definition Logical Architecture Design Technical Architecture Design Data Security Design Data Standards Definition Metadata Design Product Selection Proof of Concept Data Quality Assurance Logical Database Design Third Normal Form Modeling Dimensional Modeling Physical Database Design Design in VLDB Environments Data Admin (eg Data Standards Enforcement) Data Modeling Tools RDBMS's Metadata Tools (eg MDS) Database Definition Language (DDL) Data Manipulation Language (DML) Data Source Analysis Source to Target Mapping Extract - Transformation - Load (ETL) Data Transformation and Conditioning Data Staging Design Metadata Collection Data Matching Application Design System Modeling Tools UML Application Development Language (eg COBOL) Middleware (eg. Tibco) Application Development Frameworks (eg. Net) Data Conditioning Tools (eg. Ascential Integrity) Data Matching Tools (eg. Ascential Integrity) Data Profiling Tools End-user Application Development Ad-hoc Query Support SQL Production Reporting Tools (eg. SQR) Data Mining Tools Data Visualisation Tools GUI Development XML Testing Strategy Testing Tools (eg. SQA) Testing and Quality Assurance Methods PC Applications (eg. MS Office) Technical Documentation User Documentation Application Development Teradata Database Administration Database Administration (non-Teradata) DW Capacity Planning Database Admin Tools (eg. DBArtisan) DW Performance Tuning DW Software Installation and Configuration Hardware Installation and Configuration System / Database Back-up and Recovery Operating Systems Data Security Administration Configuration Management User Training Strategy Planning Conduct User Training User Support / Help Desk Teradata Certified Professional Teradata Certified SQL Specialist Teradata Certified Implementation Specialist Teradata Certified Administrator Teradata Certified Designer Teradata Certified Application Developer

The third table shows the typical skills needed by the individuals that fill reporting and application development type roles.

Generic Information Management Roles and Skills Role (three of four tables) Reporting / Application Development Skills Solution Architect SQL Programmer Application Programmer OLAP Developer GUI Developer Report Developer Testing Analyst Business Unit (Internal) Management Programme Portfolio Management Benefit Realisation Management Service Delivery Management Vendor Management SLA Development and Administration Procurement Management Business Case Development RFI/FRP/Tender Development Strategic Planning Financial Management Resource Management Client Advocacy Subject Matter Expertise Business Requirements Analysis / Definition Business Process Design Solution Proposal Development Project Management Project Definition and Scoping DW Methodologies Cost Benefit Analysis Project Planning Data Management Strategy Definition Methodology and Standards Definition Logical Architecture Design Technical Architecture Design Data Security Design Data Standards Definition Metadata Design Product Selection Proof of Concept Data Quality Assurance Logical Database Design Third Normal Form Modeling Dimensional Modeling Physical Database Design Design in VLDB Environments Data Admin (eg Data Standards Enforcement) Data Modeling Tools RDBMS's Metadata Tools (eg MDS) Database Definition Language (DDL) Data Manipulation Language (DML) Data Source Analysis Source to Target Mapping Extract - Transformation - Load (ETL) Data Transformation and Conditioning Data Staging Design Metadata Collection Data Matching Application Design System Modeling Tools UML Application Development Language (eg COBOL) Middleware (eg. Tibco) Application Development Frameworks (eg. Net) Data Conditioning Tools (eg. Ascential Integrity) Data Matching Tools (eg. Ascential Integrity) Data Profiling Tools End-user Application Development Ad-hoc Query Support SQL Production Reporting Tools (eg. SQR) Data Mining Tools Data Visualisation Tools GUI Development XML Testing Strategy Testing Tools (eg. SQA) Testing and Quality Assurance Methods PC Applications (eg. MS Office) Technical Documentation User Documentation Application Development Teradata Database Administration Database Administration (non-Teradata) DW Capacity Planning Database Admin Tools (eg. DBArtisan) DW Performance Tuning DW Software Installation and Configuration Hardware Installation and Configuration System / Database Back-up and Recovery Operating Systems Data Security Administration Configuration Management User Training Strategy Planning Conduct User Training User Support / Help Desk Teradata Certified Professional Teradata Certified SQL Specialist Teradata Certified Implementation Specialist Teradata Certified Administrator Teradata Certified Designer Teradata Certified Application Developer