Data Analyst - South Africa

this is a long term opening in south africa . please call on +914040150478 or send your cv to binaryberries8@gmail.com . you can register on this blog for regular updates



Job Description Division: DW: Projects Delivery
Job title: DW: Analyst
Reporting to: DW:
Grade:

Main purpose of the job

The Source Data Analyst is the individual who determines data availability of each source system. This role often involves reviewing copybooks, data dictionaries, existing load routines and validation programs. The role may include investigating programs to identify business rules and validations that must be applied to make the data usable to the business areas. The individual provides input to the design of the Extract/Transform rules and quality assurance tests. The analyst should be able to understand the nature and quality of the data and should provide a data dictionary of the source data (if an accurate data dictionary is not already available).


Key responsibilities


• Gathers key information and consolidates business requirements
• Develops Functional specifications
• Assist with Data Warehouse design, including data models
• Interfaces between Business and Warehouse Developers (Programmers)
• Identifying sources
• Analysing, designing and developing data programmes within their applications for the Warehouse
• Test according to Request specific criteria
• Documentation
• Analysing, coding, testing and correcting programmes / applications for the Warehouse
• Analyse applications / Models to meet Business requirements
• Produce programme specifications and produce programmes within the agreed timeframes
• Ensure through system integration testing that the specification meets User satisfaction
• Assist in UAT
• Source to Target mapping
• Programming data acquisition and transformation
• Applying to Architectures, standards and quality assurance procedures
• Adhering to budget and schedules
• Assisting the Users in finding the right information


Key performance measures


• Development (Projects / Work request / Service Requests) (40%)
• Service (40%)
• Support (20%)

Key dimensions of the job


• Business Acumen
• Analysis
• Design
• Structured Programming
• Communication
• Problem Solving


Important relationships

• Excellent oral and written communication with the emphasis of relationship building


Problem solving, planning and decision making


Problem solving

• Good problem analysis and solving skills
• Correctly diagnoses of problems
• Actively manages expectations
• Is able to work and make decisions under pressure


Planning

• Breaks work down into components and manages it effectively


Decision making

• Sound judgement, logical thinking and good analytical skills












Qualifications and experience


Qualifications

• Minimum Matric with at least 7/8 years IT experience
• General Microsoft literacy
• Data, Systems and Business knowledge
• Analysis
• Data Modelling and Design
• Structured Programming


Experience

• IT experience
• Strong business acumen
• Logical and analytical approach
• Trouble Shooting / Problem Solving
• Sound judgement
• Creativeness
• Analysis & Design
• Structured Programming


Personal competencies

• Good oral and written communication
• Must be task orientated
• Ability to think abstractly and conceptually
• Results orientated
• Demonstrate problem analysis and solving skills
• Self sufficient
• Persistence
• Time Management
• Integrated Development















Behavioural Competencies

