BI Business Analyst at Sanlam Group

Who we are?

Sanlam Investments Group is one of South Africa’s largest investment management companies. We have a performance history spanning over 100 years, and offer a range of investment and financial planning solutions to protect and grow the long-term wealth of our clients.

We take particular pride in:

• Sanlam’s longevity and innovation
• People, teamwork and values
• A culture of diversity and commitment to growing our own timber
• Our robust, tested and proven pragmatic investment process and philosophy

Our local and offshore investment products cover the full investment spectrum: active and passive; single and multi-manager – both locally and internationally. Our active funds range are managed according to our pragmatic value investing style.

What will you do?

• Guided by Lead Analysts, 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.
• 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 specifying complex business rules using the specified toolsets to enable the data modelers to create complex analytical models. Hence, they need to understand and continuously seek to build knowledge of data and information. 
• 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. They should be able to communicate business information to technical teams, as well as 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.
• A unique opportunity to complement a small, high performance team in supporting Business Intelligence (BI) solutions for Sanlam’s Investment business. Support will be provided through data and systems analysis (incl. data issue investigation), required to deliver various business BI support requirements. 
• Key experience and knowledge capabilities required to successfully fulfill the role include translating business requirements into detailed technical requirements, advanced data management proficiency and systems analysis. 
• The Systems / Data analyst will translate the business analyst's requirements into actionable technical requirements required to support data assets.

What will make you successful in this role?

• 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
• 2-5 years of experience performing data /systems /information  analysis in a BI environment
• 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
• Ability to translate business requirements into non-technical terms
• Demonstrated experience in handling large data sets and relational databases with proven SQL skills
• Ability to comply to and manage data assets under strict governance framework
• Experience in agile development desired
• Business experience in financial services or financial asset management will be advantageous
• Ability to work with data profiling, data quality and reference data toolsets advantageous
• Knowledge of various toolsets such as SAP Hana Studio, SAP Data Services, Informatica Data Quality Suite, Cloudera big data storage and Microsoft Power BI will be advantageous.
• Proficiency in MS Excel

Qualification and Experience

• Degree or Diploma with 2 to 4 years related experience

Knowledge and Skills

• Business and Data Analysis
• Project Management
• Business processes and management of budget
• Project and resource management
• Business Processes and business requirements definition