MIS Data Analyst at Capitec Bank

Job description

KEY PERFORMANCE AREAS

• Supports and maintains the project data models at multiple levels of detail and functionality (conceptual, logical, normalised, relational, dimensional, application-level, subject-level, integrated, etc.).
• Works closely with data stewards and BIBA’s to ensure that Business Glossary remains current.
• Works closely with Data Modeler to draw up and maintain detailed data models.

KEY TASKS & ACCOUNTABILITIES

• Data
• Identifies and defines the data requirements necessary to support business requirements or integrated application and subject areas.
• Identifies and defines the security requirements necessary to protect the data items.
• Identifies and defines the business rules associated with the data; these should include all data integrity / constraint requirements.
• Identifies and performs detailed analysis of all data sources for each application and subject area.
• Performs data profiling of data contained in source systems.
• Provides detailed analysis of all data implemented into the database.
• Provides the data mapping and associated transformation rules for each data item.
• Ensures that the business requirements and subsequent development activities are supported by accurate information.
• Assists ETL Analysts to draw up data cleansing specifications.
• Presents data quality anomalies and problem areas to business users and source system owners.
• Validates data models against the business- and data requirements.
• Ensures the quality, accuracy, integrity and conformity to standards of all models.
• Provides accurate metadata, which allows full understanding of the project data components.
• Coordinates and synchronises data models with process and technical models.
• Identifies data and data model inconsistencies and conflicts and assist the users in their resolution.
• Transitions information and assists the DBA’s with physical implementation of the data models.
• Transitions information and assists developers with the data mapping and transformation, and provides additional data analysis as required during the development phase.
• Communicates project data-related information to Architects, DBA’s, Developers and Users.
• Works with modeling tools and data repository to maintain project deliverables.

KNOWLEDGE, SKILLS & EXPERIENCE

Qualifications & Experience:

• Grade 12
• A relevant 3 year tertiary qualification (degree / diploma) and at least 6 years’ proven experience within management information systems / analysis
• Proven experience in drafting functional specifications

Must have detailed knowledge of:

• Business Analysis
• Data Warehouse Methodologies
• BI Best Practice
• Data Analysis
• Data Governance
• Financial systems and procedures
• Data profiling and data profiling tools
• IT systems development life cycle
• Ideal:
• Detailed knowledge of:
• Banking systems environment
• Banking business model
• Agile development life cycle
• Best practices for Quality Assurance (QA)
• Microsoft Appliance (APS)
• Data Modeling and Data Modeling tools
• Skills
• Communication
• Communication skills (written and verbal) in English
• Interpersonal / Relationship management skills
• Negotiation and influencing
• Facilitation
• Presentation skills
• Mind-set and attitude
• Analytical, diagnostic and problem solving skills
• Business acumen
• Process and organisational thinking
• Attention to detail
• Adaptability to change
• Willingness to take ownership and accountability
• Time management
• Planning and organizing skills
• Project Management skills
• Ability to work under own initiative without guidance, cope well under sustained pressure and deliver to deadlines

ADDITIONAL INFORMATION

• Own car
• Valid driver’s license
• Contactable on (own) cell phone
• Ability and willingness to work standby and / or weekends
• Clear credit record
• Clear criminal record