Data Analyst

4 weeks ago


Stellenbosch, South Africa PBT Group Full time

PBT Group is looking for a talented Data Analyst who will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end-users to develop differentiating business insights. Data Analysts should be skilled in SAS, GCP, Python and Hex.

 

We are looking for an individual with experience in using a variety of data tools, analysis methods and data visualization to turn data into actionable insights with demonstrable business impact.

 

Duties

  • Analyse business requirements from documents and end-user discussions.
  • Identify and define the data requirements necessary to support business requirements or integrated application and subject areas.
  • Identify and define the security requirements necessary to protect the data items.
  • Identify and define the business rules associated with the data; these should include all data integrity / constraint requirements.
  • Identify and perform detailed analysis of all data sources for each application and subject area.
  • 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.
  • 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.
  • Assist ETL Analysts to draw up data cleansing specifications.
  • Present data quality anomalies and problem areas to business users and source system owners.
  • Validate data models against the business- and data requirements.
  • Ensure the quality, accuracy, integrity and conformity to standards of all models.
  • Provide accurate metadata, which allows full understanding of the project data components.
  • Coordinate and synchronise data models with process and technical models.
  • Identify data and data model inconsistencies and conflicts and assist the users in their resolution.
  • Transition information and assist the DBA’s with physical implementation of the data models.
  • Transition information and assist develops with the data mapping and transformation and provide additional data analysis as required during the development phase.
  • Communicate project data-related information to Architects, DBA’s, Developers and Users.
  • Work with modeling tools and data repository to maintain project deliverables.

Skills Required

  • Skilled in SAS, GCP, Python and Hex.
  • Need to be able to speak to Business and do Visualisation.
  • 5+ years’ experience in Data Analysis
  • Experience in building Conceptual Data Models
  • Ability to use SQL to query data in RDBMS
  • Analysis source systems data and testing the Conceptual Data Models
  • Experience in testing data, auditing data techniques a plus
  • Experience in Data migration projects
  • Experience in NoSQL environments would be an advantage

 

REQUIRED QUALIFICATIONS / TRAINING:

  • Relevant data warehouse and BI solution training is essential.
  • Sc. or related degree is advantageous.
  • 5+ years programming experience.

 

 

