BI Data Analyst at Santam Insurance

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