Data Analyst - Stellenbosch, South Africa - PBT Group

PBT Group Stellenbosch, South Africa

12 hours ago

Full time

Description

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

Commercial Data Analyst

8 hours ago

Armstrong Appointments Stellenbosch, South Africa

The position is based in Stellenbosch and is a hybrid role. · Main job function · Obtain, verify, structure and collate data into dashboards provide insight and enable business performance and evaluation. · Maintain performance score cards and reporting dashboards for employer a ...
Data Analyst

2 days ago

Black Pen Recruitment Cape Town, South Africa

An exciting opportunity awaits a Data Analyst at our client's innovative pay-as-you-go solar startup. Our client makes life better for everyday households in Africa. They build amazing tech to help bring access to energy, internet and opportunity to people who otherwise wouldn't. ...
Data Analyst

1 day ago

Telebest Cape Town, South Africa Contract

Our client has an opportunity available for a Data Analyst. · Requirements: · Data analysis, advanced Excel and Cognos analytics skills. · Bachelor's degree or equivalenting in a numerical or analytical field such as statistics, accounting and or computer science. · 3 to 5 years ...
Data Analyst

3 days ago

Shoprite Cape Town, South Africa Full time

About the Team · ShopriteX was established to accelerate the use of data to improve customer experience and business operations. Our Agile way of working allows for flexibility to grasp new opportunities and quickly transform them into insights that will have a direct impact on ...
Data Analyst

4 days ago

Construct Education Cape Town, South Africa Full time

Location: Cape Town · Working Practices: Minimum two days a week in the office with option to work remotely for remaining days · Employment type: Permanent · Role summary: · The primary purpose of this role is to support and enhance the student experience by providing actionabl ...
Data Analyst

4 days ago

Parvana Cape Town, South Africa Permanent

About our client: · If you are looking for a meaningful and impactful contribution to philanthropic initiatives while earning well and working for a dynamic, organised and innovative global organisation, this employer is well worth considering. · What you will be doing: · Colla ...
Data Analyst

23 minutes ago

Collinson Cape Town, South Africa

Collinson Group is a global leader in driving loyalty and engagement for many of the world's largest companies. Predominantly through the provision of travel related benefits within a market leading digital travel ecosystem. The group offers a unique blend of industry and sector ...
Data Analyst I

2 days ago

ShopriteX Brackenfell, Cape Town, ZA, South Africa Full time

About the Team ShopriteX was established to accelerate the use of data to improve customer experience and business operations. Our Agile way of working allows for flexibility to grasp new opportunities and quickly transform them into insights that will have a direct impact on str ...
Global Data Analyst

12 hours ago

Dentons Cape Town, South Africa Full time

The Global Business Technology (GBT) department is essential to meet the Firm's strategic vision. We help to align technology services with the Firm's objectives. This alignment is essential for providing excellent service and value to the firm and its stakeholders. The Firmwide ...
Data Analyst – R450

8 hours ago

Paton Personnel CapeTown, South Africa

Leading analytics consultancy that uses data to guide strategy and drive business performance has a Data Analyst role available based in Cape Town. · Responsible for developing business cases/insights, preparing reports, and creating/improving BI solutions. · The ideal candidate ...
Data Reporting Analyst

8 hours ago

HR Genie Cape Town, South Africa

Data Reporting Analyst Cape Town CBD, South Africa · R R Per Annum Negotiable on Qualification and Years of Relevant Experience · Global Engineering firm is currently expanding and in search of highly dependable and effective Data Reporting Analyst to be responsible for the desi ...
Senior Data Analyst

4 days ago

Datonomy Solutions Cape Town, South Africa

We are looking for a Senior Data Analyst to join our team in Cape Town. · 3 days (Tuesday, Wednesday & Thursday) onsite in Southern Suburbs. · Retail experience · Analytical degree (maths, stats, engineering) · Advanced SQL · Power Bi · Strong interpersonal skills, as you will be ...
Data Business Analyst

3 days ago

Silk Road Consulting (Pty) Ltd Cape Town, South Africa Full time

Vacancy Alert: Data Warehouse Business Analyst · Cape Town: Northern Suburbs · To play a crucial role in bridging the gap between business needs and technical solutions within the realm of data warehousing. This role involves understanding business requirements, analysing data so ...
Snr Data Analyst

3 days ago

IOCO Cape Town, South Africa

We are looking for a dynamic Data Analyst to join our team... · Overview · This role is individually accountable for turning data into actionable insights. The incumbent will be responsible for providing first-line analysis and support and escalation of data reconciliation items ...
Data Warehouse Business Analyst

3 days ago

Scholtz Partners International Belville, South Africa Full time

Brief description of the vacancy: · To play a crucial role in bridging the gap between business needs and technical solutions within the realm of data warehousing. This role involves understanding business requirements, analysing data sources, and collaborating with stakeholders ...
Data Warehouse Business Analyst

12 hours ago

Silk Road Consulting (Pty) Ltd Cape Town, South Africa Full time

Vacancy Alert: Data Warehouse Business Analyst · Cape Town: Northern Suburbs · The Data Warehouse Business Analyst will play a crucial role in bridging the gap between business needs and technical solutions within the realm of data warehousing. This role involves understanding bu ...
Data Analyst Marketing and Fundraising

1 day ago

Tower Group Cape Town, South Africa Full time

Our client in Grassy Park is looking for a BA Analyst to join their team, someone who has worked at a Welfare and fundraising CRM platforms before. · Position Overview: We're seeking a skilled Data Analyst to join our team and play a pivotal role in maintaining our central datab ...
Investments Data Operations Analyst

12 hours ago

Rory Mackie & Associates Cape Town, South Africa Contract

The Investments Data Operations Analyst will form part of the Data Operations Team. They are custodian of the Security Master, Benchmark Master and Portfolio Accounting products. · The team is the interface between the business and third-party vendors. The role will involve frequ ...
Tax Data Analyst/Tester

3 days ago

Progressive IT Resourcing Cape Town, South Africa Contract

This role is mainly responsible for validating and reconciling data from multiple sources and applying relevant tax knowledge to ensure extensive accuracy thereof. The data relates to client investment activities and the various tax implications thereof. A basic understanding of ...
senior specialist: biodiversity data analyst

8 hours ago

Premium Consulting Cape Town, South Africa

SENIOR SPECIALIST: BIODIVERSITY DATA ANALYST · EXPERIENCE AND KNOWLEDGE: · degree in Natural Sciences, Life Sciences (Ecology, Biology, Botany), Computer · Science or equivalent qualification with NQF 7 with 6 years working experience in analysis and remediation of data of which ...