Data Analyst - Sandton Verfied

Salary Negotiable Sandton, Gauteng Sandton, Gauteng more than 14 days ago 15-01-2021 10:04:15 AM
12-03-2021 10:04:15 AM
PBT Group has an opportunity for a Data Analyst to source, research and create graphs and reports for the Research team, respond to client requests and ensure all information provided is accurate and current.

DUTIES:

Accurate, timely research:
• Based on internal and external stakeholder requirements, source relevant local and international data
• Know when data becomes available and create a schedule to access it
• Build and expand a network of global contacts who can provide specific information
• Build, maintain and update a database of raw information

Translation of raw data into accurate graphs and reports:
• Check with internal and external stakeholders to ensure their need has been properly communicated and understood
• Based on stakeholders’ specific requirements, manipulate data accordingly, providing data, graph(s) and/or reports per client request
• Maintain a library of templates for the graphs needed on a daily, weekly, monthly, quarterly and/or annual basis
• Update, adapt or generate new graphs as required, using the same format and colours for the different templates
• In migrating graphs from Excel to PowerPoint, create the graph, creating layers of superimposed information as required
• Ensure all information provided to clients is compatible with latest software
• Liaise with stakeholders to ensure information provided meets their needs
• Check internal stakeholders’ diaries to be able to plan ahead to provide graphs and other relevant information for their meetings

Accurate, timely research administration:
• Load finalised GM research onto Standard and Poor’s client intranet
• Send updated information through to specific publications (e.g. Financial Mail) in line with agreed deadlines
• Load clients onto Global Markets database to receive reports
• Provide administrative support to the Research team as required

Stakeholder relationship management:
• Build and maintain professional working relationships with all stakeholders, displaying excellent abilities to initiate dialogue, listen, advise, influence and negotiate to achieve win-win outcomes
• Initiate meetings with key stakeholders to track progress, manage expectations and ensure stakeholders’ requirements are delivered
• Preserves relationships despite airing conflicting views and seeks mutual gains when addressing conflicts
• Anticipates consequences and adapts problem solving based on continual feedback
• Act speedily to resolve problems, queries and complaints
• Adapt communication styles to meet the needs of different audiences

Self-management:
• Demonstrates pride in the organisation’s brand, services and products by consistently delivering on the brands promise
• Plan and manage own workflow, anticipating obstacles, juggling priorities and following through on objectives within agreed time-frames and according to quality standards
• Stay relevant and up-to-date with legislations and new development
• Maintain a positive attitude and respond openly to feedback
• Handle stress in ways that do not negatively impact others
• Take ownership of personal career development, leveraging formal and informal opportunities
• Act in an ethical, transparent and morally defensible manner, including highlighting unethical practices

Teamwork:
• Continually share, debate and communicate learning’s
• Flag and debate issues constructively
• Contribute to a friendly, co-operative climate in working with others to achieve collective goals
• Be sensitive to others’ feelings, needs, values, views and attitudes and be courteous and diplomatic when dealing with difficulties and problems others may be experiencing (EQ)

EXPERIENCE:
• 5+ yrs. exp in the BI Analyst Role
• Needs to be able to read and write SQL. Troubleshoot as well.
• Apply business analysis best-practices, consistent with the BABOK principles and standards.
• Support continuous improvement by identifying and solving opportunities.
• Experience with Business Intelligence tools such as Microsoft Business Intelligence, Business Objects etc.
• Experience with Data Visualization tools such as Microsoft PowerBI.
• Excellent communication, interpersonal and problem solving skills, including the ability to translate business requirements effectively.
• Perform root cause analysis with stakeholders, conduct interviews or workshops to further evaluate and identify solutions to meet business requirements.
• Assist with production issues within a given timeframe.
• Coordinate and participate in the test effort to ensure that the delivered solution meets agreed business requirements and functional/process specifications.
• Ensure all the business requirements and relevant documents are well documented.
• Assist the Lead by investigating, estimating and calculating costs and timelines for enhancements and projects.
• Very good written and verbal communication skills
• Team player, driven to succeed and transparent
• Be able to maintain the environment and provide support where required
• 3+ years’ research experience in a financial service and/or Treasury environment with exposure to specific products and asset classes
• Flexible and comfortable with change
• High learning agility
• Sound self-management and organisational skills

