- Existing MIS databases.
- Existing reports and dashboards.
- Existing data warehouses.
- Collaborate with Project Managers and Business Leaders to deliver quality, effective management information, data warehouse and business intelligence applications, in line with the agreed development process and business needs.
- Collaborate with stakeholders to gather requirements, conduct analysis and prioritise requests.
- Conduct research and evaluate potential technical solutions to identified business problems.
- Translate business requirements into workable solutions and document solutions into technical specifications, partnering with Business and/or System Analysts when required.
- Design and code new database and analytics functionality using code that is readable, maintainable and reusable.
- Conduct Unit Testing of own code and resolve all issues/queries timeously.
- Contribute to user acceptance testing (UAT) to ensure that functionality is working correctly.
- Deliver solutions into the applicable production environment once testing has been completed.
- Provide stakeholders with regular feedback on the technical design and timelines for solution ensuring that business needs are met.
- Maintain existing databases and applications according to change requests approved by business as and when needed.
- Diagnose root causes of issues through problem-solving and recommend potential solutions.
- Monitor performance of solutions and make recommendations to improve the performance and functionality of the solutions, where appropriate.
- Log issues found in existing systems as internal change controls and ensure successful resolution of issues.
- Contribute to the overall data warehouse architecture and data base designs.
- Maintain and oversee the administration and maintenance of the data warehouse.
- Develop and maintain Business Intelligence and reporting technologies and processes.
- Translate stakeholder requirements into technical specifications for Business Intelligence (BI) reports and applications.
- Design and develop reports and dashboards based on Business Requirements Document (BRD) and customer specifications.
- Develop feasible technical specifications and process flows for data provision activities in support of the development of business intelligence solutions.
- Ensure the continued maintenance and enhancement to existing business intelligence solutions.
- Within user specifications extract, transform and load (ELT) data using the relevant tools.
- Verify and quality assure of data provided.
- Provide support to business intelligence users on data-related issues.
- Conduct research and undergo training where appropriate, in order to remain abreast of data enablement trends and understand their application in the short-term insurance industry
- Assist management and colleagues to make the right decisions in terms of planning future data enablement infrastructure, architecture and applications in the company short-term insurance business, in alignment with the companys standards and the South African financial services regulatory framework.
- Provide authoritative expertise and advice to colleagues.
- Develop and maintain productive and collaborative working relationships with peers and team members.
- Deliver on Service Level Agreements made with colleagues.
- Continuously develop own expertise in terms of industry and subject matter development and application thereof in an area of specialisation.
- Participate and contribute to a culture of work-centric thinking, productivity, service delivery and quality management.
- Contribute to continuous innovation through the development, sharing and implementation of new ideas and involvement of peers.
- Take ownership for driving career development.
- Manage financial and other company resources under your control with due respect.
- Business Acumen.
- Client / Stakeholder Commitment.
- Drive for Results.
- Leads Change and Innovation.
- Motivating and Inspiring Team.
- Collaboration.
- Impact and Influence.
- Self-Awareness and Insight.
- Diversity and Inclusiveness.
- Growing Talent.
- Communication articulating information and challenging ideas.
- Analysing and interpreting data.
- Problem-solving.
- Planning and organising time and task management.
- Relevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) - Essential.
- Dimensional modelling and/or relevant Microsoft certification - Advantageous.
- On- the-job training/qualifications:
- Microsoft Sql Server.
- Oracle.
- Power BI.
- Advanced MS Excel.
- Starquest.
- Python.
- Scala.
- Spark.
- AWS Sagemaker.
- Azure SQL elastic instance.
- Data factory.
- PowerBI.
- AWS RDS.
- Methodologies
- The candidate must have ability to elicit data requirements from stakeholders.
- The candidate must have clear documentation skills.
- The candidate must be familiar with design patterns in the data development industry.
- The candidate must have a solid understanding of Metadata constructs.
- The candidate must have clear understanding of EDW.
- Knowledge of Domain driven design would be an advantage.
- The candidate must be familiar with the concept of Data Marts.
- The candidate must be familiar with abstraction techniques.
- The candidate must have proven data modelling techniques (3 years).
- The candidate must have knowledge and experience in Ralph Kimball data warehouse modelling (3 years).
- Knowledge of Immon data warehouse modelling techniques would add an advantage.
- The candidate must have data normalization skills most especially the 2nd Normal form.
- The candidate must have solid experience of ETL systems.
- The candidate must have solid experience of sourcing, staging and loading.
- The candidate must be familiar with parallel loading principles.
- The candidate must be familiar with source to target mapping.
- The candidate must have advanced knowledge of T-SQL (4 years) and the following concepts.
- Dynamic T-SQL.
- Multi-threading.
- Performance optimisation and tuning.
- The candidate must have practical experience of SQL Server Database Engine (4 years).
- The candidate must have practical experience of MS SSIS ETL software (4 years).
- The candidate must have practical experience of MS SSAS OLAP software (4 years).
- The candidate must have practical experience of MS Visual Studio Data Tools (4 years).
- Knowledge of Database Administration would add an advantage.
- Expert knowledge in configuration of database hardware resources.
- The candidate must be able to source data from different repositories.
- The candidate must be fully acquainted with Microsoft SQL Server repository.
- Knowledge of Data Lake would be an advantage.
- Knowledge of Oracle would be an advantage.
- Knowledge of Hadoop is not essential but will also be an advantage.
-
IT Manager
Found in: Talent ZA C2 - 6 days ago
Recruitment Matters Centurion, South Africa Full timeOur client is seeking an IT Manager to join their team. The purpose of this role is to direct, plan, coordinate and oversee the implementation of technology solutions delivered by cross- functional teams, in alignment with business objectives and operational requirements, ensurin ...
-
BI Analyst – Design
Found in: Talent ZA C2 - 4 days ago
Acuity Consultants Johannesburg, South Africa Permanent, Full timeJob Description · This is an amazing opportunity for a senior BI/MI Analyst to optimise & advise on system processes and design business solutions, driving long-term decision-making processes for South Africa's leading financial services company. · This BI Analyst role is Johann ...
-
Service Delivery Manager
Found in: Talent ZA C2 - 1 day ago
DSV Kempton Park, South AfricaTime Type: · Full time Minimum Requirements · Grade 12 · Advanced Computer literacy level in MS Word, Excel, PowerPoint and Outlook · WMS (Blue Yonder) will be huge advantage/ Warehouse Control System (Automation)/ FMS – TMS/ Integration · Job Related Requirements · Minimum of 3y ...
-
Data Specialist
Found in: Talent ZA C2 - 5 days ago
Experian Sandton, South Africa Full timeJob Description · We seek a highly skilled Data Specialist to join our CDS Team. The role requires a deep understanding of data pipelines and the ability to create them using our in-house developed data framework, built and maintained in Python. This technical position requires ...
-
BI Big Data Engineer – Johannesburg – up to R950k per annum
Found in: Executive Placements ZA C2 - 4 days ago
E-Merge Johannesburg, South AfricaAn expert in integrated corporate benefits well known for outstanding usability and integration within the banking space is looking for a specialist capable of working within the capacity of a BI Big Data Engineer who will be responsible for building and maintaining data pipeline ...
-
Technology/Domain Specialist
Found in: Executive Placements ZA C2 - 2 days ago
HR Genie Sandton, South AfricaOur Client a Global Tech firm is seeking a Technology Domain Specialist to join their team in Sandton on a contract basis. They offer stability, growth, attractive rates and a great working environment. · We are looking for an individual to lead the design and architecture of lar ...
-
Senior Manager – Business Intelligence and Collaboration
Found in: Talent ZA C2 - 5 days ago
IT Ridge Technologies Johannesburg, South Africa Full timeThe main purpose of this position is to provide leadership in ensuring the effective delivery of information through new and existing business intelligence (BI) and collaboration solutions in support of the group's information technology (IT) strategy. · Detailed description · De ...
-
Raw Material Controller
Found in: Job Placements ZA C2 - 1 day ago
HR Genie Kempton Park, South AfricaRaw Materials Controller Operations Accountable for specialist outputs, as well as initiating quality standards within defined work routines and policies. Job Purpose To control the raw material warehousing operation and contract packaging requirements. Key Accountabilities and O ...
-
Raw Materials Controller
Found in: Job Placements ZA C2 - 5 days ago
HR Genie Ekurhuleni, South AfricaRaw Materials Controller (Fixed Term Contract) · Operations · Accountable for specialist outputs, as well as initiating quality standards within defined work routines and policies. · Job Purpose · To control the raw material warehousing operation and contract packaging require ...
-
Principal Specialist BI Architecture
Found in: Executive Placements ZA C2 - 2 days ago
HR Genie Randburg, South AfricaOur Client a Global tech firm is seeking a Principal Specialist BI Architecture to join their team in Randburg on a contract basis. They offer stability, growth, attractive rates and a great working environment. · Candidates will be working fully onsite and need to be fully vacci ...
-
General Manager: Outbound
Found in: Talent ZA C2 - 2 days ago
Buffalo International Logistics Johannesburg, South Africa Full timeREQUIREMENTS · Matric · Diploma/Degree in Logistics, Operations, Supply Chain or Related · + 15 years in Logistics · + 8 years of experience in a management/ executive role · Project management approach · Experience of large-scale people management and skill development · Experie ...
-
Data Warehouse and Analytics Specialist
Found in: Talent ZA 2A C2 - 5 days ago
TalentCru Johannesburg, South AfricaAre you a seasoned IT professional with a flair for cutting-edge technologies and a proven track record in solving intricate integration challenges? We have an outstanding opportunity for you as an Enterprise System Specialist with our distinguished client—a leading entity in the ...
-
Enterprise System Specialist
Found in: Talent ZA 2A C2 - 5 days ago
TalentCru Johannesburg, South AfricaA leading workforce solutions company, driven to grow people, businesses and economies through connections that allow them to realize their potential has an exciting opportunity for an Enterprise System Specialist in Gauteng. · To assist with System implementation and functional ...
-
Enterprise Applications Senior Manager
Found in: Talent ZA C2 - 6 days ago
KPMG-SouthAfrica Johannesburg, South AfricaPosition title: Enterprise Applications Senior Manager · Division: Information Technology Services · Location: Johannesburg · Reports to: Chief Information Officer · Background: · The Information Technology Services Business Unit of KPMG SA is responsible for providing specialis ...
-
Enterprise Applications Senior Manager
Found in: Talent ZA C2 - 4 days ago
KPMG-SouthAfrica Johannesburg, South AfricaPosition Description · KPMG South Africa · Position title: Enterprise Applications Manager · Division: Information Technology Services · Location: Johannesburg · Reports to: Chief Information Officer · Date: November 2021 · Background: · The Information Technology Services Busin ...
Data Warehousing Specialist - centurion, Gauteng, South Africa - The Recruitment Council
Found in: Executive Placements ZA C2 - 5 days ago
Description
Join a leading Financial Services firm in their quest for excellence Are you a skilled Data Warehousing Specialist seeking an exciting opportunity to make a significant impact? Our client, a prominent player in the financial industry, is actively seeking a talented professional like yourself to join their dynamic team. You will need to establish and lead a world class data analytics/warehouse capability for the company to enable future needs for advanced analytics and AI.
Maintain and support:
Develop, test, deploy, maintain and support new databases, and reporting, data warehouse and business intelligence applications from high-level business requirements and designs, through the Software Development Life Cycle.
Remain informed about developments and trends in the data enablement field to assist the business to keep its data analytics and management capability up-to-date, and able to meet the future needs of the business in a constantly maturing and increasingly complex short-term insurance industry.
Outputs:
Internal Process:
Responsibilities:
Develop, implement and document Business Intelligence Solutions (Internal Process):
Future development and planning:
Self-management and Teamwork:
Finance:
Competencies:
Skills:
Experience and Qualifications:
Some experience in predictive analytic platforms will be advantageous. These include:
Some experience in Azure / AWS platform services will be advantageous. These include:
Experience:
Principles:
Modelling:
Data Transportation:
Development Software:
Repository type: