What will you do?

 

An exciting career opportunity exists for a Data Analyst to perform a new and critical role within our Client Care department, reporting to the Head of Client Care. This role is based at our Head Office in Cape Town. 

 

This role will be responsible for assisting in the impact and data dependency analysis between data sources within the various business units. This role will also play a crucial role in trends analysis, monthly and quarterly reporting.  Additional responsibilities will include sourcing and transforming a wide range of data across the business into formats that can be used by end users or reporting systems. We are looking for an individual with experience in using a variety of data tools, analysis methods and data visualization to turn data into actionable insights with demonstrable business impact. They will assist in unpacking and analysing data structures in existing databases and ETL processes using SQL, Business Objects and QlikView. The person fulfilling this role will not only analyse data models, but also test the outputs, investigate & troubleshoot data issues and devise solutions in line with best practice. A high competency in problem solving capabilities is thus essential and proven proficiency in SQL is a must. They should be able to communicate technical information to business teams as well as to communicate business information to technical teams. They should also be competent in communicating challenges and solutions to the team. An understanding of data management solutions and a keen sense of the strategic value of information to an organisation will be of importance. You will be responsible for the end-to-end tasks within the data analysis framework working with business representatives, product owners, etc. to define and elicit requirements, analyse data and create reports/dashboards. 

Principle Accountabilities

 

Data Preparation Ability to manage own workload and timelines Provide support and collaborate with project management, change management, training, design, development and testing competencies Comply with company policies and procedures, standards and methodologies Acquire data from various data sources and combine & transform data into interpretable datasets, reports or dashboards Assess the effectiveness and accuracy of new data sources and data gathering techniques Extend the company’s data with third party sources of information when required Process, cleanse and verify the integrity of data used for analysis Perform data profiling of data contained in source systems Provide detailed analysis of all data implemented into the database Provide the data mapping and associated transformation rules for each data item Ensure that the business requirements and subsequent development activities are supported by accurate information.  What will make you successful in this role?

 

Analysis and Visualisation

Interpret data, analyse results using analytical techniques and provide reports and/or dashboards Identify, analyse, and interpret trends or patterns in complex data sets Use data to answer key questions about the business. Create and maintain dashboards, ongoing reporting, and ad hoc requests from the BCM in measuring data quality and data usage. Support and maintain the project data models at multiple levels of detail and functionality (conceptual, logical, normalised, relational, dimensional, application level, subject-level, integrated, etc.) Assist Data Modelers/Architects to draw up detailed data models.

 

Stakeholder Engagement

Work directly with management and other business users to gather requirements, provide status updates, and build relationship Present information using data visualisation techniques  Facilitate requirements gathering workshops with the business  Collaborate with internal and external stakeholders to analyse information needs, functional requirements and business processes 

 

Coaching/Mentorship 

Provides problem solving assistance to other team members  Qualification and Experience

 

Relevant Tertiary qualification or certificate/diploma in Business Analysis from an industry recognized training institution Functional experience in analytics, data visualisation or reporting  1-2 years of experience performing data analysis  Knowledge of and experience with reporting packages  Adept at queries, report writing and presenting findings for stakeholder use  Experience working with data in various data sources and databases  Demonstrated experience in handling large data sets and relational databases with proven SQL skills  Experience in agile development desired  Business experience in financial services would be advantageous  Skills

 

Ability to translate business requirements into non-technical terms  Ability to comply to and manage data assets under strict governance framework  Ability to work with data profiling, data quality and reference data toolsets advantageous  Strong analytical-thinking and problem-solving skills  Ability to collect, organize, analyze, and disseminate significant amounts of information  Attention to detail and accuracy  Decision Quality  Communicates Effectively  Ensures Accountability  Business Insight  Balances Stakeholders  Manages Ambiguity  Core Competencies Being resilient - Contributing dependentlyCustomer focus - Contributing dependentlyCollaborates - Contributing dependentlyCultivates innovation - Contributing dependentlyDrives results - Contributing dependently