TECHNICAL PRE-REQUISITE
• Basic economics knowledge
• General knowledge of current affairs
• Understanding of economic research engines (Reuters, Bloombergs, I-net Bridge)
• Knowledge of the Microsoft Office suite (particularly Word, Publisher, Excel and Powerpoint)
• Basic macroeconomic knowledge
• Basic knowledge of relevant products
• Basic knowledge of relevant asset classes
• Basic knowledge of company and sector specifics
• Internal systems, processes, policies, procedures and workflows
• Work templates, models and methodologies, including reporting templates

COMPETENCIES:

Analysis and Attention to Detail
• Able to apply specific analytical concepts and techniques within agreed structures
• Produces quality by ensuring accuracy and integrity of information
• Applies systematic thinking to diagnose root causes
• Evaluates existing practices for accuracy and compliance
• Can provide guidance and coaching on analysis to others

Problem Solving
• Accumulates the right information to solve problems
• Uses decision-tree logic to diagnose root causes
• Reflects on what is occurring to identify potential problems and obstacles
• Uses judgement and discretion to interpret issues based on learnt theory
• Solves problems with an awareness of the bigger picture; can see beyond immediate issues to anticipate consequences

Excellence Orientation
• Uses discretion and informed judgement to diagnose what enables or disables quality performance (own and/or team)
• Monitors own and other’s work to identify and correct errors
• Pays attention to consistency of own and other’s work
• Motivates team members to take accountability for quality
• Guides others to improve the quality of their work

Drive for Results
• Consistently meets deadlines without compromising quality
• Able to implement solutions and deal with stumbling blocks; stays positive
• Sets and meets challenging goals (self and team)
• Focuses on what is important; does not get distracted
• Takes immediate action when confronted with a problem

Building Relationships
• Builds relationships based on warmth and understanding of stakeholders’ needs and requirements
• Displays patience and tact in dealing with difficult people and situations
• Displays sound analysis and logic in probing, analysing and resolving interpersonal issues
• Follows through on promises
• Uses influence to build and maintain good working relationships

Customer Service Orientation
• Displays a sound understanding of customers' operational needs and requirements
• Displays sound analysis and logic in probing, analysing and resolving customers' needs
• Follows through on promises to clients
• Uses influence to encourage others to provide excellent customer service as a team
• Consistently models appropriate customer behaviour

Verbal and Written Communication
• Able to communicate complex specialist knowledge and concepts clearly
• Delivers messages in ways that gain support and agreement
• Can communicate sensitive messages tactfully
• Knows which communication medium is most appropriate for the message
• Communicates with the recipient's perspective in mind

Research Competence
• Gathers information from multiple credible sources
• Shows awareness of metrics associated with the credibility of sources
• Identifies information that is relevant to a specific question or problem
• Networks with key individuals and bodies to gather up-to-date information, sometimes before results are published
• Regularly revises his/her understanding of key research findings and trends

Environmental Scanning
• Continually accesses documentation, reports, research and other sources of information that are relevant to own discipline
• Reads widely to gather information from diverse sources
• Analyses data and information relevant to own industry, organisation or discipline to gain insight into current and future trends
• Understands the impact that current trends may have on the organisation, discipline or industry
• Understands how different categories of information fit together

Planning and Organising
• Plans and communicates other’s roles and responsibilities clearly
• Consistent and systematic in assigning and measuring work
• Uses discretion to resolve problems within agreed mandate
• Gives consistent feedback to others
• Makes contingency plans for possible changing priorities

QUALIFICATIONS/ CERTIFICATION:
• Relevant degree / diploma