Competency Level of competence Indicate
Level Indicate
frequency
KNOWLEDGE COMPETENCIES
BUSINESS KNOWLEDGE Level 1 – Entry - Aware of and understand banking from the perspective of their immediate role and Business Unit.
Level 2 – Intermediate – Demonstrates solid industry understanding with tactical insight into the broader Banks strategy and objectives. X
Level 3 – Expert – Has solid insight into local and global industry dynamics and associated value propositions. Utilises sophisticated business savvy and strategic thinking to position and reposition the business unit.
UNDERSTANDING OLAP Level 3 – Good exposure X
Level4 – Extensive knowledge
Level5 – Can teach someone
ANALYSING REQUIREMENTS Level 3 – Good exposure
Level4 – Extensive knowledge X
Level5 – Can teach someone
ADMINISTRATION Level 3 – Good exposure X
Level4 – Extensive knowledge
Level5 – Can teach someone
TECHINCAL DESIGN & CONSTRUCTION Level 3 – Good exposure
Level4 – Extensive knowledge X
Level5 – Can teach someone
INTER-PERSONAL COMPETENCIES
DELIVERY ORIENTATION Level 1 – Entry – About one’s own delivery around defined, objective deliverables.
Level 2 – Intermediate – About solution delivery and typically involves more unstructured tasks. X
Level 3 – Expert – Champions strategic interventions. Tends to achieve delivery of results through directing others.
SERVICE / CUSTOMER
FOCUS Level 1 – Entry – Providing services around defined customer interactions and needs.
Level 2 – Intermediate – Managing own and others service delivery against dynamic client needs.
Level 3 – Expert – Decides pro-active service interventions, driving alignment between businesses strategic direction and business needs. X
COMMUNICATION SKILLS Level 1 – Entry – Communication restricted to immediate, defined area of work.
Level 2 – Intermediate – Communication spans across hierarchies and deals with changing contexts.
Level 3 – Expert – Communication involves crafting courses of action, motivating and managing commitment. X
TEAM ORIENTATION Level 1 – Entry – Participates in team
Level 2 – Facilitates team interactions
Level 3 – Expert – Set up and leads team X
RELATIONSHIP MANAGEMENT Level 1 – Entry – Relationships around tangible, defined interactions. Context clear, no ambiguity.
Level 2 – Intermediate – Relationships focused on solutions and issue resolution. Context is dynamic, some ambiguity. X
Level 3 – Expert – Relationships span business units and focus on strategic issues. Context is very dynamic, ambiguity often present.
PERSONAL COMPETENCIES
INNOVATION & RESOURCEFUL-NESS Level 1 – Support – Innovates within their immediate environment, exercises resourcefulness through continual improvement.
Level 2 – Facilitation – Innovates across and pushes the boundaries of their Area, exercises resourcefulness using conceptual thinking skills, taking calculated risks using other for inspiration. X
Level 3 – Leadership – Innovates across the business, creates opportunities for self and others to innovate, challenging fundamental paradigms and leveraging diverse sources for ideas and inspiration.
RESILIENCE &
DRIVE Level 1 – Support – Maintains own levels of resilience and drive
Level 2 – Facilitation – Maintains own and encouraging others to retain level of resilience drive and quality.
Level 3 – Leadership – Maintains high levels of resilience and drive, imparting resilience and drive to others through personal passion and conviction. X
PROBLEM
SOLVING Level 1 – Support – Solves problem within the context of their immediate environment, focusing on detail and recommending a context specific solution.
Level 2 – Facilitation – Recognises the interdependencies between areas identifies cause-effect relationships and reflects the ability to think in terms of integrated solutions.
Level 3 – Leadership – Strategically orientated concerned with ensuring the current and future viability of the area/ bank. X
INTEGRITY Level 1 – Support – About own integrity levels
Level 2 – Facilitation – About own and teams integrity levels.
Level 3 – Leadership – About own and businesses integrity levels and the impact it has on culture. X
EMPOWERING Level 1- Support – Proactive individual who openly shares information celebrates success and recognises the potential of others. X
Level 2 – Facilitation – Proactive individual who contributes to an environment, which nurtures personal empowerment and growth.
Level 3 – Leadership – Role models proactive empowerment through identifying and creating opportunities and a culture, which nurtures personal growth.
ABILITY TO CONTROL 3 – Competent
4 – Surpassing X
5 - Outstanding
ASSERTIVENESS 3 – Competent
4 – Surpassing X
5 - Outstanding
CO-OPERATION 3 – Competent
4 – Surpassing X
5 - Outstanding
CRITICAL / LOGICAL THINKING 3 – Competent
4 – Surpassing X
5 - Outstanding
ENTHUSIASM 3 – Competent
4 – Surpassing X
5 - Outstanding
LATERAL / CONCEPTUAL THINKING 3 – Competent
4 – Surpassing X
5 - Outstanding
OWNERSHIP 3 – Competent
4 – Surpassing X
5 - Outstanding
PERSUASIVENESS 3 – Competent
4 – Surpassing X
5 - Outstanding
STRESS TOLERENCE 3 – Competent
4 – Surpassing X
5 - Outstanding
TIME MANAGEMENT 3 – Competent
4 – Surpassing X
5 - Outstanding
JUDGEMENT 3 – Competent
4 – Surpassing X
5 - Outstanding
DETERMINITATION 3 – Competent
4 – Surpassing X
5 - Outstanding
SUPER COMPETENCIES
LEADERSHIP COMPONENTS
(Rating 1 – 5) Inspirational leadership – Focus on and inspires teams and individuals towards a clearly formulated strategy and vision. 2
Leadership style – Consistent, fair and ethical with a positive attitude towards the future. Creates an environment, which encourages self-expression and honest feedback. 2
Customer focus – Provides the guidance, resources, feedback and support required by others to succeed in their work. 4
Dealing with change – Encourages and actively facilitates a questioning, innovative culture ready to adapt ideas improves the overall customer experience. 4
Getting results – Understands what needs to be done to succeed and competently plans, measures and drives implementation and results. 4
Cultural Alignment – Drives and role models the values, culture and leadership philosophy of the Bank ensuring that behaviour has positive repercussions on global relationships and the broader external environment. 2
Diversity – Treats all with respect and dignity. Encourages diversity and equality through remaining fair and consistent. 4
Communication – Accessible, listening to the input of others and sharing information in an honest, transparent manner. Discourages sarcasm, cynicism, and counterproductive input. 4






