Data and Solutions Architect 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?

• Create and design data and information asset management framework,Manage and own data strategy and architecture for Business Transformation/BI. Create data architecture and data model design,manage the integration of data assets from ingestion into consumption layer and overlaying data governance.Develop, implement and manage the processes and mechanisms for classifying data and information assets in terms of its purpose, sensitivity and quality as well as the level of accCreate and design data and information asset management framework,Manage and own data strategy and architecture for Business Transformation/BI. Create data architecture and data model design,manage the integration of data assets from ingestion into consumption layer and overlaying data governance. Develop, implement and manage the processes and mechanisms for classifying data and information assets in terms of its purpose, sensitivity and quality as well as the level of access control and protection applicable to it. Create/Maintain reference data and master data design. Develop, implement and manage the processes to assess data quality and diagnose and report issues for correction. Using data profiling, data quality monitoring & reporting tools, measure completeness, timeliness, accuracy, consistency, relevance and integrity and ensuring data is fit for its intended uses on the BI platform. Develop, implement and manage the processes for reference data on the BI platform as a special subset of master data that's used for classification throughout the organisation. This includes reference data that is externally mandated or internally authored. This includes process design and tooling discussions.Metadata associated with the data on the BI platform. Develop and implement the end-to-end governance framework and model for creating, controlling and enhancing metadata on the BI platform, manage the processes that track the life-cycle of data on the BI platform from ingestion through to consumption as well as how it changes over time (Data lineage tracking is required for master data, reference data, transactional data and metadata on the BI platform.) Develop physical data management architectures, policies and practices and oversee the execution of procedures to manage data across its lifecycle on the BI platform from acquisition to consumption.Design conceptual, logical, technical solutions and flowcharts for BI assets and Business Transformation solutions.Install and configure information systems to ensure functionality, Migrate data from legacy systems to new solutions, conducting tests, troubleshooting and integrating new elements. Coordinate with clients, data users and key stakeholders and develop and achieve various long term objectives for data architecture. Define security and backup procedures. Determine procedure to identify and collect all required data, validate process and recommend improvements to business data,Oversee and monitor all frameworks to manage data across transformation.Design and provide support to all data management methodologies according to required standards.Monitor and identify appropriate tools and systems. Administer mapping of all data sources and movement and analyse it to ensure appropriate quality of all data.Develop key metrics for tests on data and ensure integrity of same on data architecture. Prepare documents for data architecture and maintain knowledge on large data structure as well.Analyse and understand BI technology stack and entire solution, integration into enterprise architecture, business requirements and create conceptual, logical and technical solution designs. Create solution prototypes,create integration of the data assets into the larger BI solution,participate in design and architecture forums to create alignment with Group.

What will make you successful in this role?

• Relevant Data system experience in warehousing, ETL, Reporting, Management Reporting, Business Intelligence implementations, migrations and technology selection 
• Relevant experience delivering business solutions using applicable technology 
• Understanding of data flow from a technical and business perspective from source to output though Information management systems such as Data Warehouses and Data transformation hubs 
• Understanding of Information Architecture domain (e,g DAMA / DMBOK) 
• Understanding of enterprise implications of data policy as it relates to other policy domains: Security, Regulatory, Legal, Tax and Channel conflict 
• Experience in warehousing, ETL, Reporting, Management Reporting, Business Intelligence implementations, migrations and technology selection 
• Experience with Cloudera, HANA, Teradata would be preferential 
• Demonstrated competence in business domain analysis, data warehousing (design and operations), and database design 
• Demonstrated competence with benefits, design and management of structured and unstructured content and databases / repositories (SQL, NoSQL, HDFS/Hadoop distributions, etc.) and hands-on experience with specific products 
• Demonstrated competence with Microsoft SQL Server, Oracle DBMS, SAP Business Objects, and related tools is valued 
• Working knowledge and understanding of benefits and positioning of data virtualization 
• Working knowledge of data science, data mining, OLAP programming, database management and programming, business process modelling and analysis 
• Working knowledge of statistical computing and graphics programming languages (R, Python, etc.) 
• Working knowledge of open source or commercial data visualization tools (PowerBI, BobJ, Tableau, Qlikview) 
• Working knowledge of cloud-based offerings and vendor differentiation related to analytics and information processing capabilities (AWS, Azure)
• Proven work experience as a Data Architect, Data Scientist, Data Analyst or similar role
• In-depth understanding of database structure principles
• Experience gathering and analysing system requirements
• Knowledge of data mining and segmentation techniques
• Expertise in SQL, Cloudera, Cloud and SAP HANA
• Proficiency in MS Excel
• Familiarity with data visualization tools (e.g. Power BI, Python and R)
• Proven analytical skills
• Problem-solving attitude
• BSc in Computer Science or relevant field
• Database Design
• Data Maintenance, Database Security, Database Management
• Requirements Analysis
• Teamwork
• Project Management
• Presenting Technical Information
• Cloud Development
• Solution Architecture Design
• Business Analysis
• DevOps
• Project Management

Qualification and Experience

• Degree or Diploma with 8 to 10 years related experience.

Knowledge and Skills

• Data Analysis
• Project Management
• Business Requirements Definition
• New Technology Research
• Reporting and Administration

Personal Attributes

• Interpersonal savvy - Contributing through others
• Decision quality - Contributing through others
• Optimises work processes - Contributing through others
• Plans and aligns - Contributing through others

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 business clusters – Sanlam Personal Finance, Sanlam Emerging Markets, Sanlam Investments, Sanlam Corporate, Santam, Miway, as well as the Group Office – the group provides many opportunities for growth and development.

Core Competencies

• Being resilient - Contributing through others
• Collaborates - Contributing through others
• Cultivates innovation - Contributing through others
• Customer focus - Contributing through others
• Drives results - Contributing through others

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 ensure 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.