Partners across IT and with assigned business line(s) to assess, research, and analyze business, technical and system needs in order to resolve business systems issues by recommending technology solutions that meet sponsor/stakeholder needs.

All responsibilities carried out in accordance with Code of Conduct, Company Values and Guiding Principles ensuring adherence to Privacy principles.

The MIS analyst needs to fullfill several 'roles' in the business intelligence space since we are a small team, chiefly:

• Data modelling, experienced in data analysis and dimensional modelling, preferably with Financial services background
• Data staging, experienced in extracting, transforming and loading data

Software experience specific to the role:

• Cognos BI suite, Data Manager, PowerPlay, Transformer, Upfront
• ERwin or equivalent

RESPONSIBILITIES

 Technical Analysis, Design & Specification

• Using different techniques and tools (Data Manager, Transformer, PowerPlay, Impromptu, etc), designs technical solutions that meet business requirements and PLC deliverables including component reusability, data sharing and security.
• Coordinates design phases for small to medium projects/programs, identifying, tracking and resolving technical issues.
• Prepares detailed technical specifications in accordance with all Project Office objectives for PLC and documentation.
• Organizes and participates in walkthrough reviews of all technical specifications, programs and unit test plans.
• Co-ordinates and provides input to DBA in modifying existing database structures for the data marts.

 Coding, Testing & Documentation

• Develops, codes, documents solutions of average to high complexity using different components of the Cognos Business Intelligence suite.
• Writes unit test plans and provides coordination and support of testing using different tools.
• Prepares distribution lists and Operating Manual documentation.
• Completes technical documentation and training material.
• Co-ordinates testing of joint project plans, evaluating vendors and 3rd party software based upon set criteria.

Planning, Implementation & Support

• Provides estimates on activities/tasks required to perform design, coding and unit testing, improving accuracy over time.
• Coordinates implementation planning and execution.
• Performs database/disaster recovery for individual databases.
• Performs performance tuning to improve performance of single function.
• High level planning of phases of projects meeting project objectives within budget and on time.
• Provides on-call support of applications, database etc.

Relationships & Communication

• Effectively communicates and builds rapport with team members, stakeholders and interface groups using a variety of techniques and collaboration from initiation to close.
• Facilitates small to medium size group meetings for technical design, problem solving and task implementation.
• Prepares and delivers presentations to technology partners.
• Resolves minor conflicts/issues and escalates others as appropriate.

Development & Coaching

• Provides direction, expertise, feedback, coaching and development to build the capability of more junior staff.
• Continually enhances skills and builds knowledge in all aspects of the organization, the business and information systems.

Process Knowledge

• Different design techniques (e.g. OO. Top-down, structured analysis, component-based design) and tools.
• Communication Skills
• Facilitation Skills
• Presentation Skills
• Risk Assessment & Quantification methodologies
• Conflicts and issues resolution and escalation

Business Knowledge

• Business line(s)’ business applications/ processes.

Systems Knowledge

• Different programming languages (e.g. VB, HTML, scripting)
• Multiple platforms e.g. MVS, Internet, Client/Server
• IT Standards, Methodologies, CMM & audit requirements