BUSINESS/ TECHNICAL KNOWLEDGE (SPECIFIED – GROUP IT)
Knowledge Level Of Knowledge Indicate level Indicate frequency
IT APPLICATION KNOWLEDGE Level 1 – Awareness – Understands the role that various IT Applications play across the Business Units from a high-level process perspective.
Level 2 – Mature – Has a high level understanding of the functionality and impact of a wide range of IT Applications across the Bank, but is able to “drill down” into specific Business units when required.
Level 3 – Expert – Assumes a business and IT Architecture perspective of IT Applications and is able to identify global leading-edge solutions and innovative IT Applications approaches to meet business requirements. Advises on new versions and modules and is viewed as an industry expert in certain IT Application areas. x
IT PROCESS / WORKFLOW
KNOWLEDGE Level 1 – Awareness – Understands the end-to-end IT Processes required to deliver and support an IT solution in the Bank and the inter-relationships between these processes.
Level 2 – Mature – Demonstrates sufficient understanding of and experience in IT Processes so as to be able to change structures, services, teams and delivery approaches to enhance delivery and support of IT solutions.
Level 3 – Expert – Re-engineers IT processes in line with global best practice and designs new IT Processes, teams and structures to meet the IT needs of the future. x
IT CLIENT INSIGHT Level 1 – Awareness – Understands the clients business and systems from the perspective of their immediate role.
Level 2 – Competent – Demonstrates solid understanding of the clients environment and recommends IT solutions to meet business challenges and objectives. First point of contact to the client.
Level 3 – Reached the status of a strategic business partner through applying significant insight into the clients’ business and market to anticipate and meet the clients IT challenges and needs. x
OLAP KNOWLEDGE Level 1 – Awareness of OLAP and knowledge of how the key activities and players fit together.
Level 2 – Mature – Has knowledge of OLAP and in depth experience. Is able to evaluate specific OLAP guidelines. X
Level 3 – Expert - Regarded as leader in the field of OLAP. Acts as a mentor and guide to others.
IT QUALITY MANAGEMENT Level 1 – Awareness – Implements clearly defined IT Quality Management Solutions in focused business and IT areas. Follows the implementation plan closely with little room for ambiguity and revision.
Level 2 – Mature – Designs and implements a wide range of IT Quality Management Solutions across the full range of IT Process areas and Business Units. Selects IT Quality management approach with a high degree of flexibility depending on the dynamics of the IT project or Production area and continually revises this with time. X
Level 3 – Expert – Designs and implements global best practice and leading edge Quality Management solutions with a bank-wide focus. Proactively contributes to the global pool of knowledge.
ARCHITECTURE KNOWLEDGE Level 1 – Awareness – Understands the concepts underlying the development of the various types of Architectures and their respective components. Utilises well-tested tools and frameworks to develop Architectures that typically apply to contained and clearly defined project, IT process areas or Business unit areas. X
Level 2 – Mature – Applies solid knowledge and experience to the development of Architectures that are complex and typically apply across Business Units, IT Process areas and are not project specific. Utilises new and creative tools and frameworks and extends the perceptions and performance of the Bank to meet long-term and future needs.
Level 3 – Expert – Researches and applies new & leading edge thinking when developing Architectures. Contributes to the global pool of knowledge in the IT Architecture domain.
IT PROGRAMMING EXPERIENCE Level 1 – Awareness – Utilises programming in a limited platform environment using defined methodologies, tools and practises. System functionality is well defined, unchanging and relatively low in complexity.
Level 2 – Mature – Utilises programming languages across a variety of IT platforms in order to develop system functionality that is complex and dynamic. Researches new tools, methodologies and practises and evaluates their introduction into the existing development team’s standards and tool-kit. x
Level 3 – Expert – Specialises in one or more programming languages and is regarded as a Bank and industry leader. Adds new functionality and acts as a teacher and guide to other programmers
CONDUCT OF TESTING Level 1 – Awareness –Understands the Testing Approach and the key steps involved in testing.
Level 2 – Mature – Applies specifically designed Test Approaches to efficient and accurate testing. Attempts to continually question the testing process and proactively involves the necessary stakeholders to resolve issues. x
Level 3 – Expert – Remains up to date with benchmarked testing approaches and methodologies. Designs new and improves on existing testing processes and conventions.
DATABASE KNOWLEDGE Level 1 – Awareness – Demonstrates a high levels understanding of the Technical Architecture and how the database design fits into this. Understands key concepts underlying storage and performance management.
Level 2 – Mature – Has a detailed understanding of the Bank’s database design and how it fits into the overall Technical Architecture. Understands how this design impacts on storage management and performance management capabilities in the Bank. x
Level 3 – Expert – Specialises in Database Management tools, methodologies and best practises. Is able to provide expert knowledge and guidance in developing Database Management strategies and identifies the impact of these strategies on areas such as storage and performance management.
IT PRODUCUTION SUPPORT Level 1 – Awareness – Provides support effectively and timeously to a select group of IT Applications primarily to ensure that they are up and running when required, are delivering the necessary functionality and are accessible to the appropriate profiles and numbers of users, internal or external to the Bank.
Level 2 – Mature – Provides support effectively and timously to a select group of IT Applications, primarily to ensure that they are up and running when required, are delivering the necessary functionality and are accessible to the appropriate profiles and numbers of users, internal or external to the Bank. x
Level 3 – Expert – Specialises in identifying and implementing new and leading edge Production support practises and solutions across a wide range of IT Applications and environments with varying needs. Contributes to the industry pool of knowledge and is regarded as a domain expert.
USER SUPPORT Level 1 – Awareness – Understands the key principles and objectives of User Support and ensures that the required practises, structures and tools are implemented in line with project standards.
Level 2 – Mature – Demonstrates detailed understanding of the principles and objectives of User support and their role in the functionality.
Level 3 – Expert – Specialises in researching, evaluating and implementing global best practice and leading edge thinking in the area of User support. Explores the Introduction of these processes and tools into the Bank. x
INDUSTRY AND IT TRENDS Level 1 – Awareness – Aware of the key IT and Financial Services Industry best practices, latest thinking, trends and IT and Technology related services and products. X
Level 2 – Mature – Demonstrates a solid understanding of a wide range of the latest best practices, thinking trends, services and products as they relate to IT and banking
Level 3 – Expert – Specialises in remaining up to date on all information globally that pertains to the IT and Banking industries.
IT STRATEGY KNOWLEDGE Level 1 – Awareness – Aware of the IT Strategy of one or more Business Units at a high level. X
Level 2 – Mature – Has a detailed understanding of the IT Strategy of one or more Business Units and partners with the business to create and revise this strategy.
Level 3 – Expert – Has an in-depth understanding of the IT Strategy of one or more Business units as well as that of Group IT and Standard bank as a whole. Proactively advises business on the strategy and ensures that it takes into account industry, global and competitor strategies.