Subscribe to Job Alert
Join our happy subscribers
Never pay for any CBT, test or assessment as part of any recruitment process. When in doubt, contact us
Since our establishment in 1918, Sanlam has been a prominent part of the South African business landscape. We have always held a long-term view of how business adapts to the demands of the environment in which it operates. Today, in a dynamic world, we see an evolving set of social, economic, political and environmental imperatives that require our skilfu...
Read more about this company
JOB DESCRIPTION
Guided by the BCM and a prioritised backlog, this role will be responsible for assisting in the impact and data dependency analysis between data sources within the BI environment. This role will also play a crucial role in the Data Warehouse decommissioning initiative as well as in the cloud migration preparation phase where data analysis work is key.
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. Thy 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 INCLUDE:
Data Preparation
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.
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 relationships
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
Engage with role-players within our implementation of Scrum @ Scale
Coaching/Mentorship
Provides problem solving assistance to other team members
QUALIFICATIONS AND EXPERIENCE
Diploma/Bachelor Degree (Information Systems; Statistics; Data or Computer Science; Engineering) or equivalent (preferred but not essential)
Functional experience in analytics, data visualisation or reporting
4 + years of experience performing data analysis
Knowledge of and experience with reporting packages (QlikView/ Business Objects/ Cognos)
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
COMPETENCIES
Collaboration
Client focus
Drives results
Flexibility and adaptability
Cultivates innovation
Decision Quality
Communicates Effectively
Ensures Accountability
Business Insight
Balances Stakeholders
Manages Ambiguity
Nimble Learning
Build your CV for free. Download in different templates.
Join our happy subscribers