Senior Business Intelligence Analyst at Sanlam Group

What you will do:

The successful candidate will join the organisation in the role of a Senior BI Analyst. He/she will be part of a highly dynamic and analytical team working in an agile environment. Guided by a BI Technical Lead and Business Analyst, this role will be responsible for sourcing and transforming a wide range of data across our business into formats that can be used by analysts and end-users to develop differentiating business insights.

They will assist in specifying analytical modules using the specified toolsets to enable the analytical teams and businesses to create and analyse complex analytical models. Hence, they need to understand and continuously seek to build knowledge of data and information. In addition, they should be able to use the technology and seek to make use of the features therein to deliver value to the business.

The person fulfilling this role will not only analyse and design data models but also required to investigate data issues, troubleshoot data issues and devise solutions in line with best practice - High competency in problem-solving capabilities is therefore essential. They should be able to communicate business information to technical teams, as well as be competent in communicating challenges and solutions to project and operational leadership.

An understanding of data management solutions and a keen sense of the strategic value of information to an organisation will be of importance. It is essential that the candidate exhibit and maintain a positive attitude in a highly agile technical and business environment where information forms the foundation to gain a competitive edge in the market.

What will make you successful in this role:
The following are the key outcomes expected from this position:

• Analyse business requirements from documents and end-user discussions
• Identify and define the data requirements necessary to support business requirements or integrated application and subject areas.
• Identify and define the security requirements necessary to protect the data items.
• Identify and define the business rules associated with the data; these should include all data integrity/constraint requirements.
• Identify and perform a detailed analysis of all data sources for each application and subject area.
• Perform data profiling of data contained in source systems.
• Provide a detailed analysis of all data implemented in 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.
• 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 to draw up detailed data models.
• Assist ETL Analysts to draw up data cleansing specifications.
• Present data quality anomalies and problem areas to business users and source system owners.
• Validate data models against the business- and data requirements.
• Ensure the quality, accuracy, integrity, and conformity to standards of all models.
• Provide accurate metadata, which allows a full understanding of the project data components.
• Identify data and data model inconsistencies and conflicts and assist the users in their resolution.
• Transition information and assist developers with the data mapping and transformation and provide additional data analysis as required during the development phase.
• Communicate project data-related information to Architects, DBA’s, Developers and Users.
   

The following areas of expertise are key to the successful delivery of the above outcomes:

• You have a strong data modeling background with the ability to interpret business requirements and analyse source system data and then to document transformation rules for developers to interpret to build the required data models.
• A solid background in SQL, information architecture and ETL procedures is required.
• Experience working on SAP Hana and/or Hadoop is preferred and highly advantageous.
• Data warehousing principles based on Kimball and Data Vault patterns
• Analysis experience in BI
• Agile Development
• Knowledge of data profiling and data profiling tools.
• Experience with data quality management strategies and life cycles.
• Ability to comply to and manage reusable data assets under a governance framework
• Solid SQL skills
• Ability to work with data profiling, data quality, and reference data toolsets.
• Ability to do effort estimations
   

The complexity and variety of the most common challenges and problems:

• Delivering in a complex analytic environment
• Working with a high need for information security
• The diligence required when resolving data and technical issues and interacting with other support teams.
• Demanding business community
  
   

Qualifications
Qualification & Experience

• Degree/diploma/certificate in Information Technology related discipline.
• Matric.
   

Experience

• 4+ years' experience as a data analyst in a BI environment.
• A solid background in SQL and information architecture and ETL procedures is required.
• Experience working on SAP Hana, Teradata as well as Hadoop is preferred and highly advantageous.
• Understanding of Data warehousing principles based on Kimball and Data Vault patterns is preferred.
   

Knowledge And Skills

• Data Analysis and MIS reporting
• Business analysis
• Data Mining
• Information Reporting
• System Documentation