MIS Analyst
Johannesburg, Gauteng, ZA
Who are we?
Sanlam Developing Markets [SDM] (a wholly-owned subsidiary of Sanlam Life Limited) is one of the top financial services providers in the South African entry-level and emerging middle market. It aims to understand the unique requirements of clients and offers a wide range of simple and affordable financial solutions that cover needs such as funeral insurance, savings for education, life cover and personal accident plans. In terms of the Sanlam Group Governance Policy, SDM is managed by the SA Retail Mass cluster, which is part of the Sanlam Life and Savings cluster within the Sanlam Group. The cluster focusses on retail products, as well as group schemes.
What will you do?
This role will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end users to develop differentiating business insights. They will assist in specifying complex business rules using specified toolsets to enable the data modellers to create complex analytical models. Analyses data models, tests outputs and investigates and troubleshoots data issues, devising solutions in line with best practice. Communicates business information to the technical teams and. provides daily, weekly and monthly MIS reports/dashboards. Duties include compiling and presenting divisional and functional reports, interpreting data trends and patterns. Ensures month end runs are accurate and timeous, support clients with regard to ad-hoc reports and queries. The incumbent has a complete and clear understanding of the database. Responsibilities include the co-ordination and management of changes to the MIS database, the streamlining of MIS reports and processes across the business. Provides problem-solving assistance to other team members. Coaches and mentors junior team members.
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
- Ensure that the business requirements and subsequent development activities are supported by accurate information.
Analysis and Visualisation
- Create reports/dashboards using Microsoft BI stack.
- 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.
- 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.)
- Documenting processes
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
What will make you successful in this role?
Qualifications and Experience
- Bachelor’s degree (Informatics/Computer science/engineering) or equivalent (will consider candidates in 2nd year of Studies)
- 2 - 3 years of experience performing data analytics
- Experience working with data in various data sources and databases
- Practical experience in analytics, data modelling and data profiling
- Experience in financial services an advantage
- Experience working in an agile environment
Knowledge and Skills
- Strong knowledge of and experience with tools SSRS, SSAS, Power BI, SSMS (T-SQL)
- Strong analytical-thinking and problem-solving abilities
- Excellent written and verbal communication skills
- Strong analytical skills with the ability to collect, organize, analyse, and disseminate significant amounts of information with attention to detail and accuracy
- Demonstrated experience in handling large data sets and relational databases.
Competencies
- Communication skills
- Accountability
- Analytical thinking
- Innovative thinking
- Building and maintaining relationships
- Results driven
- Team success
- Adaptability
- Excellent attention to detail
Personal Attributes
Build a successful career with us
We’re all about building strong, lasting relationships with our employees. We know that you have hopes for your future – your career, your personal development and of achieving great things. We pride ourselves in helping our employees to realise their worth. Through its five business clusters – Sanlam Fintech, Sanlam Life and Savings, Sanlam Investment Group, Sanlam Allianz, Santam, as well as MiWay and the Group Office – the group provides many opportunities for growth and development.
Core Competencies
Turnaround time
The shortlisting process will only start once the application due date has been reached. The time taken to complete this process will depend on how far you progress and the availability of managers.
Our commitment to transformation
The Sanlam Group is committed to achieving transformation and embraces diversity. This commitment is what drives us to achieve a diverse, inclusive and equitable workplace as we believe that these are key components to ensuring a thriving and sustainable business in South Africa. The Group's Employment Equity plan and targets will be considered as part of the selection process.