Data Warehousing Specialist

4 weeks ago

Centurion, South Africa Momentum Insure Company Limited Full time

**Introduction**

**Role Purpose**

Establish and lead a world class data analytics/warehouse capability for Momentum Insure to enable future needs for advanced analytics and AI.

Maintain and support:

- Existing MIS databases
- Existing reports and dashboards
- Existing data warehouses

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.

**Requirements**:
**Experience and Qualifications**
- Relevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) - Essential
- Dimensional modelling and/or relevant Microsoft certification - Advantageous
- 3 - 5 years of management experience leading teams of around 5 - 8 people - Essential

**On
- the-job training/qualifications**:

- Microsoft Sql Server
- Oracle
- Power BI
- Advanced MS Excel
- Starquest

Some experience in predictive analytic platforms will be advantageous.

These include:

- Python
- Scala
- Spark
- AWS Sagemaker

Some experience in Azure / AWS platform services will be advantageous. These include:

- Azure SQL elastic instance
- Data factory
- PowerBI
- AWS RDS

**Minimum Experience**

Methodologies

Principles
- Knowledge of Domain driven design would be an advantage

Modelling
- Knowledge of Immon data warehouse modelling techniques would add an advantage

Data Transportation

Development Software
- Dynamic T-SQL
- Multi-threading
- Performance optimisation and tuning
- Knowledge of Database Administration would add an advantage
- Expert knowledge in configuration of database hardware resources

Repository type
- 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

**Duties & Responsibilities**

**Outputs**

**Internal Process**
- 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 re-usable.
- 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.
- 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.

**Role-specific Responsibilities and Outputs**
- Develop, implement and document Business Intelligence Solutions (Internal Process):

- 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
- 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
- Future development and planning

**Self-management and Teamwork**
- 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
- 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.

**Finance**
- Manage financial and other company resources under your control with due respect.

