Sanlam Careers – Data Analyst

Job Description:

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.

Job Responsibilities:

• 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
• 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.
• Own and maintain dashboards, ongoing reporting, and ad hoc requests from the organization.
• 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.
• 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
• 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.

Job Requirements:

• 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
• 5 years of experience performing data analysis
• 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 would be advantageous
• Ability to work with data profiling, data quality and reference data toolsets
• 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
• Degree or Diploma with 10 to 12 years related experience.
• Profile source data and determine all source data and metadata characteristics
• Advanced analytics to address business requirements
• Vendor Management
• Data Warehouse Modeling
• Statistical analysis and data

Job Details:

Company: Sanlam

Vacancy Type:  Full Time

Job Location: Cape Town

Application Deadline: N/A

Apply Here

jobstrivia.xyz