* In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent

 


  • Data Analyst

    2 weeks ago


    Stellenbosch, Western Cape, South Africa PBT Group Full time

    PBT Group is looking for a talented Data Analyst who will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end-users to develop differentiating business insights. Data Analysts should be skilled in SAS, GCP, Python and Hex.We are looking for an individual with experience in using a variety...

  • Data Analyst

    4 weeks ago


    Stellenbosch, South Africa Unifi Recruitment Full time

    **Job Advert Summary**: Unifi is a fast-growing finance and technology company operating in Zambia, South Africa, Uganda and Kenya. Unifi delivers personal lending products through online, mobile phone and branch channels. The company is well supported by strong shareholders and a board of directors with vast experience in entrepreneurship...

  • Data Analyst

    3 months ago


    Stellenbosch, South Africa PBT Group Full time

    PBT Group is looking for a talented Data Analyst who will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end-users to develop differentiating business insights. Data Analysts should be skilled in SAS, GCP, Python and Hex. We are looking for an individual with experience in using a...

  • Data Analyst

    3 months ago


    Stellenbosch, South Africa PBT Group Full time

    PBT Group is looking for a talented Data Analyst who will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end-users to develop differentiating business insights. Data Analysts should be skilled in SAS, GCP, Python and Hex. We are looking for an individual with experience in using a...

  • Data Analyst

    4 weeks ago


    Stellenbosch, South Africa PBT Group Full time

    PBT Group is looking for a talented Data Analyst who will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end-users to develop differentiating business insights. Data Analysts should be skilled in SAS, GCP, Python and Hex. We are looking for an individual with experience in using a...

  • Data Analyst

    4 weeks ago


    Stellenbosch, South Africa PBT Group Full time

    PBT Group is looking for a talented Data Analyst who will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end-users to develop differentiating business insights. Data Analysts should be skilled in SAS, GCP, Python and Hex. We are looking for an individual with experience in using a...

  • Data Analyst

    2 weeks ago


    Stellenbosch, Western Cape, South Africa Unifi Africa Full time

    Unifi is a fast-growing finance and technology company operating in Zambia, South Africa, Uganda and Kenya.Unifi delivers personal lending products through online, mobile phone and branch channels. The company iswell supported by strong shareholders and a board of directors with vast experience in entrepreneurship andlending. Unifi is recruiting a new BI...

  • Data Analyst

    2 weeks ago


    Stellenbosch, Western Cape, South Africa Unifi Recruitment Full time

    Job Advert Summary:Unifi is a fast-growing finance and technology company operating in Zambia, South Africa, Uganda and Kenya.Unifi delivers personal lending products through online, mobile phone and branch channels. The company iswell supported by strong shareholders and a board of directors with vast experience in entrepreneurship andlending.Unifi is...


  • Stellenbosch, South Africa MSCI Inc Full time

    Job Description - Financial Data Analyst (Accounting Data) (240000CC) - Job Number: 240000CC Requisition Title : Financial Data Analyst (Accounting Data) **Description**: **Your team responsibilities** Accounting Data Analysts are responsible for the continuous maintenance and development of MSCI’s Accounting Data Service offered to clients invested in...

  • Data Analyst

    2 weeks ago


    Stellenbosch, Western Cape, South Africa Unifi Africa Full time

    Unifi is a fast-growing finance and technology company operating in Zambia, South Africa, Uganda and Kenya.Unifi delivers personal lending products through online, mobile phone and branch channels. The company iswell supported by strong shareholders and a board of directors with vast experience in entrepreneurship andlending. Unifi is recruiting a new BI...


  • Stellenbosch, Western Cape, South Africa MSCI Inc Full time

    Job Description - Financial Data Analyst (Accounting Data CC)Job Number: 240000CCRequisition Title : Financial Data Analyst (Accounting Data)Description:Your team responsibilitiesAccounting Data Analysts are responsible for the continuous maintenance and development of MSCI's Accounting Data Service offered to clients invested in public and private markets...


  • Stellenbosch, South Africa MSCI Inc Full time

    Job Description - Financial Data Analyst (Holding Transactions) (2300012I) - Job Number: 2300012I Requisition Title : Financial Data Analyst (Holding Transactions) **Description**: TEST **Job**: Data Services - **Primary Location**: South Africa-Western Cape-Stellenbosch - **Job Profile**: Analyst - **Time Type**: Full Time - **Department**: Data...


  • Stellenbosch, South Africa MSCI Inc Full time

    Job Description - Financial Data Analyst (2400003V) - Job Number: 2400003V Requisition Title : Financial Data Analyst **Description**: **Your team responsibilities** ***The Analyst, Private Capital Solutions is responsible for aggregation and reporting of underlying portfolio company investments of private capital investment partnerships. Data is...

  • Data Analyst

    3 weeks ago


    Stellenbosch, Western Cape, South Africa PBT Group Full time

    PBT Group is looking for a talented Data Analyst who will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end-users to develop differentiating business insights. Data Analysts should be skilled in SAS, GCP, Python and Hex. We are looking for an individual with experience in using a...

  • Data Analyst

    2 weeks ago


    Stellenbosch, Western Cape, South Africa Herotel Full time

    Herotel is seeking a highly motivated Data Analyst responsible for collecting, analysing and interpreting large sets of data to inform and support business decisions. The role will involve using statistical techniques to identify patterns and trends, creating visualizations and reports to communicate findings to non-technical stakeholders, and collaborating...


  • Stellenbosch, South Africa MSCI Inc Full time

    Job Description - Financial Data Analyst (2400007R) - Job Number: 2400007R Requisition Title : Financial Data Analyst **Description**: **Your team responsibilities** Private Capital Solutions Data Operations is responsible for the aggregation, structuring and quality assurance of all private capital data in support of our portfolio risk and performance...


  • Stellenbosch, Western Cape, South Africa MSCI Inc Full time

    Job Description - Financial Data Analyst (IBOR IY)Job Number: 240000IYRequisition Title : Financial Data Analyst (IBOR)Description:Your team responsibilitiesThe IBOR Analyst is Responsible for maintaining Investment Book of Records (IBOR) data. Data is compiled by the examination and analysis of direct fund manager reporting and other sources. This...

  • Junior Data Analyst

    2 weeks ago


    Stellenbosch, Western Cape, South Africa Latitude Resource Full time

    An established niche agricultural consultancy, analytics and software development company based in Stellenbosch is seeking to employ a Junior Data Analyst on permanent basis.Please note that graduates will be considered.Must have requirements (most or all of the below) Diploma/Degree in data science, data engineering, computer science, agriculture or...

  • Data Analyst

    2 weeks ago


    Stellenbosch, Western Cape, South Africa WatersEdge Solutions Full time

    Our client is looking for a Junior Actuarial / Data Analyst to become an integral member of their collaborative team. Our work environment is fast-paced and exciting. It is a good fit for someone with a curious mindset, who is driven and thrives on learning. They are a South African-based actuarial consulting firm. They offer bespoke solutions that are...


  • Stellenbosch, Western Cape, South Africa RPO Recruitment Full time

    We are looking for an experienced Data Analytics Analyst to support the data pipeline strategies and objectives across the business whilst maintaining data integrity and building data reports. You will be responsible for guiding end-to-end processes, standards, and guidelines to ensure accurate and efficient data delivery of tasks and projects. This role...