**Competencies**
- Business Acumen
- Client / Stakeholder Commitment
- Drive for Results
- Leads Change and Innovation
- Motivating a

  • Data Warehousing Specialist | Centurion

    4 weeks ago

    Centurion, South Africa The Recruitment Council Full time

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

  • Data Warehousing Specialist | Centurion

    4 weeks ago

    centurion, Gauteng, South Africa The Recruitment Council Full time

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

  • Senior Data Warehousing Specialist

    2 weeks ago

    Centurion, Gauteng, South Africa Talent 101 Full time

    Maintain and support existing MIS databases, reports, dashboards, and data warehouses.Stay updated on developments and trends in data enablement to meet future business needs in the insurance industry.Collaborate with Project Managers and Business Leaders to deliver high-quality management information and data warehouse solutions.Gather requirements, conduct...

  • Data Scientist

    3 weeks ago

    Centurion, South Africa Group Finance Full time

    **Introduction** Through our client-facing brands Metropolitan and Momentum, with Multiply (wellness and rewards programme), and our other specialist brands, including Guardrisk and Eris Property Group, the group enables business and people from all walks of life to achieve their financial goals and life aspirations. We help people grow their savings,...

  • Administration Clerk

    3 weeks ago

    Centurion, South Africa MARTINOGIX WAREHOUSING Full time

    Key Responsibilities More details call or whatsapp 0695838823. 1. Administering all Contract Logistics related documents as per current Processes. Obtain Documents from Cargo-coordinator. Confirm reciptient of manifest documents from the warehouse. Verify the completeness of information on the documents. Invistigate and effect corrections where necessary...

  • Data Warehouse Engineer

    4 weeks ago

    Centurion, South Africa Hire Resolve Full time

    Hire Resolve's client is currently seeking a skilled Data Warehouse Engineer to join their team. As a Data Warehouse Engineer, you will be responsible for designing, implementing, and maintaining the data warehouse infrastructure to support the organization's data storage and retrieval needs. You will work closely with data engineers, database...

  • Data Analyst Intern

    2 months ago

    Centurion, South Africa Group Finance Full time

    **Introduction** Through our client-facing brands Metropolitan and Momentum, with Multiply(wellness and rewards programme), and our other specialist brands, includingGuardrisk and Eris Property Group, the group enables business and people from allwalks of life to achieve their financial goals and life aspirations. **Role Purpose** To serve the Group...

  • Data Engineer

    2 weeks ago

    Centurion, Gauteng, South Africa Network Recruitment Full time

    Qualifications: Relevant IT Degree / Diploma / Certification Requirements:Database design skills with an understanding of data warehousing techniques and approachesUnderstanding of and ability to access data from sources such as: Microsoft SQL Server, Oracle, MongoDB, Amazon S3, Window / Lunix file system, HTTP API's, SFTP sitesCreate reports and BI...

  • Financial Data Integration Specialist

    4 weeks ago

    Centurion, South Africa Momentum Investments Full time

    **Introduction**Role Purpose** - The Financial Data Integration Specialist plays a crucial role in managing and maintaining accurate External Asset Manager (EAM) Holdings and Instrument Static data within the organization's systems. This role involves liaising with financial institutions to obtain monthly statements of clients' investment holdings and...

  • Financial Data Integration Specialist

    2 weeks ago

    Centurion, Gauteng, South Africa Momentum Investments Full time

    IntroductionRole Purpose**- The Financial Data Integration Specialist plays a crucial role in managing and maintaining accurate External Asset Manager (EAM) Holdings and Instrument Static data within the organization's systems. This role involves liaising with financial institutions to obtain monthly statements of clients' investment holdings and ensuring...

  • Data Engineer

    4 weeks ago

    Centurion, South Africa Network Recruitment Full time

    Qualifications: Relevant IT Degree / Diploma / Certification Requirements:Database design skills with an understanding of data warehousing techniques and approachesUnderstanding of and ability to access data from sources such as: Microsoft SQL Server, Oracle, MongoDB, Amazon S3, Window / Lunix file system, HTTP API's, SFTP sitesCreate reports and BI...

  • Data Engineer

    4 weeks ago

    Centurion, South Africa Network Recruitment Full time

    Qualifications: Relevant IT Degree / Diploma / Certification Requirements: Database design skills with an understanding of data warehousing techniques and approaches Understanding of and ability to access data from sources such as: Microsoft SQL Server, Oracle, MongoDB, Amazon S3, Window / Lunix file system, HTTP API's, SFTP sites Create reports and...

  • Data Engineer

    4 weeks ago

    Centurion, South Africa Adzuna ZA B C2 Full time

    Qualifications: Relevant IT Degree / Diploma / Certification Requirements:Database design skills with an understanding of data warehousing techniques and approachesUnderstanding of and ability to access data from sources such as: Microsoft SQL Server, Oracle, MongoDB, Amazon S3, Window / Lunix file system, HTTP API's, SFTP sitesCreate reports and BI...

  • Data Analyst Intern

    2 weeks ago

    Centurion, Gauteng, South Africa Group Finance Full time

    IntroductionThrough our client-facing brands Metropolitan and Momentum, with Multiply(wellness and rewards programme), and our other specialist brands, includingGuardrisk and Eris Property Group, the group enables business and people from allwalks of life to achieve their financial goals and life aspirations.Role PurposeTo serve the Group Finance...

  • Data (Warehouse) Architect - Centurion

    1 week ago

    Centurion, South Africa Ampath Trust Full time

    Advert Reference: P10227 Data (Warehouse) Architect - Centurion Job Title: Data (Warehouse) Architect - Centurion Closing Date: 2024/02/15 Position Available From: 2024-02-08 Area: Centurion Actual Place Of Work: Centurion Position Type: Full-Time Weekly Hours: 40 Time Conditions: 5 day Work Week (South Africa) Purpose of Position: To strategically...

  • Data (Warehouse) Architect - Centurion

    2 weeks ago

    Centurion, Gauteng, South Africa Ampath Trust Full time

    Advert Reference:P10227 Data (Warehouse) Architect - CenturionJob Title:Data (Warehouse) Architect - CenturionClosing Date:2024/02/15Position Available From:Area:CenturionActual Place Of Work:CenturionPosition Type:Full-TimeWeekly Hours:40Time Conditions:5 day Work Week (South Africa)Purpose of Position:To strategically design and implement data warehouses,...

  • Data Scientist

    1 week ago

    Centurion, South Africa Communicate Recruitment Full time

    **One of the big four banks in South Africa is looking for a Senior Decision Scientist!** **Job & Company Description**: **Education & Skills Required**: - 3 years relevant experience in statistical analysis - Experience must include the following (within the retail credit risk management environment): Extracting and aggregating data from large relational...

  • Data Architect

    1 week ago

    Centurion, South Africa Network Recruitment Full time

    As a specialist recruitment consultant within the IT industry, my clients and I are constantly on the lookout for accomplished Data Architects with strong academics, robust project experience and technical knowledge. Requirements: Completed bachelors degree in computer science, engineering, mathematics, statistics or related At least 3 years of relevant...

  • Data Architect

    1 week ago

    Centurion, South Africa Network Recruitment Full time

    As a Specialist Recruitment Consultant within the IT industry, my clients and I are constantly on the lookout for accomplished Data Architects with strong academics, robust project experience and technical knowledge. Requirements:Completed Bachelors degree in computer science, engineering, mathematics, statistics or relatedAt least 3 years of relevant...

  • Data Architect

    1 week ago

    Centurion, South Africa Network Recruitment Full time

    As a Specialist Recruitment Consultant within the IT industry, my clients and I are constantly on the lookout for accomplished Data Architects with strong academics, robust project experience and technical knowledge. Requirements: Completed Bachelors degree in computer science, engineering, mathematics, statistics or related At least 3 years of relevant...