Data Analyst - Stellenbosch, Western Cape, South Africa - PBT Group
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.
- Analyse business requirements from documents and enduser discussions.
- 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.
- 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.
- 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
- 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 datarelated information to Architects, DBA's, Developers and Users.
- Work with modeling tools and data repository to maintain project deliverables.
- 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.
More jobs from PBT Group
-
Software Engineering Lead
Johannesburg, South Africa - 4 weeks ago
-
Senior Bookkeeper
Cape Town, South Africa - 2 weeks ago
-
Data Analyst
Johannesburg, South Africa - 3 weeks ago
-
Data Solutions Architect
Cape Town, South Africa - 3 weeks ago
-
Data Scientist
Cape Town, South Africa - 1 week ago
-
Data Scientist
Cape Town, South Africa - 3 days ago